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, Liam Bastick 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.
First broadcast on 20 February 2023