Skip to content

Self‑review techniques for financial models

Four Excel techniques to review your own financial model before anyone else does: inconsistent formulas, Inquire, sparklines and delta sheets.

Webinar · Recording · Presented by Ben Kwan and Nidhi Kapania · 28 October 2020

Ben Kwan and Nidhi Kapania show practical techniques to review your own financial model and reduce errors. Each is a hands‑on Excel method you can apply straight to your own workbooks.

What you will learn

  1. Inconsistent formulas

    Find formulas that break the pattern across a row or column, a common source of hidden errors.

  2. Inquire

    Use Excel’s Inquire add‑in to compare workbooks and find differences or errors.

  3. Sparklines

    Spot unusual trends in the model’s outputs at a glance.

  4. Delta sheets

    Build delta sheets to support the review of sensitivities and scenarios.

Who it is for

Financial modellers, analysts and anyone who builds or reviews financial models and wants a practical, repeatable self‑review process.

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

Browse all training courses

More on this topic

Webinars

Use sparklines in your financial models

How Excel sparklines add insight to a financial model and cut errors.

Delta sheets for analysing financial models

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

Services

Financial Model Audit

Independent model audits for bids, financial close, acquisitions, refinancing and operating models. Ranked the number one global model audit practice for 12 consecutive years (Infralogic).

Learn to build these models yourself

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