ICAEW.com works better with JavaScript enabled.

A comprehensive guide to PivotTables (2022 webinar)


Published: 21 Feb 2022

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
Join David Lyford-Tilley as he walks you through everything you need to know about summarising and condensing your data using Excel’s famous PivotTables.

You will learn:

  • How to best structure your data for PivotTable success
  • How to make summaries quickly and easily
  • Formatting and layout tips for consistent readability
  • How to filter and drill down to explore your data
  • The latest additions to the PivotTable arsenal
  • Plus an intro to the potent Power Pivot!


David Lyford-Tilley: David is an Excel specialist and an ICAEW Technical Manager. He was previously with BDO as a senior Excel specialist, working on Excel training and education. David runs the popular blog series for the Excel Community called ‘Tip of the Week’. David also works with ICAEW Excel Community Advisory Committee, providing guidance and input to the work of the committee.

First broadcast on 22 February 2022

Webinar resources: