Excel Modelling Lessons
Access any of our Excel Modelling lessons quickly and easily. The free lessons are open to everyone. The Basic, Intermediate and Advanced lessons are only available if you are a registered member.
Free Modelling Lessons
Basic Modelling Course
- 01 – What is Modelling?
- 02 – Modelling Template
- 03 – Excel Shortcuts and REFERENCE GUIDE
- 04 – Best Practice Modelling
- 05 – Basic Modelling 1 – Discounting
- 06 – Basic Modelling 2 – Flexibility 1
- 07 – Basic Modelling 3 – Flexibility 2
- 08 – Basic Modelling 4 – Debt
- 09 – Basic Modelling 5 – NPV & IRR
- 10 – Basic Modelling 6 – Timing Flags
- 11 – Break Even & Sensitivities
- 12 – Scenarios
- 13 – Model Layout Basics
Intermediate Modelling Course
- 01 – Intermediate Modelling 1 – Flexibility 3
- 02 – Intermediate Modelling 2 – Flexibility 4
- 03 – Intermediate Modelling 3 – Flexibility 5
- 04 – Model Layout – Multisheet
- 05 – Technical Tips 1 – Timeline
- 06 – Technical Tips 2 – RANK
- 07 – Technical Tips 3 – SUMIF
- 08 – Technical Tips 4 – Conditional Formatting
- 09 – Technical Tips 5 – INDIRECT
- 10 – Model Layout – Generic
- 11 – Model Process
- 12 – Interviews – Modelling Tests
- 13 – Interviews – Case Studies
Advanced Modelling Course ***COMING SOON***
- 01 – Approaching Models 1 – Supply
- 02 – Approaching Models 2 – Demand
- 03 – Technical Tips 1 – Balance Sheet
- 04 – Technical Tips 2 – Dividends
- 05 – Technical Tips 3 – CGT
- 06 – Technical Tips 4 – Decision Trees
- 07 – Technical Tips 5 – Circular References
- 08 – VBA Looping
- 09 – Graphs – Area Graphs
- 10 – Graphs – Flexible Graphs
Comments on this entry are closed.