This is the fifth in the dashboard series and focuses on creating a dashboard using dynamic arrays.

This session requires the subscription version of Excel.

This session covers.

• Creating and using spill ranges

• New functions SEQUENCE, UNIQUE, SORT, TEXTBEFORE, CHOOSEROWS, TAKE, DROP and VSTACK

• Using a single SUMIFS for detail and total calculations

• Handling current and prior year data

• Using range names to create dynamic charts that expand automatically

• Using chart templates

As always, I will share other tips and tricks along the way.