Excel 101

All the essentials you need to know about navigating and building financial models using Microsoft Excel.

Use this methodology to find the exit value of any investment

Simple example of how NPV in Excel works

Construct a one-liner for modelling simple straight line depreciation

Using the INDEX() and MATCH() function to run scenario analysis