Exploring the GROUPBY Function in Excel

In this video, I introduce and explore the new 'GROUPBY' function in Excel, currently available only for beta channel users on both Windows and Mac. We dive in-depth into the features of the function with examples, such as grouping by car brands, summing up the revenue, and applying various Excel functions.

I also discuss all the available arguments, how to format them correctly, and how to include additional fields like the cost column. I show how to play around with other attributes like sort order and filters. This real-time exploration allows you to see immediate changes without the need to refresh like in pivot tables. Stay tuned to further explore the 'PIVOTBY' function in my upcoming video.

Excel GROUPBY Function Support Article:

New aggregation functions in Excel article:

Feel free to check out my online Excel training course for more detailed tutorials:

Chapters:

00:00 Introduction
00:38 Getting Started with GROUPBY Function
01:08 Exploring the Arguments of GROUPBY Function
02:11 Applying the GROUPBY Function to Data
02:39 Exploring Additional Features of GROUPBY Function
06:07 Sorting and Filtering with GROUPBY Function
07:56 Comparing GROUPBY Function with PivotTables
08:48 Conclusion

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

#excel #groupby #chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[johnborg]

Great Function. I am on BETA and I've been experimenting with Groupby and Pivotby. Great Functions. :) :) Thanks Chris.

[marnelbenavides]

Thank you for helping… I truly value your videos.

[ShazEire]

this looks neat! can't wait to get it 🙂

[xvxwvsh]

Hi, Chris, thanks for your powerful knowledge .
I use an Excel file including 20 or more sheets to download from internet, some stock data, like date, open, high, low, close, volume. Problem is Number Stored in Text. I have to convert each sheet into Number. You must have some great ideas to fix it, do you?