Webinar Information

They say that repeating the same action and expecting different outcomes is a sign of madness. Surely then when it comes to spreadsheets, building them without incorporating the necessary checks, and then being surprised when errors arise, is the greatest madness of all!

If you want to know what can happen when business-critical decisions are made using poorly-built spreadsheets, this session will provide humorous but very real Excel horror stories, highlighting common errors many of us make every day without even realising it.

In this webinar, we will explore how to spot errors that are made regularly when using common Excel functionality such as VLOOKUP, working with dynamic arrays, and linking files, and simple steps you can take to mitigate them. You’ll learn to look past the obvious formula errors and delve deeper, as well as understanding more about how to avoid errors in the first place.

If we were given £1 for every time we unearthed a material error, we’d have at least #REF! by now.

How to review a spreadsheet publication.

Speakers

Dr. Liam Bastick, SumProduct: Liam has over 30 years’ experience in financial model development / auditing, valuations, M&A, strategy, training, and consultancy. He has considerable experience in many different sectors (e.g. banking, energy, media, mining, oil and gas, private equity, transport and utilities). He is a regular contributor to the ICAEW, ICAA, CPAA, CIMA, Finance 3.0 and various LinkedIn specialist discussion groups. He is also an experienced facilitator for ICAA. Liam is a Fellow of the ICAEW, a Fellow of CIMA and is a professional mathematician.

Costs

This webinar is brought to you by the Excel Community.

For more information about Excel Community membership please visit icaew.com/joinexcel.

Webinar FAQs

Should you experience webinar difficulties, please click here

ICAEW's terms and conditions

• Event terms and conditions
• Data protection policy