The GROUPBY & PIVOTBY functions as alternatives to PivotTables.
👩‍🏫 LEARN MORE in my Excel courses: bit.ly/groupbypivotby

Disclaimer: GROUPBY and PIVOTBY are currently in Beta and are only available to 50% of Microsoft 365 Insiders.

The problem with PivotTables is that you have to manually click the "Refresh All" button to update them when your source data changes. But the new GROUPBY and PIVOTBY functions solve that by enabling you to easily group and aggregate in a formula. However, one of the best things about PivotTables are Slicers that allow you to quickly filter the data at the click of a button. Let's check out these exciting new functions, and I'll show you a trick that allows you to use Slicers with them, so you never need to use a PivotTable again.

LEARN MORE
===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: myonlinetraininghub.com/excel-newsletter-sign-up

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 FOLLOW me on LinkedIn: linkedin.com/in/myndatreacy/

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: myonlinetraininghub.com/excel-forum

#PivotTable #GROUPBY #PIVOTBY

• You DON'T Need PivotTables Anymore (Here Is Why) ( Download)
• This is BETTER than a pivot table! ( Download)
• I don't use PIVOT tables anymore... I use this other thing instead! ( Download)
• Try This New Formula Instead of Pivot Tables ( Download)
• Learn Power Pivot in Excel (Better Than Pivot Tables) ( Download)
• Is this Brand NEW Function Better than Pivot Tables ( Download)
• Pivot Table vs a Power Pivot based Pivot Table ( Download)
• Pros Use This Technique to Avoid PivotTables ( Download)
• Why EVERY Excel User Needs Power Query & Power Pivot ( Download)
• Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) ( Download)
• Master Pivot Tables in 10 Minutes (Using Real Examples) ( Download)
• I don't use Pivot tables in Excel... and it has helped my career growth ( Download)
• Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
• Best Pivot Table Design Tips to Impress Anyone ( Download)
• The QUERY Function Versus Pivot Table: Similarities + Differences + When To USE ( Download)