Supercharge Excel & Google Sheets with ChatGPT
Learn how to connect ChatGPT to Excel and Google Sheets to automate formulas, clean data, and supercharge your workflow — no coding required. Turn hours of manual spreadsheet work into minutes using the power of AI.
"Give me an hour with your spreadsheet workflow and I'll show you where AI can hand you back half your week."— Sherrie K Licon
What you'll learn
What you'll be able to do
- Connect ChatGPT to Google Sheets using the GPT for Sheets add-on and to Excel via the OpenAI API or third-party plugins
- Write effective prompts that generate accurate spreadsheet formulas on demand — from simple SUMIFs to complex nested logic
- Automate repetitive data-cleaning tasks such as deduplication, reformatting, and categorisation using AI directly inside your sheet
- Build AI-powered reporting templates that summarise and narrate raw data in plain English with a single prompt
- Use ChatGPT to analyse and explain unfamiliar formulas or debug broken ones in seconds
- Create a reusable personal prompt library tailored to your specific spreadsheet workflows for lasting productivity gains
How it works
A school that adapts to you
This isn't a set of static videos. Every lesson is generated live and tuned to where you actually are.
We learn your level
A quick placement check tailors your starting point so you're never bored or lost.
Lessons adapt as you go
Each lesson is written for your pace and your goal, adjusting as your skills grow.
Your AI coach keeps you moving
Checkpoints, feedback, and gentle nudges turn progress into a real result.
The curriculum
What's inside your school
5 modules · 15 lessons
Getting Connected: ChatGPT Meets Your Spreadsheet
Establish a solid conceptual and technical foundation before touching any formula or automation. Learners understand how AI integrates with spreadsheets, then walk away with a live, working connection in both Google Sheets and Excel — the essential prerequisite for every module that follows.
- 1.1How ChatGPT and Spreadsheets Work TogetherIncluded
- 1.2Setting Up API Keys and Account PrerequisitesIncluded
- 1.3Connecting ChatGPT to Google Sheets with GPT for SheetsIncluded
- 1.4Connecting ChatGPT to Excel via Plugin and APIIncluded
AI-Powered Formula Generation
Transform ChatGPT into an on-demand formula engineer. Learners progress from writing clear single-function prompts to generating sophisticated nested logic, then close the loop by using AI to explain and debug formulas — covering the full formula lifecycle.
- 2.1Prompting ChatGPT to Write Formulas for YouIncluded
- 2.2Tackling Complex and Nested FormulasIncluded
- 2.3Debugging and Explaining Formulas with AIIncluded
Automating Data Cleaning with AI
Target the most time-consuming part of any data workflow — cleaning raw, messy data. Learners build AI-driven processes for standardisation, reformatting, deduplication, and categorisation that run directly inside their sheets, turning hours of manual work into a repeatable, prompt-driven pipeline.
- 3.1Understanding Your Data Before Cleaning ItIncluded
- 3.2Standardising and Reformatting Messy DataIncluded
- 3.3Deduplication and Smart CategorisationIncluded
AI-Powered Reporting and Data Narration
Elevate raw numbers into clear, professional narratives. Learners discover how to prompt ChatGPT to summarise datasets, highlight anomalies, and write executive-ready commentary — then lock those workflows into reusable templates that anyone on their team can run with a single prompt.
- 4.1Writing Data Summaries and Narratives with ChatGPTIncluded
- 4.2Building Reusable AI Reporting TemplatesIncluded
Building Your Personal AI Prompt Library
Consolidate everything learned into a lasting personal productivity system. Learners analyse what makes a prompt generalisable, build and organise a structured prompt library tailored to their own workflows, and complete a capstone project that integrates every skill from the course into one end-to-end AI-powered spreadsheet solution.
- 5.1What Makes a Prompt Reusable and ReliableIncluded
- 5.2Organising and Documenting Your Prompt LibraryIncluded
- 5.3Capstone: Your AI-Powered Spreadsheet WorkflowIncluded
Who it's for
Is this you?
The Overloaded Analyst
You live in pivot tables and data exports — this course cuts the formula-wrestling and manual cleaning that eats your afternoons.
The Small Business Owner
You're doing your own reporting and bookkeeping — AI-powered templates mean you get clear summaries without hiring a data person.
The Office All-Rounder
Spreadsheets land on your desk from every direction — learn to handle messy data and unfamiliar formulas with AI as your co-pilot.
The Spreadsheet Power-User
You already know your way around Excel — now learn to use ChatGPT to go faster, debug smarter, and automate the repetitive stuff.
The Operations Manager
You need clean, reliable weekly reports — build reusable AI reporting templates that narrate raw data in plain English automatically.
The Career Switcher
You're building data skills to level up professionally — this course gives you a practical, modern toolkit without requiring a coding background.
Questions
Frequently asked
Your teacher
A note from your teacher
Sherrie K Licon
If you've ever spent 45 minutes building a formula that still came out wrong, or Monday-morning'd your way through reformatting the same messy export for the hundredth time — I built this course for you.
Spreadsheets are supposed to make work easier. And they do, up to a point. But most of us hit a ceiling where the formulas get complicated, the data gets messy, and the reports get repetitive. You know there's a better way; you just haven't had someone sit down and show you what it actually looks like. That's what I want to do here.
AI Spreadsheet Pro is everything I wish someone had walked me through when AI tools started showing up in my own workflow. We start at the very beginning — getting ChatGPT properly connected to Google Sheets or Excel — and work all the way through to building a personal prompt library that makes you faster every single week. Every step is practical. Every lesson ends with something you can actually use in your next real task.
Here's the thing I hear most often: "I tried ChatGPT for spreadsheets but it didn't really work for me." Almost always, that comes down to prompting. Knowing how to ask is the whole skill — and it's genuinely learnable. Once you understand what a reliable, reusable prompt looks like, the formula generation, the data cleaning, the reporting — it all clicks. That's the heart of what this course teaches.
You don't need a programming background. You don't need to be a spreadsheet expert. You just need to use Excel or Google Sheets regularly and want to stop doing the slow way what AI can help you do in seconds. Come ready to open a spreadsheet and follow along — that's all it takes to get started.
— Sherrie K Licon
Start your journey today
Join get instant access — learn at your own pace with an AI coach in your corner.
- 5 modules, 15 lessons
- AI-adaptive lessons tuned to your level
- Quizzes & checkpoints to lock in progress
- Your own AI learning coach
- Learn on any device, at your pace
- Full access for as long as you're subscribed