Dynamic arrays have introduced entirely new ways of working in Excel. This webinar will cover a practical introduction to dynamic arrays, exploring how using this capability can make spreadsheets more flexible, scalable, and efficient when it comes to financial modelling.
Our experts Ruth Butler-Lee, Head of Financial Modelling at Arriva UK Trains Ltd, John Yeldham, Financial Modeller at JogEye, and Ben Ducker, Principal Consultant at Modelling Expert Ltd will also explore the limitations of using traditional Excel formulas in modelling scenarios, such as inconsistencies across ranges, bloated file sizes, and the reliance on manual changes, and how dynamic arrays address these challenges.
First broadcast on 19 November 2025
Webinar resources
Please be aware that this webinar recording has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.
CPD
This webinar could contribute to up to 1 hour of verifiable CPD, so long as you can demonstrate that the content is relevant to your role.
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.
