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 |
|---|---|---|
| Automate & reshape data with Power Query and macros Excel’s game changing tool can run processes which Excel has never been able to. The same Power Query program now exists inside of Excel for Windows, Mac and Power BI, so learning it can accelerate your performance on the other platforms. Macros is another automation tool to be used in certain instances, we will cover the process and some common use cases. |
7 Nov 2024 |
Watch again |
| Critical Skills Workshop -Strategic storytelling This workshop will help participants understand the science behind storytelling, develop a toolbox of different story telling techniques, highlight ways to better structure their messaging for clarity and impact and buy in, and learn to apply them to their day to day communication needs. |
24 Oct 2024 |
Watch again |
| Critical Skills Workshop - Leadership and Executive Presence Expand your professional network, raise your profile, and increase your visibility in your industry- learn how with Eric Sampson. |
19 Sept 2024 | Watch again |
| Critical Skills workshop - Power BI Power up with Power BI! Learn how to use all the tools and features Power BI has to offer and transform the way you tackle your daily workload. |
5 Sept 2024 |
Watch again |
| 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