Video • 6 minutes
Learning Objectives
Lesson Description
This lesson explores how ChatGPT can be used to generate formulas.
It emphasises practicality by applying the generated formula to a real-world scenario. It’ll show the balance of human expertise and AI assistance.
We’ll demonstrate using ChatGPT to create an XLOOKUP formula. We’ll guide you through constructing a prompt tailored to your dataset.
We’ll acknowledge ChatGPT’s usefulness while underlining that optimal results come from having an understanding of Excel and being able to spot errors.