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!

Speaker:

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:

• Webinar recording: Unfortunately we have encountered a technical issue that is limiting our access to some on-demand recordings on the Zoom platform. We are currently working with Zoom to establish a resolution but as it stands we do not have a timeframe for this. We apologise for the inconvenience.
• Webinar workbook
• Your questions answered
• 20 principles for good spreadsheet practice
• Spreadsheet competency framework
• Financial modelling code
• How to review a spreadsheet