Dynamic Arrays Introduction

Dynamic arrays are a game changer when it comes to creating spreadsheets. See how you can create a single formula that populates range. Stop copying and pasting formulas and reduce the need for $ signs in your formulas. Plus discover a whole collection of new functions that solve many common problems.

Why you should Attend

Still creating formulas and then copying and pasting them?
Still including $ signs in formulas?
Still manually filtering and sorting?
See how Excel’s new formula engine allows you to create a single formula that populates a range. These new formulas change the way you create spreadsheets in a good way. Reduce or remove the need for $ signs in your formulas. Save time in creating formulas. Automate reports and simplify formulas using these new techniques. See how to automate sorting and filtering.

Areas Covered in the Session

Version updates and requirements
New symbols
New terminology
New concepts
New functions UNIQUE, FILTER, SORT and SORTBY
Existing functions re-imagined

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.