Financial Modelling with Dynamic Arrays
This Masterclass is sold out.
Best practice financial modelling in Excel has always encouraged the consistency of formulas with calculations performed in blocks. Excel’s dynamic array functions mean it’s impossible to have inconsistent formulas and are perfect for building financial models. They represent a significant departure from the conventional approach of building formulas with absolute and relative cell references and need a little more thought and planning when building a fully dynamic financial model.
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
- Financial Modelling Best Practice and Design
- Principles of financial modelling best practice with dynamic arrays
- Designing a layout to incorporate spill ranges
- Dangers of working with array functions
- Financial Statements Modelling
- Building a simple financial model with array functions
- Dynamic debt and depreciation schedules
- Dealing with inconsistent formulas with LAMBDAs
- Advanced Modelling Tools and Techniques
- Switching between dynamic scenarios
- Applying sensitivities with data tables
- Avoiding circularity in interest calculations
This Masterclass will take place on 5 & 6 May 2025 as an online-only course.
Who is it for?
This Masterclass is designed for users who use Excel on a regular basis and are comfortable using its tools and functions. It is assumed that attendees will have some financial background. Typical job titles who could particularly benefit include:
- Financial modellers and analysts looking to eliminate the need for model maintenance and significantly reduce spreadsheet risk
- Business professionals who are eager to improve their Excel and financial modelling skills
- Finance & Accounting students
- Excel users interested in the future of spreadsheet modelling
Download Course Brochure
What's included?
-min.avif)
-min.png)
✔︎ What is “extract, transform, load,”?
✔︎ How data profiling works in Power Query and why it matters
✔︎ First steps for profiling and cleaning the data
✔︎ Avoid memory-draining “Frankentables” and build relational data models and reports right from Excel
✔︎ Power Pivot and DAX for data analysis in Excel
✔︎ What are dynamic array functions?
✔︎ Learn how to build quick, responsive formulas for easy analysis.
✔︎ Boost Excel with generative Ai and Copilot
✔︎ Use natural language propmpts to simplify Python scripting, uncover insights and streamline workflows for even faster and easier analytics
✔︎ What is Python and why has it become the glue that binds today’s data analytics stack.
✔︎ Learn basic Python scripting to build compelling analyses and visualizations that would otherwise be difficult or impossible to do in Excel
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant topics.
Master Excel Power Query essentials
Create your first Power BI report the right way
Building a business case finance model
Transforming your boring Power BI reports to AWESOME
data stories
Data analytics in modern Excel
Impactful data visualisation in Excel for powerful\
communication
Training requirements
To make the most out of this Masterclass, attendees will need to have some familiarity with Excel formulas such SUMIFS, VLOOKUP etc.
Users will required a windows PC running Excel 2021, or Excel 365.
About the trainer
%20(1).jpg)
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
★★★★★
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.
★★★★★
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!
Exclusive Masterclass sessions from leading figures stretch beyond the regular ones and dive deeper into Excel’s advanced functionality, covering a range of industry-relevant data visualisation, analytics and Power Query topics.
✔︎ Masterclass with George Mount: Excel Analytics 2.0
✔︎ Masterclass with Ann K. Emery: Designing and Building Interactive Dashboards in Excel
✔︎ Masterclass with Chandeep Chhabra: Advanced Data Cleaning Using M in Power Query
Delve into Excel's advanced features with special in-depth sessions from Microsoft MVPs & experts. Designed to equip you with some of the most sought-after workplace skills.
September 2025
✔︎ 15 & 16 Sep | 18:00-21: 00 BST - Modern Data Analytics in Excel (with George Mount)
✔︎ 16 & 17 Sep | 9:00-12:00 BST - Budget and Forecast Modelling in Excel (with Danielle Stein Fairhurst)
✔︎ 18 & 19 Sep | 9:00-12:00 BST - Automate Your Month End in Excel (with Mark Proctor)
October 2025
✔︎ 9 & 10 Oct | 18:00-21:00 BST - Advanced Charting in Excel (with Ann K. Emery)
✔︎ 14 & 15 Oct | 18:00-21:00 BST - New Ways of Solving Problems in Excel (with Chandoo)
✔︎ 16 & 17 Oct | 09:00-12:00 BST - Power Query in a Day (with Wyn Hopkins)
And don’t worry if you miss one – everything is recorded, so you can catch up any time.
Instantly unlock 35+ hours of premium content from 7 expert-led courses, featured in our 2025 Special Edition May/June Masterclass series.
May 2025
✔︎ Financal Modelling with Dynamic Arrays (with Danielle Stein Fairhurst)
✔︎ Automate Your Month End in Excel (with Mark Proctor)
✔︎ Python in Excel for Enhanced Data Analytics (with George Mount)
✔︎ Building Interactive Data Visualisations (with Carlos Barboza)
✔︎ Automate Excel with Office Scripts and Power Automate (with Mark Proctor)
June 2025
✔︎ Advanced Formulas in Excel Beyond the Basics (with Alan Murray)
✔︎ Building Power BI Reports the Right Way (with Gašper Kamenšek)
The Global Excel Summit has been verified as a CPD-accredited event three years in a row. and so are our in-person and online Masterclasses. This serves as credible proof of its reputation as a premium event.
✔ Gain up to 6 CPD points per Masterclass
✔ Boost your standing in a fiercely competitive job market
✔ Receive a CPD certificate
Get Product
-min.avif){kind=logo}
Join the Master Club
Your exclusive all-access pass to our entire digital learning experience for a whole year.
