Uploaded February 2025 | Updated September 2026, 48 minutes ago
🔥 400,000+ professionals trust our courses—become an Excel Black Belt 👉 xelplus.com/course/excel-black-belt
or checkout our other courses: xelplus.com/courses
GROUPBY Availability: The GROUPBY function is now generally available to all Office 365 users in the current channel for now. This means if your company has opted into regular monthly updates, you should already have it. But generally companies are conservative with updates and you might only get this function in July 2025 or later in the year. But it is coming!
Excel GROUPBY function is
Most people think the Excel GROUPBY function is just for basic data grouping - similar to what an Excel pivot table can do. But did you know it can do much more? You can:
✅ Count unique items with GROUPBY
✅ Get a distinct list of values using a lambda in GROUPBY
✅ Apply multiple calculations to the same column
✅ Group data dynamically
...and much more!
In this video, I'll show you 7 advanced Excel tricks for the GROUPBY function that will take your Excel skills to the next level.
00:00 What GROUPBY Can Really Do
00:30 GROUPBY Basics – Quick Refresher
02:22 Grouping Non-Adjacent Columns
03:41 Showing Multiple Aggregations for the Same Column
04:59 Excel GROUPBY count unique
07:25 Properly Formatting the Total Row
09:30 Sorting GROUPBY Results
11:57 Grouping by Multiple Values with Different Aggregations
13:44 Returning a List of Items Instead of Counts
15:00 Wrap Up
🔗 Grab the Practice File here: pages.xelplus.com/groupby-tricks-file
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
Excel GROUPBY & PIVOTBY Functions: youtu.be/mCJzhCxEQlM
Excel LAMBDA - HOW & WHEN you Should use it: youtu.be/Rm4y5UqauRw
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
🔥 400,000+ professionals trust our courses—become an Excel Black Belt 👉 xelplus.com/course/excel-black-belt
or checkout our other courses: xelplus.com/courses
GROUPBY Availability: The GROUPBY function is now generally available to all Office 365 users in the current channel for now. This means if your company has opted into regular monthly updates, you should already have it. But generally companies are conservative with updates and you might only get this function in July 2025 or later in the year. But it is coming!
Excel GROUPBY function is
Most people think the Excel GROUPBY function is just for basic data grouping - similar to what an Excel pivot table can do. But did you know it can do much more? You can:
✅ Count unique items with GROUPBY
✅ Get a distinct list of values using a lambda in GROUPBY
✅ Apply multiple calculations to the same column
✅ Group data dynamically
...and much more!
In this video, I'll show you 7 advanced Excel tricks for the GROUPBY function that will take your Excel skills to the next level.
00:00 What GROUPBY Can Really Do
00:30 GROUPBY Basics – Quick Refresher
02:22 Grouping Non-Adjacent Columns
03:41 Showing Multiple Aggregations for the Same Column
04:59 Excel GROUPBY count unique
07:25 Properly Formatting the Total Row
09:30 Sorting GROUPBY Results
11:57 Grouping by Multiple Values with Different Aggregations
13:44 Returning a List of Items Instead of Counts
15:00 Wrap Up
🔗 Grab the Practice File here: pages.xelplus.com/groupby-tricks-file
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
Excel GROUPBY & PIVOTBY Functions: youtu.be/mCJzhCxEQlM
Excel LAMBDA - HOW & WHEN you Should use it: youtu.be/Rm4y5UqauRw
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
