Channel Islands Conference 2026: Solving formula problems in Excel

This event was recorded on 23 June 2026

Join the annual ACCA Channel Islands Conference and explore the key issues facing finance professionals in the region. Update your knowledge, earn up to 21 CPD units, and gain insights from expert speakers.

The programme blends technical, compliance, professional development, and technology topics to support the evolving role of today’s accountant.

Sessions can be booked individually, or you can attend the full conference at a discounted rate. To view the full conference schedule, click here.

Overview:

We’ve all been there. A formula that worked yesterday suddenly returns an error. A number does not quite look right. Or worse, everything looks fine, but something is off and you cannot see why.

This practical workshop is designed for accountants and analysts who want to get better at diagnosing and fixing formula problems in Excel. Rather than focusing on individual functions, the session is about building a clear, logical approach to troubleshooting so you can stay in control when things go wrong.

You will learn how to break formulas apart, understand what Excel is doing, and spot issues. Along the way, we will also look at simple techniques that make your formulas easier to read, easier to check, and far less likely to go wrong in the first place.

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.

1.5 CPD units

ACCA members can use this learning to meet their CPD requirements provided it is relevant to their career. If the event contributes to general knowledge and skills, it should be recorded as non-verifiable CPD. If the learning can be applied in the workplace, it will contribute to verifiable CPD.

1 hour of learning = 1 unit of CPD.

Fee: 58 GBP + VAT (69.6 GBP) per delegate

Please note: If you are unable to join the live webinars, they will be available on-demand 24 hours after the live webinar ends and you will have access to the sessions for 12 months.

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 is organised by ACCA UK Continuous Learning Team.

If you have any queries regarding this event please contact us on: