Excel: Part 2 - Formulas and Calculations with ChatGPT
Category: Technology | Date: 18/02/2026 14:00 | Duration: 100 mins | Tag: WEBEC26ADD2 | Type: Webinar | Speaker: Alan Murray | Course level: Intermediate | Channel: ProfitPro
This course is part of 3 Part Series - Excel: Exploring AI-Powered Insights & Efficiency in Excel with ChatGPT
Course Details
Formulas are at the heart of Excel, and ChatGPT offers a new way to create, understand, and troubleshoot them. In this session, you’ll explore how ChatGPT can help write formulas, explain how they work, correct errors, and generate multiple variations of a calculation. You’ll see how ChatGPT supports modern Excel functions — including lookups, dynamic arrays, and text manipulation — helping you move from “stuck” to “solution” in seconds.
In this session Alan Murray will cover the following topics
- How ChatGPT interprets and writes Excel formulas from natural language prompts.
- Creating lookup, text, date, and dynamic array formulas with ChatGPT.
- Explaining formula operation in simple, friendly language.
- Debugging formula errors and fixing broken calculations.
- Using ChatGPT to modernise outdated formula approaches.
By attending this session, you will
- Learn how to use ChatGPT to write clear, accurate Excel formulas.
- Understand how to prompt ChatGPT for different calculation types.
- Gain confidence checking ChatGPT-generated formulas for correctness.
- Discover new ways to modernise and simplify your formula sheets.
- Use ChatGPT to interpret complex instructions and generate the most suitable formula approach.
This session will be of most interest to, Accountants, finance teams, and business users who rely on formulas for reporting, analysis, reconciliations, or modelling — and want to harness ChatGPT to assist with their process.
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.
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.