Spreadsheet review tools within Excel

In November 2021 the ICAEW published a thought leadership paper, How to Review a Spreadsheet, to which we contributed. This webinar is the third in our 2022 series on the review techniques it covers.

It looks at the features built into Excel that we recommend for reviewing spreadsheets: the strengths and weaknesses of each, when to use which and how each one has found errors in real models.

What you will learn

Learn the review tools built into Excel
Choose the right tool for each review task
Apply practical techniques when you review a spreadsheet

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Financial Model Review

Error classes, testing technique and where AI-assisted financial model review earns its place. 1-day course from our award-winning Model Audit team.

View full course details: Financial Model Review

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Webinars

Reviewing a spreadsheet with sparklines

Spotting errors with sparklines, from the same How to Review a Spreadsheet series.

Delta sheets for analysing financial models

Delta sheets that support the review of sensitivities and scenarios in a model.

Services

Financial Model Audit

We rebuild your model in our own template to test every reported output, whatever the transaction. More than 2,000 transaction models audited, with a red flag report in under 5 working days.

How to review a spreadsheet: tools within Excel