FEM.CLP | CLP.LIFE
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