Learn the GROUPBY Function in Excel to replace Pivot Tables.
🚀Get the FREE Data Analytics Guide from Hubspot: clickhubspot.com/g8g

🆓 DOWNLOAD Free Excel file for this video: 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: careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: careerprinciples.com/courses

SOCIALS:
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑‍💻 LinkedIn - 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

• Try This New Formula Instead of Pivot Tables ( Download)
• Excel GROUPBY & PIVOTBY Functions - All You Need to Know (do they BEAT Pivot Tables 🤔) ( Download)
• You DON'T Need PivotTables Anymore (Here Is Why) ( Download)
• I don't use PIVOT tables anymore... I use this other thing instead! ( Download)
• Try This New Formula Instead of Pivot Tables | You DON'T Need Pivot Tables Anymore ( Download)
• Replace Pivot Tables with the GROUPBY function in Excel ( Download)
• You Won't Believe These Crazy PIVOT TABLE Hacks! ( Download)
• Pivot Table Excel Tutorial ( Download)
• Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
• I don't use Pivot tables in Excel... and it has helped my career growth ( Download)
• This is BETTER than a pivot table! ( Download)
• How Can I Show Text in the PivotTable Values Area Instead of Numbers | Display Unique Text Values ( Download)
• Learn Pivot Tables in 6 Minutes (Microsoft Excel) ( Download)
• You DON'T Need Pivot Tables Anymore... Try GroupBy and PivotBy Instead! ( Download)
• Learn Power Pivot in Excel (Better Than Pivot Tables) ( Download)