Dynamic Arrays Reporting Bundle

This is the fifth in the dashboard series and focuses on creating a dashboard using dynamic arrays. Subscription version required. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail and a total in a single formula. Version: Microsoft 365 Recorded: March 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

Dynamic arrays have changed the way Excel reports are created. See how to apply dynamic arrays to a 12 month report with budgets and forecasts. The session covers. - automatically inserting new accounts - filtering the report - changing the order of accounts Other reporting tips will also be shared. Version: M365 - Subscription Recording: Oct 2025 Level: Advanced Duration: 80 min Price: AU$25

Dynamic arrays change the way Excel reports are created. See how to apply dynamic arrays to a Month and YTD report. Includes a new range syntax technique as well. The session covers. - automatically inserting new accounts - filtering the report - changing the order of accounts - hiding zero and blank rows using a Slicer Version: Microsoft 365 Recorded: Jun 2025 Level: Intermediate Duration: 1 hour Price: AU$25