ICAEW.com works better with JavaScript enabled.

Webinar recordings

Archive of webinar recordings. Includes financial modelling, PivotTables, Power Query, Excel Tip of the Week Live and many more.
Displaying 1-47 of 47 results
Exclusive Hooray for Arrays! The formula revolution that lets Excel take the strain
  • Webinar
  • 06 Jul 2022
If you don't know what array formulas are, or don't know how to use them, then this webinar will provide the answers.
Exclusive Power Query - the Excel TARDIS (Totally Avoid Running out of Dimensions In Spreadsheets)
  • Webinar
  • 17 Jun 2022
The introduction will cover a guide to using the Power Query editor and a range of key techniques and features, all of which can be used to solve practical problems and automate time-consuming processes.
Exclusive Power Pivot for management reports
  • Webinar
  • 22 Mar 2022
“Excel Tip of the Week” author David Lyford-Tilley takes us on a deep dive into how the powerful and flexible Power Pivot add-in can be used to connect datasets together to make simpler management reporting dashboards.
Exclusive A comprehensive guide to PivotTables (2022 webinar)
  • Webinar
  • 21 Feb 2022
Join David Lyford-Tilley as he walks you through everything you need to know about summarising and condensing your data using Excel’s famous PivotTables.
Excel Tip of the Week Live: your questions answered (Winter '22)
  • Webinar
  • 25 Jan 2022
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Tilley tackles your Excel questions, quandaries, and more. 
Exclusive Getting started with VBA
  • Webinar
  • 22 Nov 2021
John Tennent draws back the curtain and shows you how to get started with this powerful Excel tool.
How to review a spreadsheet: launch event
  • Webinar
  • 02 Nov 2021
Join “Excel Tip of the Week” author David Lyford-Tilley and spreadsheet expert John Tennent for the launch of the Excel Community’s latest thought leadership report, “How to Review a Spreadsheet”.
Scenarios in Financial Modelling
  • Webinar
  • 14 Oct 2021
An introduction to building scenarios.
Excel Tip of the Week Live: your questions answered (no 5)
  • Webinar
  • 21 Sep 2021
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more. 
Exclusive The top 10 Excel formulas
  • Webinar
  • 06 Jul 2021
Excel "Tip of the Week” author David Lyford-Smith goes through the most used and most popular formulas in Excel – collated from Microsoft’s own list of the most popular plus a couple of choices of our own.
Exclusive 10 everyday problems that Power Query solves best
  • Webinar
  • 22 Jun 2021
The life-changing benefits of using Power Query when working with any form of external data might be obvious.
Excel Tip of the Week Live: your questions answered (no 4)
  • Webinar
  • 27 May 2021
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more. 
Exclusive Excel Tip of the Week Live #8
  • Webinar
  • 09 Mar 2021
Discover useful Excel hints and tips so you can use Excel more efficiently and effectively with our Excel expert David Lyford-Smith.
Exclusive Exploring Charts in Excel
  • Webinar
  • 10 Feb 2021
How to use the many Chart options in Excel and apply the vast array of available graphical choices and features.
Excel Tip of the Week Live: your questions answered (no 3)
  • Webinar
  • 26 Jan 2021
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more. 
Exclusive Super charge your PivotTables with Power Pivot
  • Webinar
  • 02 Nov 2020
Power Pivot is freely available in Excel, but is often overlooked. But the powerful add-in can supercharge your PivotTables, allowing more nuanced and detailed calculations and summaries than ever before.
Excel Tip of the Week Live #7
  • Webinar
  • 28 Aug 2020
Discover useful Excel hints and tips so you can use Excel more efficiently and effectively with our Excel expert David Lyford-Smith.
Exclusive The comprehensive guide to PivotTables
  • Webinar
  • 23 Jun 2020
One of the most enduringly popular data analysis features in Excel, PivotTables are an essential ingredient in any accountant’s data analysis toolbelt.
Excel Tip of the Week Live: your questions answered (part 2)
  • Webinar
  • 19 May 2020
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more. 
Exclusive Power BI presentation features
  • Webinar
  • 14 May 2020
Power BI Desktop is a free application that can turn financial data into animated and interactive visualisations.
Five steps to cyber hygiene for the smaller firm
  • Webinar
  • 11 May 2020
This webinar will highlight the five steps smaller firms can take to help prevent 80% of cyber-attacks and improve the cyber security of their firms and clients.
Exclusive Introduction to Power Query
  • Webinar
  • 14 Apr 2020
David Lyford-Smith returns to Excel’s powerful automation and data cleaning tool, Power Query.
Excel Tip of the Week Live: your questions answered
  • Webinar
  • 20 Feb 2020
In the latest instalment of the “Tip of the Week Live” series, series author David Lyford-Smith tackles your Excel questions, quandaries, and more.
Dynamic Arrays in Google Sheets and Excel
  • Webinar
  • 07 Nov 2019
The webinar will showcase some of the latest test features in Excel for Office 365.
Tech Essentials - Robotic Process Automation
  • Webinar
  • 10 Sep 2019
Robotic Process Automation has the potential to significantly change the working lives of many people.
Exclusive Extracting accounting systems data in Excel
  • Webinar
  • 22 Jul 2019
Providing a step-by-step guide demonstrating how to methodically transform any automatically generated report extract into usable data.
Exclusive Experimental Excel - look, no formulae
  • Webinar
  • 04 Jul 2019
The introduction of the Power Query tools to Excel in Excel 2010 made it possible to fully automate a range of spreadsheet processes.
The game changing modern Excel features
  • Webinar
  • 03 May 2019
Join David Benaim to discover some of the newer features of Excel and how they can help you to utilise the program.
Exclusive Webinar Excel Tip of the Week Live 6
  • Webinar
  • 18 Apr 2019
In the sixth of his ongoing annual series, “Excel Tip of the Week” author David Lyford-Smith returns with another selection of hand-picked tips and tricks to speed up and improve your Excel practice.
Understanding the Excel Community
  • Webinar
  • 26 Feb 2019
This webinar will guide you through the benefits of Excel Community membership – whether individually or part of an organisation.
Webinar: Financial Modelling Code
  • Webinar
  • 21 Feb 2019
Late last year ICAEW launched the Financial modelling code, a high-level guide to the goals and methods of good financial models.
Exclusive Top 10 functions for modelling: What might catch you out
  • Webinar
  • 15 Oct 2018
Liam Bastick has been a model auditor for the best part of 30 years and has seen common mistakes made in modelling time and time again. 
Exclusive Webinar: Power Query - how to get started
  • Webinar
  • 14 Sep 2018
Power Query is a plug-in for Microsoft Excel which enables you to combine data from structured and semi-structured sources.
Exclusive Webinar: 20 principles for good spreadsheet practice – why are they important?
  • Webinar
  • 16 Jul 2018
Spreadsheet risk is an important concern that affects organisations of all kinds and sizes.
Exclusive Power BI Desktop - turn data into action
  • Webinar
  • 18 Apr 2018
Almost exactly two years ago, Rishi Sapra presented an excellent introduction to Power BI and its capabilities. Since then, Microsoft has continued to update Power BI with significant updates arriving monthly. This webinar will focus on the free version of Power BI, Power BI Desktop, and cover the different components of Power BI Desktop using a practical example to take you from raw data to interactive report.
Exclusive PivotTables
  • Webinar
  • 11 Apr 2018
A starter kit for the most powerful data analysis and presentation tool in Excel, the PivotTable.
Exclusive INDEX MATCH
  • Webinar
  • 11 Apr 2018
The combination function INDEX MATCH is the most powerful, reliable, and flexible solution for any lookup-and-reference problem.
Exclusive VLOOKUP
  • Webinar
  • 11 Apr 2018
A quick introduction to the ubiquitous lookup-and-reference function, VLOOKUP – useful for everything from filling employee details from a master database to looking up prior year balances.
Webinar: Excel Tip of the Week Live #5
  • Webinar
  • 09 Apr 2018
Join David Lyford-Smith for the latest in his series of short Excel tips and tricks.
Exclusive Webinar: Financial modelling - the hows and whys
  • Webinar
  • 10 Oct 2017
Laying out a Financial Model: Liam Bastick will highlight the do’s and don’ts of setting up a financial model.
Webinar: Understanding the Excel Community and its Excel online training
  • Webinar
  • 30 Nov 2016
This webinar will guide you through the benefits of Excel Community membership.
Exclusive Transforming modelling and visualising data using Power BI
  • Webinar
  • 26 Feb 2016
Discover how you can take advantage of your familiarity with Excel whilst overcoming its limitations of working with data, by extending with Power BI.
Exclusive Principles for good spreadsheet practice #2 – defining a template
  • Webinar
  • 09 Dec 2015
Since the launch in June 2014 the 20 principles project has achieved a great deal. Several companies have submitted their products for recognition as compliant with the principles. This webinar briefly covers the most important developments before looking at how to install the principles template and use it in practice.
Financial modelling automating month end
  • Webinar
  • 02 Mar 2015
Closing month end can be an arduous and time consuming process, involving a long check list of processes including downloads, cuts, pastes, a load of re-keying and a few ‘quick fixes’ too for those who make use of Excel to facilitate the process.
Exclusive Excel tip of the week live #2
  • Webinar
  • 05 Feb 2015
Excel Tip of the Week author David Lyford-Smith shows more of his short Excel tips that can help anyone improve their Excel use.
Exclusive Excel tip of the week live #1
  • Webinar
  • 11 Jul 2014
Excel tip of the week author David Lyford-Smith shows 10 short Excel tips that can help anyone improve their Excel use. Broadcast 8 July 2014
Exclusive Top 10 spreadsheet risks
  • Webinar
  • 29 Nov 2013
It is estimated that over 90% of spreadsheets contain errors. This webinar outlines the top 10 spreadsheet risks – what they are and how to avoid them.
Displaying 1-47 of 47 results