Excel: Part 2 - Formulas and Calculations with Copilot (May 26)
Category: Technology | Duration: 2hrs | Tag: VODEC26ADD8 | Type: Video | Course Level: Intermediate | Speaker: Alan Murray | Date: 06/05/2026 14:00
Course Details
Formulas are central to Excel, and Copilot introduces a faster, more conversational way to build them. In this session, you’ll see how Copilot can turn plain-English requests into formulas, explain how formulas work, and help troubleshoot problems when calculations go wrong. The session will focus on practical formula tasks, while also showing how Copilot can help users take advantage of modern Excel functions.
In this course Alan Murray covers the following topics:
- Using Copilot to create formulas from natural language instructions.
- Generating formulas for lookups, text calculations, dates, conditional logic, and dynamic arrays.
- Using Copilot to explain formulas in simple language.
- Troubleshooting broken formulas or unexpected results with Copilot support.
- Improving and modernising formula approaches with Copilot suggestions.
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.