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.
Instructor
Neale Blackwood