The ultimate GROUPBY and PIVOTBY functions tutorial in Excel.
Take our Data Analyst Program: https://www.careerprinciples.com/career-track/the-data-analyst-program
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/a71c081qvv
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:
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Level 1
1:28 - Level 2
2:41 - Level 3
5:04 - Level 4
8:35 - Level 5
9:32 - Bonus