Excel GROUPBY Hacks to Instantly Improve Your Reports!

🔥 400,000+ professionals trust our courses—become an Excel Black Belt 👉 https://www.xelplus.com/course/excel-black-belt/ or checkout our other courses: https://www.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: https://pages.xelplus.com/groupby-tricks-file 📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 🎬 LINKS to related videos: Excel GROUPBY & PIVOTBY Functions: https://youtu.be/mCJzhCxEQlM Excel LAMBDA - HOW & WHEN you Should use it: https://youtu.be/Rm4y5UqauRw 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ More resources on my Amazon page: https://www.amazon.com/shop/leilagharani 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.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