The Complete Excel Course with AI Integration

Claude in Excel: analyse data and build sheets

Claude in Excel works inside your workbook like Copilot and thinks a task through like ChatGPT, which is why the AI section of The Complete Excel Course with AI Integration names it the one assistant to keep if you could keep only one. You install it, set it to work on a real cell, watch it fix an error that turns up, then hand it WealthFlow, an industry-standard retirement simulator, to turn into a dashboard, while every formula still answers to you.

Taught by Sagnik Bhattacharya and Virginia Thorn

The Complete Excel Course with AI Integration: Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

You will be able to:

  • Add Claude to Excel from the Add-ins button, sign in, authorise it and get past a first sign-in that fails.
  • Select a cell, ask for the calculation in plain words, and read the formula Claude proposes before it lands.
  • Approve Claude's edits with Allow once, and save accepting everything at once for a throwaway copy.
  • Have Claude add a dashboard sheet with charts drawn from every sheet and restyle the workbook, then inspect its formulas before you trust a figure.
  • Plan an analysis with Claude, from the business questions to the KPIs and charts, with the metric, the breakdown and the time frame spelled out in every prompt.
  • Lay a sheet out as an Excel table with clear headers and proper number formats, so Claude reads each column the way you mean it.

Projects

What you will build.

The course has 14 industry-standard projects. These three matter most here.

  • Project 14

    Agentic AI in Excel

    AI finds and fixes the formula; you check it before it counts.

    Claude joins the toolbox at the close of the AI section: installed, signed in and handed a profit percentage to calculate, then an error to clear, on the same sales workbook Copilot and ChatGPT worked on.

  • Project 10

    WealthFlow

    A retirement plan that shows how long the money lasts.

    The finished retirement simulator, handed to Claude for its dashboard: charts for every sheet, a new style for the workbook, and a last pass in which Claude checks its own work before you check the formulas.

  • Project 08

    MarketPulse

    One screen that shows which campaigns earn back their spend.

    The dashboard's PivotTables requested by prompt from the Home tab, where the lesson points to Claude's button beside Copilot's and runs Copilot: one table per prompt, each matched against the set built by hand.

Tap or pinch to zoom in, drag to move around. Click or scroll to zoom in, drag to move around.

Lessons

The lessons that matter, in course order.

The Complete Excel Course with AI Integration has 186 lessons. This page picks out 8 of them, 41 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 104 Claude in Excel

Ready to install? Go straight to Lesson 104, then come back for Lesson 89 and Lesson 91, which make Claude's answers sharper. Claude's formulas are only as safe as your own Excel, so if tables, formulas and PivotTables are new to you, begin the course at Lesson 1.

8 of 186 lessons · 41 min

10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 2 of 17 lessons · 14 min Where Claude stands among the three, inside the workbook like Copilot and reasoning like ChatGPT, through a panel almost identical to Copilot's; then the table Claude reads best, with clear headers, no merged cells and proper money and percentage formats, checked here with Copilot.
  1. 88 AI in Excel What Copilot, ChatGPT and Claude can and cannot do 8 min
  2. 89 Prepare data for Copilot in Excel Tables, headers and clean structure 6 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 5 min The PRO pattern, a metric, a breakdown and a time frame, shown in Copilot and stated for Claude alike: a vague prompt gets a vague answer from either.
  1. 91 Copilot prompts for Excel Weak vs strong prompts and the PRO prompt pattern 5 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 2 of 17 lessons · 5 min A QA checklist for anything an AI builds, then the planning lesson that hands the heavy thinking to ChatGPT or Claude: business questions, KPIs with Excel-style formulas and charts, drafted as a checklist before you build.
  1. 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
  2. 100 ChatGPT as your analysis planner Plan an Excel analysis before you build it 3 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) 1 of 17 lessons · 7 min Claude in Excel from the Add-ins button to a working answer: sign-in and authorisation, the role questions skipped, a profit percentage written into the selected cell with Allow once, and an error in another column fixed on request.
  1. 104 Start here Claude in Excel Analyse data and build spreadsheets with Claude 7 min
11 MarketPulse campaign intelligence dashboard 1 of 10 lessons · 6 min MarketPulse's PivotTables requested from the Home tab, where Claude's button sits beside Copilot's; the lesson runs Copilot, one table per prompt, each matched against the PivotTables built by hand.
  1. 110 PivotTables with Copilot Generate and verify marketing pivots in Excel 6 min
