Excel Spreadsheet Modelling Lessons

Access any of our Excel Spreadsheet 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 Spreadsheet Modelling Lessons

Basic Modelling Course

01 – FREE! What is Modelling?
02 – FREE! Modelling Template
03 – FREE! Excel Shortcuts and REFERENCE GUIDE
04 – FREE! Best Practice Modelling
05 – FREE! 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

Advanced Modelling Course

01 – FREE! Advanced Modelling 1 – Flexibility 3
02 – Advanced Modelling 2 – Flexibility 4
03 – Advanced 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

Property Modelling Course

00 – Introduction
01 – FREE! Weighted Average Lease Term
02 – Real Estate Valuations – Implicit
03 – Real Estate Valuations – Explicit
04 – Real Estate Valuations – Scalability using VBA
05 – Real Estate Finance – Cash flow waterfall
06 – Real Estate Finance – Debt Repayment Flexibility
07 – Real Estate Finance – Cash sweep
08 – Real Estate Fund – Introduction
09 – Real Estate Fund – Across Sheet Scalability
10 – Real Estate Modelling Test Preparation

Securitisation Modelling Course

Comments on this entry are closed.