The information in these webinars reflects the understanding of ICAEW at the time of recording but things may have changed since that time. You should consult the latest guidance alongside a viewing of these on-demand webinars.
On-demand webinars
| Event | Date | Recording |
|---|---|---|
| Critical Skills Workshop - The accountant's toolkit in Excel Accountants often run into the same issues and although they may have their own efficient processes, understanding certain rarely used features could save lots of time. For example converting mm-dd dates to dd-mm, identifying which formulas have been overwritten, highlighting an item in one list but not another, simultaneous editing, automatically colour coding for errors/duplicates/formulas/outliers, reducing bloated file sizes, populating a single table from a single formula or query and more. |
25 Jul 2024 |
Watch again |
| Critical Skills Workshop - 50+ Excel features from this decade 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. |
27 Jun 2024 |
Watch again |
Verify your CPD
Watching these recordings can count towards your verifiable hours. After watching a webinar fill out this form to receive evidence for your CPD record.
CPD verification formYour CPD record