CPDStore Ireland

Excel formulas are the foundation of almost everything accountants and finance professionals do in Excel. Because of this, having a solid understanding of how formulas work is essential for building accurate, reliable spreadsheets and maintaining confidence when models need to be updated or extended.

This short webinar provides a clear and practical introduction to writing Excel formulas. It focuses on building a strong understanding of how formulas work to give you the confidence to write, adapt, and troubleshoot formulas.

In this session Alan Murray will cover the following topics:

• Writing basic formulas to add, subtract, multiply, and divide values in Excel.
• Calculating percentages correctly and understanding common percentage pitfalls.
• Using essential Excel functions such as SUM, COUNT, AVERAGE, and related functions.
• Understanding and using relative, absolute, and trimmed references.
• How to effectively reference data across worksheets, named ranges, and tables.

By attending this session, you will…

• Understand how Excel formulas work and how they are constructed.
• Be able to confidently write basic formulas and essential functions.
• Know how to calculate percentages and work with dates correctly in Excel.
• Understand how different types of references affect formula behaviour.
• Be better equipped to build reliable spreadsheets and avoid common formula errors.

This session will be of most interest to accountants, finance professionals, and Excel users who are new to formulas or want to strengthen their understanding of Excel’s core formula concepts.

Course level: Beginner / Entry level