The Complete Excel Course with AI Integration
How to use Copilot in Excel, step by step
Copilot can summarise a sheet, build a PivotTable or fill a formula column in seconds, and hands you a wrong answer just as confidently as a right one. The Complete Excel Course with AI Integration makes you fast and right: where Copilot sits, when App Skills should edit your sheet, the prompts that get exact answers and the checks that catch a slip before anyone else does. Then it goes to work in industry-standard projects, from MarketPulse's campaign PivotTables to a Power Automate flow.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Open Copilot from the Home tab, let App Skills make changes on the sheet or Chat explain them, and undo any edit you do not want.
- Ask for a figure, its breakdown and its time frame in one prompt, and get an executive summary, a PivotTable or a chart ready for your report.
- Have Copilot add formula columns with structured references and IFERROR, and prove each one on a row you work out yourself.
- Fill a column with the COPILOT function, a prompt written into a formula that answers row by row.
- Clear stray spaces and mismatched spellings with Copilot's own suggestions, and list the rows that break a rule you define, such as a discount above 10%.
- Put everything Copilot builds through a QA checklist before it reaches a report: the data it used, the dates, each chart's source and every total.
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.
Copilot on one sales workbook, from the first prompt to a mini dashboard with slicers, in a starter workbook with the finished one beside it: summaries, PivotTables, charts, formula columns and cleaning, every result held up against the data.
-
Project 08
MarketPulse
One screen that shows which campaigns earn back their spend.
Copilot plans the campaign KPIs and reports inconsistencies in the data, then builds the dashboard's PivotTables, one prompt per table, each matched value by value against the set you built by hand.
-
Project 13
AutoFlow
The weekly report routine, run by a flow instead of by you.
Copilot Vision watches your Power Automate Desktop window and answers out loud while you build a flow, a part of the course that runs on Windows.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 17 of them, 1 h 18 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 88 AI in Excel
Copilot already on your Home tab? Start at Lesson 88 and keep going in order, since each lesson builds on the workbook the one before it left. You judge Copilot's answers with your own Excel, so if tables, formulas and PivotTables are new to you, begin the course at Lesson 1.
17 of 186 lessons · 1 h 18 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) Every everyday Copilot job on one sales workbook, ending in a mini dashboard with KPIs, charts and slicers: a table Copilot reads cleanly, Chat against App Skills and the PRO prompt pattern, then summaries, PivotTables, charts, formula columns, outliers and cleaning, with ChatGPT on some of the same jobs for contrast and a QA checklist to finish.
- 88 Start here AI in Excel What Copilot, ChatGPT and Claude can and cannot do 8 min
- 89 Prepare data for Copilot in Excel Tables, headers and clean structure 6 min
- 90 Copilot executive summary in Excel Summarise a dataset in seconds with AI 5 min
- 91 Copilot prompts for Excel Weak vs strong prompts and the PRO prompt pattern 5 min
- 92 PivotTables with Copilot Build an Excel PivotTable from a prompt 5 min
- 93 Charts with Copilot and ChatGPT Create and choose the right Excel chart 6 min
- 94 Conditional formatting with Copilot and ChatGPT Highlight problems in Excel 4 min
- 95 Excel formulas with AI Copilot and ChatGPT write formula columns you verify 6 min
- 96 Find outliers with Copilot in Excel Discounts, negative profit, suspect rows 7 min
- 97 Clean messy data with Copilot in Excel AI prompts plus Excel functions 4 min
- 98 Mini dashboard with Copilot in Excel KPIs, charts and slicers on one page 3 min
- 99 Check AI output in Excel A quick QA checklist for Copilot results 2 min
10 Boosting productivity with AI in Excel (Copilot, ChatGPT and Claude) Copilot in the cell and at your side: the COPILOT function answering a prompt row by row, Copilot drafting an ordinary formula as you type, and guided help, a voice that sees your Excel window and explains the feature in front of you.
- 101 COPILOT function in Excel Use Copilot as a formula inside your cells 4 min
- 102 Copilot guided help in Excel Step-by-step AI help inside Excel 3 min
11 MarketPulse campaign intelligence dashboard The MarketPulse campaign data checked for duplicates, then Copilot drafts the KPIs and a game plan for the dashboard and reports any inconsistency in the data.
- 106 Clean and check marketing data in Excel Remove duplicates, Copilot KPI plan 4 min
11 MarketPulse campaign intelligence dashboard The dashboard's PivotTables requested from Copilot: three asked for in one prompt come back as one, so each gets its own prompt and its values are matched against the PivotTables built by hand.
- 110 PivotTables with Copilot Generate and verify marketing pivots in Excel 6 min
16 Power Automate: weekly sales report automation Copilot Vision in Power Automate Desktop: share the window, and Copilot sees your flows and answers out loud, here asked how to add an If condition to a flow. The lesson uses a premium plan, which following along does not need, and like the whole Power Automate section it needs Windows.
- 177 Copilot Vision with Power Automate AI-guided help while you build a flow 2 min
Instructors
Who teaches it.
Instructor, Excel with AI
Virginia Thorn
Emmy Award winner. Teaches Excel with AI at Coding Liquids.
Questions
Asked before starting.
How do I use Copilot in Excel?
Select your table, open Copilot at the far right of the Home tab and ask for exactly what you want: the figure, how to break it down and the period. The Complete Excel Course with AI Integration from Coding Liquids turns that into a working routine on a sales workbook, from an executive summary and a PivotTable built from one prompt to charts, formula columns, outlier hunts, cleaning and a mini dashboard. Then Copilot works inside MarketPulse, one of the course's industry-standard projects, each designed after talking with people from many different industries. This guide picks out 17 lessons (1 hour 18 minutes).
Where is Copilot in Excel, and why can't I see it?
Look at the far right of the Home tab: Copilot appears there once your Microsoft 365 plan includes it, the plan the opening AI lesson of The Complete Excel Course with AI Integration tells you that you need (Lesson 88). No button usually means your plan or your organisation's settings leave it out. When the panel stalls or the new-chat button does nothing, the lessons show the fix that works: close Excel and open it again (Lesson 89). If your screen still differs from the video, instructor support, an optional plan, lets you ask the instructor in writing under that lesson for two months from the day you switch it on.
What is the difference between Chat and App Skills in Copilot?
Chat talks and App Skills acts. Chat explains, summarises and answers in the panel; App Skills is the agent mode with editing access to your sheet, so it sorts a table, inserts a column or adds a PivotTable, and waits for you to press Apply, with Undo one click away. The Complete Excel Course with AI Integration uses each where it pays: Chat for an executive summary that names the columns behind every point (Lesson 90), App Skills for changes to the workbook itself (Lesson 89).
What makes a good Copilot prompt in Excel?
Three parts, which The Complete Excel Course with AI Integration calls the PRO pattern: the metric, the breakdown and the time frame. 'Show sales performance' gets a vague chart; total revenue by region for a named year gets the exact table, and a follow-up asking which region led returns its name and its total (Lesson 91). The lessons add the habits that sharpen any prompt: name the table and where the result should go, write 'unusually low' when you mean abnormal, and send one request per prompt when a long one comes back half done.
Can Copilot write Excel formulas for me?
Yes, whole columns of them. In The Complete Excel Course with AI Integration, Copilot adds a Profit Margin column with a structured reference and IFERROR, so a zero revenue never breaks it, then Revenue Flag and Low Margin Flag columns that mark rows for review, each previewed before you insert it (Lesson 95). You prove every column on a row you work out yourself, because fast is not the same as correct. Copilot also drafts an ordinary formula while you type, such as a unit cost raised by 20% (Lesson 101).
How does the COPILOT function work?
Type =COPILOT, a prompt in quotes and the cell it should read, and Copilot answers in that cell, row after row down a column. The Complete Excel Course with AI Integration turns a column of state names into their abbreviations this way (Lesson 101), shows a cell reading Busy while Copilot thinks, and walks through joining the Microsoft 365 Insider programme for when the function has not yet reached your Excel.
Can I use Copilot in Excel for free?
You can learn it before you pay for it. Copilot in Excel needs a Microsoft 365 plan that includes Copilot, and The Complete Excel Course with AI Integration advises watching its whole AI section before buying any assistant, so you know what Copilot would do for your work first (Lesson 88). The projects never depend on it: the MarketPulse lessons say outright that no paid AI plan is needed to finish the dashboard (Lesson 106).
What does Copilot get wrong in Excel, and how do I catch it?
It can answer a slightly different question, build one PivotTable when you asked for three, or reply with instructions when you wanted the change made, all in the same sure tone. The Complete Excel Course with AI Integration shows each of these slips on screen with its fix: a sharper prompt, one request at a time, or a restart. Then every result goes through a QA checklist, the data selected, the time frame, each chart's source and every total, so Copilot stays a sharp intern whose drafts you sign off (Lesson 99).
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.
By job
Finance and accounting
- Accountants and finance teams
- Bookkeepers and accounts assistants
- FP&A and budget analysts
- Auditors and fraud examiners
- Payroll administrators
- Tax accountants and advisers
- Banking professionals
- Cost and management accountants
- Financial controllers
- Credit control and receivables teams
- Accounts payable teams
- Financial planners and advisers
- Credit analysts and loan officers
- Insurance underwriters
- Insurance claims handlers
- Reconciliation analysts
- Treasury analysts
- Medical billing and coding specialists
- Fund accountants
- Billing administrators
- AML and KYC analysts
- Actuarial analysts
- Insurance agents and brokers
- Retirement planners
HR and office administration
Operations and supply chain
- Operations and project managers
- Procurement and purchasing officers
- Logistics coordinators
- Inventory controllers and storekeepers
- Supply chain analysts
- Warehouse managers and supervisors
- PMO analysts
- Import and export coordinators
- Production planners
- Demand planners
- Fleet and transport managers
- Apparel merchandisers
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
- Quantity surveyors and estimators
- Civil and site engineers
- Quality managers and engineers
- Construction project managers
- Health and safety officers
- Document controllers
- Production managers and supervisors
- Mechanical and electrical engineers
- Industrial engineers
- Planning engineers
- Sustainability and ESG analysts
- Maintenance planners
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
By goal
- Instructor support
- Certificates
- How long it takes
- Is Excel worth learning
- A retirement calculator
- A budget tracker
- A task tracker
- A KPI dashboard
- A budget vs actual report
- A sales goal tracker
- An employee database
- A chart dashboard
- An employee lookup
- A self-refreshing sales report
- A checking macro
- A Power Automate flow
- A compound interest calculator
- A SIP calculator
- An Excel test for a job
- A step-up SIP calculator
- Practice exercises
- Excel skills for a CV