Dynamic Arrays Basic Functions
August
19
2025
(Tuesday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 60 Minutes
36 Days Left To REGISTER
Duration: 60 Minutes
36 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
See how to build a flexible loan schedule. Learn how to access rows and columns within spill ranges. Discover how formatted tables and dynamic arrays work together to create flexible and auto-updating reports. See how to change lists from rows to columns and vice-versa.
Why you should Attend
Are you still manually copying formulas as ranges extend? See how to make your formulas and reports dynamic using functions that expand automatically.
See how formatted tables and dynamic arrays seamlessly work together to make ranges dynamic.
Want to change a row-based list to a column-based list? Now it is easy.
Areas Covered in the Session
- New dynamic array functions explained and demonstrated
- SEQUENCE, CHOOSECOLS, CHOOSEROWS, TAKE and DROP
- Flexible loan schedule and flexible budget example
- Formatted tables and dynamic arrays
- Old functions that work well with spill ranges
- TRANSPOSE and INDEX
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)