Course Details

Accountants rely on Excel for accurate reporting, reconciliations and business decisions, 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 will cover 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.


By attending this session, you will be able to carry out a practical spreadsheet health check, investigate visible formula errors and recognise common causes of incorrect results. You will understand how to simplify existing formulas using modern Excel and apply more consistent approaches that make workbooks easier to review, update and maintain.


This session will be of most interest to accountants in practice and industry, bookkeepers, auditors and finance professionals who prepare, review or inherit Excel workbooks. The session will be particularly useful for those working with management accounts, reconciliations, budgets and other financial reports who want greater confidence in their spreadsheet calculations.


Course level: Intermediate

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.