Excel's GROUPBY and PIVOTBY explained

Excel's new functions, GROUPBY and PIVOTBY, offer a smarter way to build reports.

Instead of relying on traditional pivot tables, these new tools allow you to summarise datasets using dynamic, formula-based solutions that update automatically when the underlying data changes.

In this episode:

• Understand the key differences between GROUPBY and PIVOTBY

• See how these tools can save time and reduce manual errors

• Explore practical applications for accountants and analysts

• Discover how to modernise reporting with flexible, auto-updating formulas

For fast reference use the episode…