Excel Dashboards - Dynamic Arrays
September
17
2025
(Wednesday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 90 Minutes
65 Days Left To REGISTER
Duration: 90 Minutes
65 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Dynamic arrays are a game change in Excel.
Overview
Dynamic arrays are a game change in Excel. They simplify formula creation and speed up development. A single formula can populate a range that then drives a chart.
Learn the new techniques that allow you to create dynamic charts.
Why you should Attend
Need charts that update automatically as new data is added?
Need to sort and filter your data?
Dynamic arrays offer formula solutions for these requirements.
Areas Covered in the Session
- 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
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Access Recorded Version
One Attendee / Group Attendees
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)