ICAEW.com works better with JavaScript enabled.
Exclusive content
Access to our exclusive resources is for specific groups of users and members.
Excel MVP David goes through a whistlestop tour of the most important functions, commands and tools to have hit Excel in the 2020’s so far. So many Excel enthusiasts are highly familiar with classic Excel features, but many of these (nested IF, VLOOKUP, commenting, SUMPRODUCT) have been superseded with better tools. AI is also now nested to Excel in several ways, and Excel has made strides for simultaneous editing and collaboration, for example the ability to check, cell by cell, who edited what and when.

This webinar has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

Webinar resources

This webinar has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

Open AddCPD icon