Loading component...
Excel Masterclass (March) - Discovering Dynamic Arrays
Overview
This is the recording of the Excel Masterclass (March) - Discovering Dynamic Arrays held on the 18 March 2026.
This series focuses on four key areas to improve your Excel effectiveness and is designed and delivered by Neale Blackwood with over 20 years' experience in training finance professionals in Excel.
2026 March - Discovering Dynamic Arrays
Dynamic arrays is the new way to create automated reporting solutions in Excel, single formulas that can automatically populate a range. Reports can now automatically expand when new codes or accounts are added. New functions have been added and continue to be added with recent updates. These functions work seamlessly with the new and existing functions. Dynamic arrays also provide new challenges that require new and different ways of building spreadsheets.
This recorded masterclass is 3 CPD hour each.
You will be able to access the learning materials under "Resources" section.
IMPORTANT: You will have access to the recording and learning materials for a period of 12 months from the date of enrolment.
What you'll learn
- Discover the new way to create flexible formulas that populate a range with a single formula.
- Learn about the challenges with this new way of calculating as well as their solutions.
- Explore the new functions that provide simple solutions to previously difficult Excel problems.
Who is this for ?
This recorded masterclass is suitable for all finance professionals who work with Excel and anyone interested in the topics listed.
