Dynamic Arrays in Microsoft 365 Excel have fundamentally changed the way we use Excel for financial modelling. A single cell formula may return several values and they all spill across and/or down the grid. Financial modellers can benefit by using dynamic arrays to offer more business insights with fewer formulae than ever before.
Hear from modelling specialist David Taylor for this interactive meetup. We discuss features such as sum(above), corkscrew balances and works up a model demonstrating business insights scenarios now possible. Do’s and don’ts presented in this session demonstrate pitfalls and possibilities for powerful additional insights.
Download the Resources