Course Details

yet formula mistakes can easily go unnoticed. This practical session will help you identify errors, investigate incorrect results and improve formula consistency, giving you greater confidence in your figures and spreadsheets that are easier to maintain.


In this session Alan Murray covers the following topics:

  • Check spreadsheet integrity: review workbook structure, source data and formula consistency to identify potential weaknesses.
  • Investigate formula errors: use Excel’s tools to understand the cause and correct the problem.
  • Find incorrect results: spot formulas that use the wrong references, incomplete ranges, are inconsistent, or have flawed logic.
  • Modernise existing formulas: explore how modern Excel functions can simplify calculations and make formulas easier to understand.
  • Improve ongoing maintenance: use Excel Tables, structured references and consistent formula patterns to make workbooks easier to update and review.

CPD Club

Enjoy all of the premium features of the ultimate resource for the UK Accounting Community.

Join CPD Club

CPD Course Speaker

Computergaga

Alan Murray

Alan Murray is an experienced Excel trainer and Microsoft MVP. With over 23 years of experience as an Excel trainer, he helps users build confidence and expertise in Excel and Power BI - empowering them to solve problems, automate tasks, and work more efficiently.

Alan is the author of the ‘Advanced Excel Formulas’ and ‘Advanced Excel Success’ books and has a YouTube channel – named Computergaga – with 118,000+ subscribers and over 50 million views.

He organises the London Excel Meetup group to provide a community event for professionals to network, share, and develop their Excel skills.

Alan loves showing people what’s possible with the tools they already have. His training approach is relaxed, practical, and always focused on the needs of the people in the room. Everyone should feel confident using Excel and empowered to ask any question - no matter how simple or advanced.