Master the New GROUPBY & PIVOTBY Functions in Excel

The ultimate GROUPBY and PIVOTBY functions tutorial in Excel.

In this video, you'll learn how to use Excel's New GROUPBY and PIVOTBY functions. For this, we'll use 5 real-world examples, from easy to hard. First, we'll go over a basic GROUPBY to calculate the sum of revenue by category. Then, we'll introduce further customization like adding the headers and totals to the answer. Third, we'll show you how to filter and sort with GROUPBY. Fourth, we'll calculating multiple metrics (sum, percentage, and average) at once using the HSTACK function with GROUPBY. Finally, we'll introduce the PIVOTBY function and how it's different. As a bonus, we'll showcase the subtotal grouping feature hardly anyone knows! Please note that GROUPBY and PIVOTBY are only available for Excel 2021 and Microsoft 365 users.

LEARN:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Level 1
1:28​ - Level 2
2:41​ - Level 3
5:04​ - Level 4
8:35​ - Level 5
9:32​ - Bonus

[UjVenah-mput]

Hi Kenji, you are really making online teaching look and feel so physical, thumbs up to you in multiples 👍👍👍👍👍👍👍

[pmanns]

Thanks for this short but very effective session on Groupby & Pivotby. You have simplified this well enough for good and clear understanding on how both functions work well in Excel.

[psychologistmostafa]

Thanks for simplifying this formula, but I guess pivot table is still solid. ❤

[antoniop.]

Once again, I learned new things with you. Thank you very much, Kenji!

[LOSURFNDANCE]

Thanks Kenji, you made it so easy to understand ❤️

[oumardiakite]

Quite good functions. Pretty good explaination. I like it. Just a question: how to make weighted average?

[kimsadowski]

The course I need is finding variances by employee between payroll benefits collected and third party invoices received for the benefits. The datasets are huge. I am no stranger to excel, and I need to brainstorm together on this with someone who is an objective observer. My boss has an OK solution, but it is just soul-sucking and not user-minimal. There are many Accountants struggling with this. Please consider my plea.

[sailorsenshi]

Thanks for the video, awesome content

[Unknown_Channel]

Is it possible to use the groupby function acroos multiple sheets, ?

[Mixolydian]

can you incorporate start and end date criteria in the GROUPBY function?

[TheWhitePele]

Appreciate your work, but still no function can replace the Pivot table because it is more powerful and has hidden formulas which result in zero no human error.

[shankhadas]

Do i need to activate any option for the captioned working?

[suddu_shetty]

3:42 You filtered data for 'Mike'. Can we use 2 filters, like 'Mike' and 'Region'? Thanks.

[alexisaraujo]

como activo esas funciones?, ni en mi excel en español ni en ingles aparece :(

[josuechavez]

Whats the beneift of using PIVOTBY instead of using a PIVOT table? Seem to do the same.

[jagadeesh]

Not showing groupby function in my excel 2021. Anyone helps me ??