Learn the GROUPBY Function in Excel to replace Pivot Tables.
🚀Get the FREE Data Analytics Guide from Hubspot: https://clickhubspot.com/g8g
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/g1vkx5bo9d
Stop using pivot tables, you can use the new GROUPBY function in Excel instead. This function is better because it updates automatically. For example, when the original data changes, the pivot table doesn't update. Instead, you need to press the refresh button every time. However, because the GROUPBY is a function, it updates automatically. We'll also cover the PIVOTBY function, which unlike the GROUPBY also allows for column input values. In this video we'll go over the GROUPBY and the PIVOTBY step by step through all the conditions such as sorting, filtering, adding field headers, and total depth.
LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: https://www.careerprinciples.com/all-courses
SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - The Problem with Pivot Tables
1:06 - GROUPBY Function
2:45 - GROUPBY with % of Total
5:18 - GROUPBY Adding Headers and Totals
6:45 - Sorting with GROUPBY
7:35 - Adding More Than One Row
8:40 - Filtering with GROUPBY
9:49 - PIVOTBY Function