Best practice financial modelling in Excel has always been to enter your formulas in blocks. Enter a formula, then copy this across and possibly down also, making sure you have your absolute and relative references set correctly.

This is very useful because it is faster to build a model, easier to enter lots of formulas, less error-prone and easier to audit, all very desirable things when you’re constructing a financial model! Excel’s dynamic array functions take this concept to a whole new level because they automatically copy themselves. The dynamic array functionality has improved recently & now, with a bit of thought & planning, it can be applied to building a full financial model.

Watch to hear from financial modelling specialist, Jeff Robson to see how these new functions are dramatically revolutionising financial modelling in Excel with a practical example of a full 3-way model where all formulas automatically copy themselves just by changing the number of periods.


Download the Excel model file 
Follow Jeff Robson on LinkedIn  
Check out Access Analytic 

Register for a Virtual Meetup