“Welcome to a new 5-part video series on the “Must-have Excel Functions for Financial Modelling”.
Most financial models have some kind of time element and usually they’re looking out into the future. And being able to do this quickly is going to save you a huge amount of time, particularly if you are competing in the Financial Modelling World Cup where time is of the essence, or if you are sitting, one of the Financial Modelling qualification exams from the Financial Modelling Institute. Watch as Microsoft MVP, Danielle Stein Fairhurst demonstrates how to use Dynamic Arrays and Date functions in Excel to create a flexible and dynamic timeline that can be used for building virtually any financial model from scratch..