Excel Formulas - A Beginners Guide (2026) (Feb 26)
Category: Technology | Duration: 2hrs | Tag: VODECADD5 | Type: Video | Course Level: Foundation | Speaker: Alan Murray | Date: 11/02/2026 14:00
Course Details
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 course 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 covers 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.
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.
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.