The skill behind this guide: AI Excel Tutor. Turns Claude, ChatGPT or Gemini into a tutor that has you build the workbook yourself, formula by formula - $19, one payment, yours permanently.
View the Excel tutor →As an Excel tutor, Claude has one genuine advantage over every course you have tried: it can teach against your own messy export instead of a tidy demo file. It cannot open your workbook, it cannot click a ribbon for you, and it does not know which Excel version you are on until you say so. What it can do is read the rows you paste, tell you why your lookup returns #N/A, and make you write the formula yourself. The workbook stays in your hands.
That constraint is useful. Most Excel help online is written against an imagined sheet with clean headers and no merged cells, which is why it stops working the moment you try it at your desk. A tutor that starts from your actual columns skips that entire failure mode.
What does an AI Excel tutor teach that a course does not?
Order, mostly. Courses teach Excel by feature, working left to right along the ribbon. People break in a completely different order, and the useful arc looks like this: absolute references first, because $ is the reason half of all dragged formulas go wrong; then IF and IFERROR; then XLOOKUP and INDEX MATCH; then SUMIFS; then cleaning numbers that are secretly text; then tables; and only at the end PivotTables and dynamic arrays.
The AI Excel Tutor runs that arc as one explanation, one worked example, one task, one check. The task is on data you supply, which is the part that makes it stick, because your real export has trailing spaces and a date column stored as text and the demo file never did.
How do you set Claude up as an Excel tutor?
Give it the three things it cannot see: your version, your real column headers, and about ten real rows with the mess left in. Change anything confidential before pasting, but do not clean it up, because the mess is the curriculum.
You are my Excel tutor. Do not teach anything yet.
My Excel version: [Microsoft 365 / Excel 2021 / Excel 2019 / Excel for Mac / Google Sheets]
My real headers: [PASTE THE HEADER ROW]
Ten real rows, mess included: [PASTE ROWS]
What I am actually trying to produce: [a summary by region / a monthly total / a clean list]
First, tell me what is already wrong with this data that will bite me later: text that looks like numbers, inconsistent labels, blanks that are not blank.
Then give me one task against these columns that I have to write the formula for myself. Tell me what the correct answer should be so I can check.
Do not give me the formula. If I paste a broken one, work from that.
Why does your lookup keep returning #N/A?
Usually for one of four reasons, and none of them is the formula being written wrong. The lookup value has a trailing space. One side is text and the other is a number. The lookup column is not the leftmost column and you are using VLOOKUP. Or the sheet reference moved when you dragged. A tutor that just sends you a corrected formula fixes today and leaves all four causes in place.
My formula returns [#N/A / #REF! / #VALUE! / #DIV/0! / the wrong number].
Formula: [PASTE IT]
What I expected: [SAY IT]
What the cells actually contain: [PASTE A FEW]
Do not give me a corrected formula.
1. Tell me what this error means in general, in one sentence.
2. List the likely causes in order of how often they are the real one.
3. Give me one thing to type in an empty cell that will tell us which cause it is. Then wait for what I see.
4. Once we know, ask me what I should change, and correct my answer rather than replacing it.
Finish with the one habit that stops this error recurring.
LEN on both cells is the answer more often than people expect. A trailing space is invisible and fatal, and finding that yourself once is worth more than ten corrected formulas.
Different job from the tutor. This one does not teach, it answers: it asks for your version and your real rows, writes the formula, and explains every part so you can change it later. Error diagnosis by cause, XLOOKUP versus INDEX MATCH for your version, and twelve ready-made requests. $9, one payment. There is a Google Sheets version too.
View Claude for Excel →How do you learn PivotTables without watching someone click?
PivotTables are the one place where the usual objection lands: Claude cannot see your screen, and a pivot is built by dragging. It still works, but the division of labour changes. It tells you what goes in Rows, Columns, Values and Filters for the question you asked, and why. You do the dragging and report what came out.
I want to answer this question from my data: [THE QUESTION, e.g. total sales by region by month]
My headers: [PASTE]
My Excel version: [VERSION]
1. Tell me whether a PivotTable is actually the right tool here, or whether SUMIFS or a formula would be simpler. Commit to an answer.
2. If it is a pivot: tell me exactly which field goes in Rows, Columns, Values and Filters, and what each choice does to the output.
3. Tell me what the result should roughly look like, so I can tell if I dragged something into the wrong box.
4. Then stop. I will build it and describe what I got.
If what I describe is wrong, tell me which box is the problem, not the whole recipe again.
Where does it fail?
- It cannot open your file. Everything it knows comes from what you paste or screenshot. A formula built on assumed headers will look right and reference the wrong column.
- Version differences are real. XLOOKUP and dynamic arrays do not exist in older builds. Say which version you have in the first message or you will be taught a function you cannot use.
- It cannot verify your numbers. If your total is wrong for a reason outside the pasted rows, filtered data, a hidden sheet, it has no way to know.
- Macros and VBA are a different skill. It can write VBA, but debugging a macro against a workbook it cannot run is much weaker than formula help.
- It will hand you the formula if you ask. Convenient, and it ends the teaching. Keep the no-answers rule in the prompt.
- Menu paths drift. Ribbon locations differ between Windows, Mac and versions, and recalled click paths are occasionally out of date.
What comes after the Excel tutor?
Three directions, depending on why you learned it. If the spreadsheet keeps growing until it is slow, the honest answer is a database, and the AI SQL Tutor teaches the language that replaces most of what you were doing with SUMIFS. If the repetitive part is the problem, the AI VBA Tutor covers automating inside Excel itself. And if the output is a report somebody else reads, the AI Power BI Tutor is where the pivot habits transfer. For day-to-day speed rather than learning, AI Excel Formula Generator ($4.99) writes a single formula on demand, and Claude for Google Sheets ($9) does the Claude for Excel job on the Google side.
The point where Excel stops being the bottleneck and the analysis does. Clara works on framing the question, choosing the comparison and saying what the numbers do not support, which is the skill nobody teaches alongside the formulas. $29, one payment. Learn the mechanics with the tutor, then bring Clara to the actual analysis.
View Clara →How do you install the file?
The tutor is a SKILL.md file inside a ZIP. In Claude, open Customize → Skills, press the + button, choose Create skill, then Upload a skill, and select the ZIP. Toggle it on and it is live. Skills are available on the Free, Pro, Max, Team and Enterprise plans.
The one real requirement is code execution. If the Skills menu is greyed out, turn it on under Settings → Capabilities, where it is listed as code execution and file creation. On Team and Enterprise plans an owner controls it in Organization settings, so if it is switched off org-wide, that is who to ask. Anthropic documents all of this in its Skills help article.
If you cannot enable code execution, or you are working in ChatGPT or Gemini, the fallback uses the same file: open the ZIP, copy the contents of SKILL.md, and paste it into a Project, a custom GPT, a Gem or plain custom instructions. The behaviour is identical, you just re-paste it when you move tools.
In summary:
Use the AI Excel Tutor ($19) to be taught on your own export, in the order Excel actually breaks, with the formulas written by you. Keep Claude for Excel ($9) for the workbook that is due today, and go on to AI SQL Tutor or AI Power BI Tutor ($19 each) when the spreadsheet stops being the right container. All work in Claude, ChatGPT and Gemini, no coding, 30-day money-back guarantee.
AI Excel Tutor
One file, pasted once. It places you on your own messy data, teaches absolute references before PivotTables, and asks you to run LEN instead of sending a corrected formula. No subscription.
KissMySkills is a marketplace of 853 AI skills, 158 prompt packs, 55 agents & free tools for Claude, ChatGPT & any AI chat.
Related Skill Guides
- How to Use Claude as a Python Tutor (It Will Not Write Your Code)
- How to Use Claude as a JavaScript Tutor (In the Console, Not in a Video)
- How to Use Claude as a Homework Helper and Study Buddy
- How to Use Claude as a Document Summariser: The Jules Skill Guide
- How to Use Claude as a Research Assistant: The Aiden Skill Guide
- Best Claude Skills in 2026: 25 Skills Worth Installing