GROUPBY and PIVOTBY function in excel | PIVOT TABLE KILLERS?
In this video, we explain the NEW GROUPBY function and the PIVOTBY function in excel which can produce pivot table like results. We show how the GROUPBY and PIVOTBY functions work and we explain the different arguments or inputs for the GROUPBY and PIVOTBY functions in Excel
The GROUPBY and PIVOTBY functions in Excel are brand new functions that are currently only available for Excel 365 signed up for the beta channel in the Microsoft insider program
Download Example files:
http://tinyurl.com/2dwc9maa
How to join the Microsoft insider program and beta channel:
https://insider.microsoft365.com/en-u...
Related videos:
1️⃣ How to show text in the values are of a pivot table:
• Show TEXT in VALUES AREA of a Pivot T...
2️⃣ Introduction to Power Pivot & DAX:
• Excel Power Pivot Introduction - Unde...
GET 15% OFF my Excel PowerPivot for beginners Course. Use discount code YOUTUBE15 at checkout (Limited time offer!)
https://tinyurl.com/4ayp2457
Watch some of my previous videos about Pivot tables:
1️⃣Learn Pivot tables in 10 minutes:
• LEARN PIVOT TABLES IN 10 MINUTES : Qu...
2️⃣ 10 Advanced Pivot table tricks - Part 1:
• 10 ADVANCED PIVOT TABLE TECHNIQUES & ...
3️⃣ 10 Advanced Pivot table tricks - Part 2:
• 10 more ADVANCED PIVOT TABLE TECHNIQU...
TIMESTAMPS:
00:00 Introduction
00:31 GROUPBY function
09:29 Cool trick: Show text in the values area using a LAMBDA with ARRAYTOTEXT, UNIQUE and SORT functions
11:53 PIVOTBY function
14:55 Conclusion: Pivot tables vs GROUPBY and PIVOTBY functions
15:27 Learn more about Power Pivot and DAX in Excel! + Special course offer
Follow us on Social Media:
Facebook: / excelbonanza
Twitter: / excelbonanza
Follow me on Linkedin: / abdelrahman-abdou-60240150
Instagram: / excelbonanza1
TikTok: / excelbonanza
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com
****My online Excel Courses****
https://www.excelbonanza.com/courses/
