top of page

FEM.clp

FEM

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

Bring your special project

Learn Online + Conference

Next Session Begins

dates to be announced soon

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

Session
Excel Environment Foundations
Use, Referencing & Shortcuts
Formulas, Lookups, Aggregation
Error Capture, Views & Security
Deep Dive on Charts & Reporting
Case Study on Dashboards
Excel Model Fundamentals

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

Block 2 | Macro Finance Fundamentals

Session
Pivots, Arrays, Tables & Seeks
Data & Power Query Case Study
VBA Macro Fundamentals
3 Way Financial modelling
Pricing Models and Valuation
Case Finance Statements
Macro Finance Fundamentals

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

Block 3 | Financial Deal Structuring

SessionName
Stress Testing & Sensitivity
Scenario Analysis
Monte Carlo Simulation
Dynamic Charting
Case Study Build a Term Sheet
Ratio Analysis & KPI Modelling
Financial Deal Structuring

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

Your Learning Path

FEM Road Map

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