• E-mail us
  • View our Pinterest page
  • Join us on LinkedIn
  • Follow us on Twitter

Northern Society of Chartered Accountants

At the heart of northern business since 1882

Practical techniques to reduce spreadsheet risk

Date: 28 April 2015 13:30 to 16:30

Type: Career and Personal Development, Course

Organiser: Tyne and Wear

In June 2014 the ICAEW launched its 20 Principles for Good Spreadsheet Practice amid growing concern over the risks associated with the use of spreadsheets in all aspects of business. This course will concentrate on some practical tips and techniques to help reduce those risks and promote compliance with the 20 Principles. Some significant new features in Excel 2007, 2010 and 2013 will be covered, but most of the course will be relevant to users of any Excel version. The intention is to cover areas that provide real practical benefits which not only make spreadsheets more robust and more reliable, but also improve efficiency and performance.

Please note, the course is not hands-on but comprehensive notes will be provided to allow you to explore the areas covered in more detail.

Content will include:

  • Firm foundations – how to design your spreadsheets to minimise the risk of errors. The basic Excel techniques and knowledge that underpin efficient and reliable spreadsheets.
  • The new workbook review and auditing tools in Excel 2013.
  • What not to use Excel for. Why Excel can’t manage data. How best to get your data into Excel.
  • Managing input – Data Validation and Protection
  • Robust formulae – designing formulae to work reliably and adjust for changes
  • Checks and controls – the Excel functions that can help spot errors for you and bring them to your attention
  • Auditing tools – Excel’s built in error-checking and why you shouldn’t rely on it. The Formula Auditing tools and other techniques to reveal errors and inconsistencies.

Share this event...


Newcastle Gateshead Marriott Hotel Metro Centre

Metro Centre
NE11 9XF

Tel No: 0191 493 2233


Simon Hurst

Simon Hurst is a Chartered Accountant that has been involved in computer software for 16 years. His training organisation, The Knowledge Base, provides a wide range of training and consultancy services to accountants and other professionals.

How to book

The easiest way to book is online by clicking the button to Book Online at icaew.com – you will be able to log into your account at icaew.com and pay with your debit or credit card.

You can also telephone the ICAEW central events booking team on 01908 248159 and pay over the phone.

Alternatively you can download a booking form or book by email.