Financial Modelling in Excel
About this course

Overview

Most models fail not because the maths is wrong but because nobody else can follow them. Starting from an empty workbook, you build a linked three-statement model to review standard, then add scenarios, checks and the structural habits that keep it from breaking the first time someone changes an assumption.

What you will be able to do

Learning outcomes

  • Build a linked three-statement model
  • Run and compare scenarios cleanly
  • Trace and resolve model errors
  • Present model outputs to reviewers
  • Maintain a model that holds up under review
What the course sets out to do

Course objectives

  • Structure a three-statement model from scratch
  • Link income statement, balance sheet, and cash flow
  • Design scenarios and sensitivity switches
  • Apply modelling standards and formatting discipline
  • Build in checks that catch errors early
Course content

Modules

01

Model Structure and Standards

Establishes layout, conventions, and the discipline of a maintainable model.

02

Building the Three Statements

Constructs and links income statement, balance sheet, and cash flow.

03

Drivers and Assumptions

Separates inputs from calculations to keep the model flexible.

04

Scenario and Sensitivity

Adds switches and data tables to test alternative outcomes.

05

Error Checks and Controls

Builds balance checks and flags to catch mistakes early.

06

Presenting the Output

Turns model results into clear summaries and charts for decision-makers.

Who it is for

Target audience

Financial analysts, controllers, and finance business partners who build or review models.

Before you start

Prerequisites

Confident Excel use. You should know your way around formulas and referencing before you arrive.

Ready to register?

Secure a seat for Financial Modelling in Excel, or ask us anything first.