Advanced

Financial Modelling in Excel

Structure, build and stress-test a financial model in Excel, from assumptions to a linked three-statement forecast and valuation.

3h 30m 9 lessons Beginner-friendly structure
Pro membership

Unlock this course and 50+ others

One membership at £4 a month opens every lesson, quiz and certificate on Skillora. Cancel anytime.

  • Every course in the library unlocked
  • Quizzes, projects and verifiable certificates
  • Offline downloads for low-data study
  • New courses added every month

Course content

Module 1: Model foundations

Structure and formula discipline.

  • Structure before formulas20 min
  • Formulas that survive review22 min
  • Building the assumption sheet20 min

Module 2: The three statements

Linking P&L, balance sheet and cash flow.

  • Revenue and cost build25 min
  • Working capital and debt schedules26 min
  • Making the balance sheet balance25 min

Module 3: Scenarios and presentation

Stress-test and communicate.

  • Scenarios with CHOOSE24 min
  • Sensitivity tables24 min
  • The investor summary page24 min