FEM.clp

FEM BnW.png

Finance & Excel Modeler 

Become a Certified Finance & Excel Modeller

Welcome to our Continuous Learning Path where you can become a Finance & Excel Modeler expert through our interactive online system and then attend the masterclass session later on in the year.

You get the best of both worlds !!!

Learn online now, become an expert + attend a masterclass later in the year & share your knowledge with other leading practitioners.

Lifetime access to learning portals

You become LSBF Certified

Special Covid-19 Discount

Learn Online + Conference

Bring your special project

Next Session Begins

FEM coming up in 2022

Ideal for Learning Travellers

The FEM masterclass is a learning opportunity that will take you from the foundations into the advanced level of business & financial modelling in Excel.

You will build reports, learn finance, become strong at developing comprehensive forecasting models, perform sensitivity analysis and master all these tools in Excel & in a hands-on learning manner.

  • ​Business Analysts

  • Finance Managers & Staff

  • Project Finance Teams

  • Product Strategists

  • Accountants

  • Data Analysts

  • Accountants

Course Schedule

Block 1 | Excel Model Fundamentals

Date
Session
16/08/2021
Excel Environment Foundations
17/08/2021
Use, Referencing & Shortcuts
18/08/2021
Formulas, Lookups, Aggregation
19/08/2021
Error Capture, Views & Security
23/08/2021
Deep Dive on Charts & Reporting
24/08/2021
Case Study on Dashboards
Excel Model Fundamentals.jpg

Best practice Excel Model Framework with case studies from winning companies ... Work with the best !!!

Block 2 | Macro Finance Fundamentals

Date
Session
25/08/2021
Pivots, Arrays, Tables & Seeks
26/08/2021
Data & Power Query Case Study
30/08/2021
VBA Macro Fundamentals
31/08/2021
3 Way Financial modelling
01/09/2021
Pricing Models and Valuation
02/09/2021
Case Finance Statements
Macro Finance Fundamentals.jpg

Build Reports and develop comprehensive forecasting models and master all tools in Excel.

Block 3 | Financial Deal Structuring

DateDue
SessionName
06/09/2021
Stress Testing & Sensitivity
07/09/2021
Scenario Analysis
08/09/2021
Monte Carlo Simulation
09/09/2021
Dynamic Charting
13/09/2021
Case Study Build a Term Sheet
14/09/2021
Ratio Analysis & KPI Modelling
Financial Deal Structuring.jpg

Perform Scenario Analysis and explore modelling case studies to efficiently structure your reports. 

Your Learning Path

FEM.png

Become a Certified Finance & Excel Modeler and learn how to develop various reports & models.

Study business dynamics, risk, uncertainty, product & resource success factors.

All excel models supplied with expert guidance. You will learn how to build these models from the ground up.

Bring a special excel request to the masterclass for supported Q&A.