Скачать или смотреть 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 Table ...  

2️⃣ Introduction to Power Pivot & DAX:
   • Excel Power Pivot Introduction - Understan...  

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 : Quick a...  
2️⃣ 10 Advanced Pivot table tricks - Part 1:
   • 10 ADVANCED PIVOT TABLE TECHNIQUES & TRICK...  
3️⃣ 10 Advanced Pivot table tricks - Part 2:
   • 10 more ADVANCED PIVOT TABLE TECHNIQUES & ...  

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/