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:
https://support.microsoft.com/en-us/o...

New aggregation functions in Excel article:
https://insider.microsoft365.com/en-u...

Feel free to check out my online Excel training course for more detailed tutorials:
https://courses.chrismenardtrainind.com

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 --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit

#excel #groupby #chrismenard
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/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!