One Cell, Many Values: Should Nested Arrays Go Anywhere Near Your Financial Model?
For forty years, modellers have assumed one cell holds one value. Dynamic arrays bent that rule; lists and nested arrays break it. A single cell can now hold a depreciation profile, a scenario’s growth path or a thousand simulation outcomes.
From a modeller’s point of view, Danielle Stein Fairhurst looks at the problems these features solve, what they break (hidden data versus transparency), why copying across, Trace Precedents and spot checks no longer tell the whole story, where nested arrays earn their place, how to audit a model that uses them, and when to FLATTEN and move on. With live examples.
Other Sessions
Michael explores how advisory firms review AI-built financial models, why review capacity can become the bottleneck and the practices that help teams get more useful analysis rather than more unchecked output.
A hands-on day building reusable finance tools with Excel, VBA, Power Query, Power Automate and Copilot to automate consolidations, reconciliations and burst reporting every month.
Sloka shows how a three-statement model feeds a valuation, what models can and can't tell you about value, and where valuations most often go wrong, using anonymised examples.








.png)
.png)














.png)
.png)






.png)


.png)















