ChatGPT for Excel: Formulas, Cleanup and Error Fixes
What you’ll be able to do: After this course you can give ChatGPT a spreadsheet export and get working SUMIFS and XLOOKUP formulas with each part explained, then make it prove the result on rows you can check by hand. You can have it list every problem in a messy export before it changes anything, clean the file by your rules, and put what it cannot know in a Needs review column. And you can hand it a note about a broken workbook and get each error explained in plain words, fixed at the cause, with a safer lookup formula to copy down.
- Who it’s for
- Office managers, dispatchers, coordinators, bookkeepers and anyone who works in Excel without being an Excel expert. You need a ChatGPT account to do it for real. No formulas to memorize and no coding.
- Time needed
- About 27 minutes of hands-on practice: 3 modules of 9 minutes each.
- Cost
- Free. No credit card, no trial, and no sign-up needed to start.
- Level
- Beginner
- Prerequisites
- None for the practice: a web browser on a desktop or laptop. To repeat the modules in your own tools: a ChatGPT account.
- Format
- Self-paced and online. Each module runs in a practice copy of the real tool that checks every step, then a checklist walks you through doing it for real.
- Tools you practice in
- ChatGPT.
Why this course
Most people who use Excel at work are not Excel experts. They inherit a workbook, get an export from some system, and need one total by Friday. The formula they need exists, but they do not know its name, and the error on screen tells them nothing.
This course is three jobs, each on a made-up but realistic file you can download: a freight broker's October shipments, a college workshop sign-up export full of duplicates and mixed dates, and an architecture firm's billing sheet with five errors. Every answer you see is from a real ChatGPT run on 16 November 2026, trimmed but not reworded, and every module ends with you checking the numbers by hand. The formulas were not pasted into a real workbook during the run, so each module tells you what to test in your own copy of Excel.
What you’ll build
- Module 1: You are a dispatcher at Harbor Line Freight (made up) with a 14-row October shipments export. You get three formulas: a Total Cost per load, a SUMIFS for one carrier's delivered October loads, and an XLOOKUP that shows "Not found" for a missing Load ID.
- Module 2: You run workshop sign-ups at a college continuing-education office (made up). You attach a 16-row export, get every problem listed with its Reg ID, and then have it cleaned by your rules.
- Module 3: You are the office manager at Ridgeway Architects (made up). You attach a note describing the two sheets, the formulas and the five errors, and ask for the meaning, the cause and the right fix for each.
- Module 1 · ChatGPT · Beginner · ~9 min
ChatGPT: Write Excel Formulas from Plain English (SUMIFS and XLOOKUP)
You’ll be able to: Get a Total Cost formula, a SUMIFS for one carrier in one month and an XLOOKUP with "Not found", then make ChatGPT list the rows it counted so you can check the $4,950.70 by hand.
- Module 2 · ChatGPT · Beginner · ~9 min
ChatGPT: Clean Up a Messy Spreadsheet Export Without Guessing
You’ll be able to: Have ChatGPT list every problem in a 16-row registration export first, then clean it by your rules: 13 rows kept, 3 duplicates listed, 4 rows flagged for review, nothing guessed.
- Module 3 · ChatGPT · Beginner · ~9 min
ChatGPT: Fix #N/A, #VALUE!, #DIV/0! and #REF! Errors in Excel
You’ll be able to: Get five Excel errors explained and fixed at the cause, a checked $4,330.00 subtotal with the one row it cannot total, and a lookup formula that survives trailing spaces.
Prerequisites
- For the practice: a web browser. Each module runs in a copy of the real tool’s screens, so you need no account and no sign-up to start module 1.
- To do it for real: a ChatGPT account. Each module says which one it uses.
Time to complete
About 27 minutes of hands-on practice across 3 modules (57 steps in all). Modules take about 9 minutes each, so you can do one in a sitting and come back for the next.
Questions about this course
Can ChatGPT write Excel formulas?
Yes. Tell it which column holds what, which cell the answer goes in and which version of Excel you use, and ask it to explain each part. In module 1 it wrote a SUMIFS and an XLOOKUP for a 14-row shipments export, and its total matched a hand check. Always test a formula on rows you can add up yourself.
Is there a free ChatGPT for Excel course?
Yes. This one is free: 3 short hands-on modules, about 27 minutes in all, in a practice copy of ChatGPT that runs in your browser. No credit card and no sign-up to start, and you can download the same sample files to try in your own ChatGPT.
Can ChatGPT clean up a messy spreadsheet?
Yes, if you make it list the problems first and give it rules. In module 2 it found three duplicate pairs, mixed date formats and broken emails in a 16-row export, then returned 13 clean rows and flagged four it could not fix without guessing. Open the cleaned file and check the flagged rows before you use it.
Why does my Excel formula show #N/A or #VALUE!?
#N/A means a lookup did not find a match, often because of a trailing space or a code missing from the lookup table. #VALUE! means Excel was asked to do math on text, such as "7.5 hrs". Module 3 walks through both, plus #DIV/0! and #REF!, on one billing sheet.
Do I need Microsoft Copilot or a paid ChatGPT plan?
No. Everything here is plain ChatGPT with a file attached, not Copilot. The answers in the lessons came from a Plus account on 16 November 2026. Free accounts have tighter limits on file uploads, so check what your plan allows; a free account may also answer a little differently.
Is it safe to upload a work spreadsheet to ChatGPT?
Follow your company's rules first. The lessons use a Temporary Chat, which stays out of your history, and made-up files. For real customer or payroll data, use your company's approved AI tool or remove the names first.