CPDStore

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.