ICAEW.com works better with JavaScript enabled.
Exclusive

Top 10 functions for modelling: What might catch you out

Author: Excel community

Published: 15 Oct 2018

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
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

Broadcast in 2018

Webinar resources

Some are highly sophisticated, complex issues where it is easy to understand how the errors have occurred. But some are not – and are easily avoided. In this session, Liam looks at some “household name” functions that appear too often in this latter list. Learn how to avoid these “classic gotchas” with this summary roundup of frequent faux pas.

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.

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join.

Excel polaroid
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