13 WealthFlow investment and retirement simulator 1 of 11 lessons · 5 min The dashboard of WealthFlow, delegated to Claude with a style of its own for every sheet; it rechecks its work at the end, and the lesson approves everything in one go only because the file is a throwaway copy.
  1. 135 Retirement simulator in Excel Claude builds the WealthFlow dashboard 5 min

Instructors

Who teaches it.

Virginia Thorn smiling at the camera, dark hair tied back, wearing a navy top.

Instructor, Excel with AI

Virginia Thorn

Emmy Award winner. Teaches Excel with AI at Coding Liquids.

Questions

Asked before starting.

Is there a course that teaches Claude in Excel?

Yes. The Complete Excel Course with AI Integration from Coding Liquids teaches Claude in Excel from the install to real work: a calculation in the cell you pick, an error cleared on request, then the whole dashboard of WealthFlow, an industry-standard retirement simulator. Like every project in the course, WealthFlow was designed after talking with people from many different industries. Around Claude you get the habits that make any assistant safe to use: a table it reads correctly, a prompt with a clear metric and a checklist for its output. This guide picks out 8 lessons (41 minutes).

How do I install Claude in Excel?

From the Add-ins button towards the right of the Excel ribbon, with a paid Claude plan that includes the add-in: search for Claude, add it, sign in with your email or Google account and enter the code you are sent. The Complete Excel Course with AI Integration walks you through the rest on screen, from authorising the connection and pasting the sign-in code to skipping the onboarding questions and giving Claude its first task, so you are at work within one lesson (Lesson 104).

What if Claude in Excel will not sign in?

Do what The Complete Excel Course with AI Integration does when its own first attempt fails: make sure you are signed in to Claude in your default browser, restart Excel, run the sign-in again, authorise the connection and paste the code Claude gives you (Lesson 104). If Claude asks you to upgrade, that is your Claude plan asking, not a fault in Excel.

Is Claude in Excel free?

You can learn all of it before you pay for it: Claude in Excel runs on a paid Claude plan, and The Complete Excel Course with AI Integration lets you follow every lesson first, which is exactly what it advises before you buy any assistant. The WealthFlow dashboard step is one the lesson calls a luxury, something you can build yourself with formatting and the chart menu (Lesson 135), and the MarketPulse lessons say no paid AI plan is needed to finish that project (Lesson 106).

What can Claude do in an Excel workbook?

Work out a figure where you want it, repair what breaks and build whole sheets. In The Complete Excel Course with AI Integration, Claude writes a profit percentage into the selected cell, clears an error that appears in another column, then takes the finished WealthFlow simulator and adds a dashboard sheet with charts drawn from every sheet and a new style for the workbook (Lesson 135). At the end it goes back over its own work, a difference from ChatGPT the lesson points out.

Should I let Claude edit my workbook without asking?

Keep it asking. Before each change Claude offers Deny, Always allow and Allow once, and The Complete Excel Course with AI Integration picks Allow once, so every edit is one you saw (Lesson 104). Accepting all edits in one go happens once, in the WealthFlow lesson, on a throwaway copy, with the plain warning never to do it on a workbook you care about, least of all one that holds your life savings.

Does Claude get Excel formulas right?

Most of the time, and The Complete Excel Course with AI Integration trains you for the rest: the instructor's own testing finds Claude right usually, not always, so whatever it writes, you check (Lesson 135). In the install lesson an error shows up in another column after Claude's first edit, and asking Claude to clean it up fixes it. The QA checklist in Lesson 99 then gives every figure a final test.

Can Claude plan an Excel analysis before it builds anything?

Yes, and planning is where it earns its place. The planning lesson of The Complete Excel Course with AI Integration hands the heavy thinking to ChatGPT or Claude: business questions, KPIs with Excel-style formulas and the charts to draw, written as a checklist you paste into Excel, with the prompt for the build drafted too (Lesson 100). Add the PRO pattern, a metric, a breakdown and a time frame in every request (Lesson 91), and Claude can do both halves, planning and building, which is the lesson's own case for it.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

The same course

For another job, goal, level, topic or comparison.