CPDStore Ireland

Dynamic array formulas represent one of the most significant changes to Excel in recent years. They allow a single formula to return multiple results, automatically expanding into neighbouring cells and dramatically simplifying many common calculations, reports, and models.

In this course , you will learn how and when to use dynamic array formulas. The session focuses on practical, real-world use cases that show how dynamic arrays can move you beyond traditional, cell-by-cell formulas in Excel.

In this session Alan Murray covers the following topics:

• Understanding what dynamic array formulas are and how they differ from traditional Excel formulas.
• Writing your first dynamic array formulas and understanding how results “spill” across cells.
• Working with spill ranges, including referencing them correctly and handling common errors when things go wrong.
• Using key dynamic array functions effectively, with guidance on best practice and when dynamic arrays are not the right solution.
• Building tables, reports, and simple models using a single dynamic array formula, and integrating them with charts and data validation.