ICAEW.com works better with JavaScript enabled.

Spreadsheet errors: how to reduce risk

Author: David Lyford-Smith

Published: 09 Nov 2020

David Lyford-Smith speaks to Wired UK about spreadsheet errors and battling back. With spreadsheet errors featuring in news such as the PHE coronavirus case incident, it's important to know how to reduce spreadsheet risk and improve.

Throughout my career I have worked with spreadsheets, whether as tools for helping me analyse data in audit, for helping control and organise outsourcing services, or while I was Senior Excel Practitioner at BDO – a role in which I helped the organisation to improve its spreadsheet practice, solve problems, and more.

Since joining ICAEW five years ago and taking over the running of the Excel Community (and before that as a volunteer committee member), I have been involved in helping steer ICAEW’s guidance to accountants on how to use Excel and its equivalents safely and effectively – including our landmark Twenty Principles for Good Spreadsheet Practice.

Feature in Wired UK

Recently I spoke to Wired UK about my history with spreadsheet errors and battling back, along with several others from the European Spreadsheet Risk Interest Group, an academic conference on spreadsheet risk. The article talks about my history with spreadsheets, why they keep appearing with a starring role in various public mistakes such as the recent PHE coronavirus case incident, and what we can do to change.

Decreasing your own spreadsheet risk

If you are interested in learning how to use Excel better and decreasing your own spreadsheet risk, then my blogs and webinars join a host of other online resources as part of the Excel Community – check out what we have to offer and join today.

Excel community

This article is brought to you by the Excel Community where you can find additional extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Excel with Business.

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