Cademy logoCademy Marketplace

Course Images

Best Practice Financial Modelling: classroom based

Best Practice Financial Modelling: classroom based

By F1F9 Academy

4.8(48)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered In-Person

  • Two days

  • All levels

Description

We will work closely with you, sharing insights and putting into practice core financial modelling techniques as you model a case study based on a business acquisition.

You will learn to create the step-by-step calculations required to forecast the three primary financial statements — income, balance sheet, and cash flow. More advanced topics will include a valuation of the equity in the case study company (based upon the present value of forecast dividends).

Participants can expect detailed instruction and hands-on practice with a focus on developing and working with a financial model that they have built from scratch.

Post-course, you will receive full and ongoing access to the online version of the course as well as online support from our team of modelling experts.

course Content

4 sections•46 lessons
Getting started4 lessons
  1. 10. Before you begin
  2. 21. Course agenda
  3. 32. Course files
  4. 43. F1F9 productivity macros
Pre course work: Excel Proficiency Skills16 lessons
  1. 10. Before you begin
  2. 21. Using the Alt key
  3. 32. Keyboard shortcuts and the mouse
  4. 43. Edit directly in cell
  5. 54. Move selection after Enter
  6. 65. Macro security and developer tab
  7. 76. Analysis toolpak
  8. 87. Reducing worksheet clutter
  9. 98. Windows explorer settings
  10. 109. Basic worksheet navigation
  11. 1110. Selecting, adding and deleting content
  12. 1211. Inserting rows and columns
  13. 1312. Adding and deleting worksheets
  14. 1413. Using the function keys
  15. 1514. Group mode
  16. 1615. Standard Excel shortcuts
Pre course work: Model Construction Skills20 lessons
  1. 10. Before you begin
  2. 21. F1F9 productivity macros
  3. 32. Spaces in formulas
  4. 43. Calculation blocks
  5. 54. Copying calculation blocks
  6. 65. Row anchoring
  7. 76. Navigating using links
  8. 87. Daisy chains
  9. 98. Copying links
  10. 109. Placeholders
  11. 1110. Placeholder macro
  12. 1211. Timing flags
  13. 1312. Cross worksheet links
  14. 1413. Paste links forward
  15. 1514. Advanced productivity
  16. 1615. Introduction to modelling balances
  17. 1716. Counterflows
  18. 1817. Temp sheet
  19. 1918. Quick charts
  20. 2019. Ten things to remember
Post course work6 lessons
  1. 10. Feedback module
  2. 21. Airco solution model
  3. 32. F1F9 template model
  4. 43. Biomass
  5. 54. Fitness Centre
  6. 65. Hotel Raja

Dates

Filter the available options by location
All Locations
London, ISH Venues, 1 Park Crescent, London W1B 1SH, UK
Dubai
London, 47-58 Bastwick St
  • 25 & 26 June 2026
      to   (2 sessions)
    5 spaces left
    Delivered In-Person in London
    £1,900+ VAT
  • 24 & 25 August 2026
      to   (2 sessions)
    Delivered In-Person in Dubai
    £1,900+ VAT
  • 15 & 16 October 2026
      to   (2 sessions)
    Delivered In-Person in London
    £1,900+ VAT

Location

ISH Venues, 1 Park Crescent, London W1B 1SH, UK, W1W 5PN, United Kingdom, London

About The Provider

F1F9 Academy

Expert & Certified Financial Modelling courses for best-in-class modelling

Read more about F1F9 Academy

Reviews

+ Add Review