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.
View resources
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.
