!—Cookiebot Consent Notice start for icaew.com -->
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.
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.
This webinar is brought to you by the Excel Community.
For more information about Excel Community membership please visit icaew.com/joinexcel.
Should you experience webinar difficulties, please click here
This screen shows you the details for the selected product.
Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.
If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you. Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.
If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.
Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.