The GROUPBY & PIVOTBY functions as alternatives to PivotTables.
👩‍🏫 LEARN MORE in my Excel courses: https://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: https://www.myonlinetraininghub.com/e...

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

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

🎯 FOLLOW me on LinkedIn:   / 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: https://www.myonlinetraininghub.com/e...

#PivotTable #GROUPBY #PIVOTBY