Skip to content

Reviewing a spreadsheet with sparklines

How Excel sparklines help you review a spreadsheet, with the features to use and real examples of errors that sparklines helped our team find.

Webinar · Recording · Presented by Ryan Humphrey · 9 March 2022

From our archive

This webinar opened our 2022 series on spreadsheet review techniques. The techniques still apply. For our more recent work on model review, watch Financial model review pitfalls and how to avoid them.

In November 2021 the ICAEW published a thought leadership paper, How to Review a Spreadsheet. We contributed to the paper, and this webinar opened our series on the review techniques it covers that matter most in practice.

This first session is about sparklines, the small charts Excel draws inside a cell. It shows the different ways sparklines help you review a spreadsheet, with real examples of errors they helped us find.

What you will learn

  1. Sparklines in context

    Where sparklines came from and what they show that a table of numbers does not.

  2. Features of sparklines

    The different types and settings of sparklines and when to use each.

  3. Practical review techniques

    Techniques you can apply straight away 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.

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

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

Browse all training courses

More on this topic

Webinars

Delta sheets for analysing financial models

How delta sheets compare two versions of a model, explain what moved the outputs and support a systematic review, in any sector and without add-ins.

Financial model review pitfalls and how to avoid them

Practical techniques for reviewing a financial model, the pitfalls that let errors through and how a structured review cuts the risk of costly errors.

Services

Financial Model Audit

An independent opinion on your transaction model from the number one ranked global model audit practice. Red flag report in under 5 working days.

Financial Model Development

Transaction and operational models built to your specification, lender-ready and documented, then handed over to your team with the logic explained.

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.