New Functions now generally available: GROUPBY and PIVOTBY [+Free Cheat Sheet]

Remember that GROUPBY & PIVOTBY video I shared a few months ago?

Well, they're finally here for all Excel 365 users!

🔗 To go along with the video and practice file, I've created a hi-res cheat sheet you can download that explains how to use these functions.

Here's the deal:

These functions are like PivotTables, but more flexible and often faster.

I've been testing them since the beta, and they're pretty cool for:

- Quickly summarizing large datasets
- Creating multi-level reports without the Pivot Table UI
- Easily filtering data on the fly

- Instant updates (no need to refresh)

It's not about replacing PivotTables, but having more tools in your Excel toolkit.

Give them a try and let me know what you think!