Modelling Timelines with Dynamic Array Functions in Excel (Part 1 of 5)

preview_player
Показать описание
Welcome to a 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.

Рекомендации по теме
Комментарии
Автор

I love your books and use them often. So helpful. And now discovering this series ... it's like Christmas in July. Thank you for all you do for the community, Danielle!

kikikimbro
Автор

This is really cool. Definitely going to use this in the future!

njabulov.hadebe
Автор

I am using ms excel 2007. What to use in place of sequence function?

shivanipayal
Автор

Where are horizontal tables when you really need them 🙂

cadoova_andrew
visit shbcf.ru