ICAEW.com works better with JavaScript enabled.
Exclusive

Critical Skills Excel series - GROUPBY/PIVOTBY replace traditional PivotTables

Author:

Published: 06 Oct 2026

Exclusive content
Access to our exclusive resources is for specific groups of users and members.
Log in Find out more
Microsoft Excel’s GROUPBY function is a game-changing alternative to PivotTables, offering automatic refreshes, custom aggregations, new functions and support for modern chart types. Join David for a deep dive into everything GROUPBY can do.

This webinar covers:

  • Some new advanced features for PivotTables
  • GROUPBY and PIVOTBY basics
  • Some custom calculations
  • What you still needs Pivots for
  • How to do multiple columns with GROUPBY

This webinar has closed captions enabled. In order to enable this feature, please click on the subtitles icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

Critical Skills Excel series - GROUPBY/PIVOTBY replace traditional PivotTables Microsoft Excel’s GROUPBY function is a game-changing alternative to PivotTables, offering automatic refreshes, custom aggregations, new functions and support for modern chart types. Join David for a deep dive into everything GROUPBY can do.