.png)
FEM.clp
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 |
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 |
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 |
Perform Scenario Analysis and explore modelling case studies to efficiently structure your reports.
Your Learning Path
