ICAEW.com works better with JavaScript enabled.
Exclusive content
Access to our exclusive resources is for specific groups of users and members.
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.
Allow video content provided by StreamAMG

This video content is provided by StreamAMG. We ask for your permission before anything is loaded, as they are using cookies and other technologies. You may want to read StreamAMG owner's PA Media Group privacy policy before accepting. If you are happy to view this content, please choose Allow all cookies.

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

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250