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 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.