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.