0845 450 6120

Excel Modelling - Two-day Workshop

This two-day Excel Modelling Workshop is designed to build a robust and informative model.  The workshop uses a logical consistent approach and builds the cash flow model through a series of practical stages.  Delegates will receive a comprehensive understanding of advanced modelling, as well as how they can apply each technique to their own models.


Learning Objectives

On completion of this highly practical, hands-on training course, attendees will:

  • be able to build an advanced financial model from a blank sheet
  • be able to design transparent models which minimise errors
  • be able to write robust models which can be understood by others and maintained in the future
  • be able to develop models with advanced techniques such as risk, sensitivity and forecasting

This programme will be delivered through a practical and interactive case study and worked examples, demonstrating how and why each technique is used.  Emphasis is placed on the delegates gaining practical, hands-on experience of the design and construction of financial models in Excel.  Delegates will also benefit from formal lectures and group discussions. 

The course starts with a discussion of ideal modelling techniques, standards and methods and agrees the objectives for a cash flow model.  Each session reviews the next stage of the model in terms of the financial theory, modelling techniques and potential difficulties and delegates then have the time to build each section in stages under supervision.  This is an intensive course and delegates will be spending most of the time on practical model building tasks. With the help of the Course Director and through a proven step-by-step approach, delegates will leave this intensive two-day course with the confidence and ability to apply advanced modelling techniques in Excel effectively.



This is relevant for all industry sectors with an interest in financial analysis and job titles include:

  • Finance Directors/Financial Controllers/CFOs
  • Business/Financial/Treasury/Market Analysts
  • Corporate /Structured/Project Finance Officers
  • Financial/Strategic Planners
  • M&A Specialists
  • Private Equity
  • Project/Commercial Management
  • Business Development and Marketing
  • Systems Analysts
  • Budget Managers
  • Credit Risk/Treasury Managers
  • Actuaries

Delegates will be expected to have finance knowledge and a working knowledge of Excel, including:

  • Opening and closing Excel files 
  • Excel screen menu and standard toolbar 
  • Auto fill 
  • Moving around a worksheet 
  • Moving around the sheets in a workbook 
  • Creating files 
  • Deleting files and individual sheets 
  • Changing column width and row height 
  • Entering simple formulas 
  • Entering labels 
  • Cell referencing 
  • Centring titles and merging cells 
  • Simple cell formatting 
  • Number formats 
  • Changing font sizes and colours 
  • Copy, cut and pasting cell contents 
  • Inserting graphic objects 
  • Custom views 
  • Previewing worksheets 
  • Printing documents and ranges
  • Basic financial functions – NPV, IRR, NPER, PV, PMT, RATE, FV

Course Content

Day One – Introduction and Model Build

Module 1 – Modelling and Model Planning

  • Overview of the course – building a model from a blank sheet
  • Case study outline – desired outcomes
  • Avoiding Excel modelling errors
  • Exercise: model review

Module 2 – Income Statement and Balance Sheet

  • Adding income and balance sheet
  • Key model building techniques
  • Exercise: completing the initial statements

Module 3 – Forecasting Methods

  • Review of forecasting methods
  • Identifying and forecasting key drivers
  • Linkages and modelling problems
  • Exercise: adding a forecast to the case template

Module 4 – Cash Flows and Ratios

  • International cash flow statement
  • Required financial ratios – profitability, liquidity, structure, market
  • Model self-checks
  • Exercise: adding cash flow and ratios to template

Questions and answers

Day Two – Cash Flow and Value

Module 5 – Free Cash Flows

  • Derivation of free cash flow
  • Checking model results and redefining forecast
  • Reasonableness of forecast and results
  • Exercise: adding free cash flow to the model

Module 6 – Initial Equity Valuation

  • Cost of capital and discount rates
  • Methods of adding terminal value
  • Producing an equity valuation
  • Exercise: adding equity valuation

Module 7 – Risk and Sensitivity

  • Understanding of risk and multiple answers
  • Sensitivity and matrices
  • Exercise: testing the model with different sensitivity outcomes

Module 8 – Management Reporting and Review

  • Audit techniques
  • Help and user assistance
  • Documentation and maintenance
  • Exercise: model completion

Questions and answers

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Online Courses

You may prefer an online course if you are looking for a flexible and cost-effective solution. Online courses allow you to study at your own pace, at a time that suits you.

We have the following eLearning options available:

Our Customers Include