- Key features
- Speaker
- Further information
Key features covered:
- Understanding and fixing common errors
What errors like #REF!, #VALUE!, and #SPILL! are really telling you, and how to resolve them without guesswork. - Breaking down complex formulas
How to step through calculations, simplify logic, and make sense of formulas that have become a bit… complicated. - Auditing and debugging techniques
Practical ways to check your work, including tracing precedents, finding overwritten formulas, reviewing formulas across a sheet, and more. - Improving formula design
Simple ways to build clearer, more reliable formulas using modern Excel features such as LET and dynamic arrays.
By the end of the session, you will have a structured approach to troubleshooting formulas and the confidence to deal with problems quickly, without staring at your screen wondering what Excel is thinking.
Alan Murray
Alan Murray is an Excel trainer, founder of Computergaga.com and author of the Advanced Excel Success and Advanced Excel Formulas books. He has been helping people in Excel for over 23 years. He loves training and the joy he gets from knowing he is making peoples working lives easier. Alan’s Computergaga YouTube channel has over 650 videos and over 50 million views. He also runs the monthly London Excel Meetup Group, where people learn, network, and enjoy each other’s company.
The webinar handout material will be available on the webinar platform when you log in to view the session.
If you wish to view or download handout materials, before starting the webinar, they will also be available through your document library on https://events.accaglobal.com
This event was recorded on 23 June 2026
Price
Price (excluding VAT) 58 GBP
Location
United Kingdom
Date & time
On demand
Enquiries
Email enquiries UKCL@accaglobal.com
Course provider