In today’s video, we’ll talk about Excel’s new GROUPBY function. This new function can replace some old ones like UNIQUE, SUMIF, and SUMIFS, and make your work much easier. Let’s see how it works!So, WATCH this video now and THANK me later
🚀📈 Join us on this #Excel & #PowerBI adventure and Don't forget to hit that like button, SUBSCRIBE for more Excel mastery, and let the dynamic journey begin!
#groupby #unique #sumifs #sumif
Chapters:
0:00 Introducation to GROUPBY function
0:19 Use of UNIQUE, SUMIF and SUMIFS
2:43 What is GROUPBY Function?
3:10 How to use GROUPBY function with examples
5:40 When to Use GROUPBY function
5:57 Wrap-up
File link to download:
https://docs.google.com/spreadsheets/...
New PERCENTOF function: • NEW Excel Function - PERCENTOF with Comple...
GROUPBY and PIVOTBY functions: • Master the New GROUPBY & PIVOTBY Functions...
XLOOKUP Guide: • The Ultimate XLOOKUP formula Tutorial (The...
Hand Drawn Charts in Excel: • Hand Drawn charts in EXCEL to draw attenti...
Python in Excel Part 1: • Introducing Python in Excel - Financial An...
Python in Excel Part 2: • Python in Excel - Dynamic Financial Dashbo...
Power Query Series: / playlist
list=PLAJojq_HX3tYVVd0bT42Qsu0GwFa9z5-9
JOIN us for more FUN:
/ @chethanapixel
Play List: / chethana
Instagram: /
Facebook: / chethanapixel
Twitter: / chethanapixel
Thank you!!!