Contact us | Login

Login

Comments on this entry are closed.

Professional Excel and Financial Modelling Courses

IndexMatch offer Excel modelling courses and lessons for people who want to become better Excel modellers. Courses include financial modelling and best practice guidelines.
Search
Free Lessons
- What is Excel Modelling?
- How Successful Organisations Use Financial Modelling
Basic 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 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 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 Course
- 01 – FREE! Basic Mortgage Model
- 02 – Mortgage Model Flexibility
- 03 – Mortgage Model Scalability
- 04 – Complex Mortgage Model
- 05 – Pool Valuation
- 06 – Mortgage Model Scalability
- 07 – Securitisation Model – Interest
- 08 – Securitisation Model – Principal
- 09 – Securitisation Model – Cashflow
- 10 – Additional Tranches
- 11 – Full Securitisation Model
- 12 – Review

Login

Professional Excel and Financial Modelling Courses

Search

Free Lessons

Basic Course

Advanced Course

Property Course

Securitisation Course