Financial Modelling with Dynamic Arrays
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!
What you'll learn?
- Dynamic Arrays as a Modelling Tool
- The most useful array functions for modelling
- Selecting the right function (arrays vs.traditional formulas)
- Nesting functions with arrays
- Working with dates and helper rows to spill dynamically
- Financial Modelling Best Practice and Design
- Principles of financial modelling best practice with dynamic arrays
- Designing a layout to incorporate spill ranges
- Dangers and limitations of working with array functions
- Dealing with inconsistent formulas withLAMBDAs
- Financial Statements Modelling
- Dynamic debt and depreciation schedules
- Modelling corkscrew accounts
- Modelling for Indexation and growth
- Integrating the financial statements with array functions
- Advanced Modelling Tools and Techniques
- Building Flexible Model Timelines
- Switching between dynamic scenarios
- Applying sensitivity analysis
- Avoiding circularity in interest calculations
This class will be delivered by Danielle Stein Fairhurst as online-only course on 26 & 27 May 2026.
This training is available as a single Masterclass or as part of our Premium Online Global Excel Summit ticket.
What's included
Who is it 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.
- Financial modellers and analysts
- Business professionals who are eager to improve their Excel and Financial Modelling skills
- Finance & Accounting students
Download Course Brochure
About trainer
Danielle Stein Fairhurst
Danielle Stein Fairhurst is the Principal of Plum Solutions, a Sydney-based consultancy specialising in financial modelling and analysis. She is a Microsoft MVP, Master Financial Modeler (FMI), LinkedIn Learning instructor and the author of “Using Excel for Business and Financial Modelling”, Third Edition published by Wiley Finance 2019 and “Financial Modeling in Excel for Dummies” second edition published by Wiley in 2022. She founded the Financial Modellers’ Meetup groups, and in 2022 she was awarded the “Lifetime Achievement Award” at the Financial Modelling Summit.
What people think of
Danielle Stein Fairhurst
I would like to have another course (with her) in the future!
Danielle was very friendly, helpful, patient, knowledgeable and liked to share knowledge & experience. Beside she was keen that everyone grasped the concepts that she explained. Surely, I would like to have another course (with her) in the future!
A great course that is highly recommended!
Danielle is a great instructor with many years of experience. My biggest takeaway from the course is her best practice approach. A great course that is highly recommended. Thank you.
Course contents
Danielle Stein Fairhurst
Training requirements
To gain the functionality of dynamic arrays, participants must be using Excel for Microsoft 365 or Excel 2021. Each delegate must have their own laptop with their preferred version of Excel installed.
Buy ticket
Buy 365-Day Digital Masterpass
If you continue experiencing issues, you can send it to us via email to info@globalexcelsummit.com
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
.png)