Best practice financial modelling in Excel has always encouraged consistency of formulas with calculations performed in blocks. Excel’s dynamic array functions mean that it’s impossible to have inconsistent formulas and are perfect for building financial models, however, the techniques needed to build a model using dynamic arrays are significantly different from the traditional way of building formulas with absolute and relative cell references.
Building a fully dynamic model requires additional thought and layout planning compared to conventional methods, but the extra planning is worth the effort!
Who is this for?
This Masterclass is designed for users who use Excel on a regular basis and are comfortable with using its tools and functions. It is assumed that attendees will have some financial background.