ICAEW.com works better with JavaScript enabled.

Dynamic Arrays in Google Sheets and Excel

Author: Excel Community

Published: 07 Nov 2019

The webinar will showcase some of the latest test features in Excel for Office 365.
Broadcast on 8 November 2018 

Webinar resources

It will also introduce Excel’s take on these functions and looks at the possible future of the program – and a look at how these innovations might help accountants create better spreadsheets in the future.

'Excel Tip of the Week’ author David Lyford-Smith shows you the future of formulas – with dynamic array formulas that automatically fill multiple cells with just one formula.  This webinar will introduce the powerful approach in Google Sheets, with functions like FILTER, UNIQUE, and QUERY, showing how these can be used today to analyse accounting data and automate creation of month-end reports.

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.

Excel polaroid