Dynamic Arrays Advanced Functions
August
26
2025
(Tuesday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 75 Minutes
43 Days Left To REGISTER
Duration: 75 Minutes
43 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
These advanced functions offer solutions to common dynamic array issues. Use a function to create reports just like a PivotTable, including percentage calculations. Create your own functions. Turn complex formulas into simple to use functions that are easy to share.
Why you should Attend
Struggling with some aspects of dynamic arrays? Learn the functions that allow you to solve most of these issues.
Need to report on multiple columns from a table? Discover the functions that can automate reports including percentage calculations.
Need a function that Excel doesn't have? See how to create your own functions.
Areas Covered in the Session
- The SCAN, REDUCE and MAP functions
- GROUPBY. PIVOTBY and PERCENTOF functions
- An OR condition technique for SUMIFS
- Using the # symbol on the end of functions
- Custom functions with and without LAMBDA
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)