top of page

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 Starts 1 March 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
01/03/2022
Excel Environment Foundations
02/03/2022
Use, Referencing & Shortcuts
03/03/2022
Formulas, Lookups, Aggregation
07/03/2022
Error Capture, Views & Security
07/03/2022
Deep Dive on Charts & Reporting
08/03/2022
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
08/03/2022
Pivots, Arrays, Tables & Seeks
09/03/2022
Data & Power Query Case Study
09/03/2022
VBA Macro Fundamentals
10/03/2022
3 Way Financial modelling
10/03/2022
Pricing Models and Valuation
14/03/2022
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
14/03/2022
Stress Testing & Sensitivity
15/03/2022
Scenario Analysis
15/03/2022
Monte Carlo Simulation
16/03/2022
Dynamic Charting
16/03/2022
Case Study Build a Term Sheet
17/03/2022
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.

bottom of page