| Date: | 27/03/2024 |
|---|---|
| Time: | 1:00 PM AEDST |
| Event: | Dashboards #5 - Dynamic Arrays |
| Topic: | Dashboards #5 - Dynamic Arrays |
| Public: | Public |
| Registration: | Click here to register. |
Webinar – Dashboards #5 – Dynamic Arrays
Price: AU$25
This is the fifth in the 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, DROP, TAKE and VSTACK
- Using a single SUMIFS for detail and total calculations
- Handling current and prior year data
- Creating spill ranges that make drive dynamic charts
- Using range names to shorten formulas
- Using chart templates
As always, I will share other tips and tricks along the way.