New to Microsoft 365 Copilot? Our hands-on Microsoft 365 Copilot classroom training covers everything in this guide — WSQ-funded and SkillsFuture-claimable for Singapore professionals.
To use Copilot in Excel, open the Copilot pane from the Home tab on the ribbon, make sure your data is formatted as an Excel Table, then type a plain-English prompt — for example, “summarise this sheet” or “create a pivot table from columns A to D” — and click Apply or Insert. If you want Copilot to make changes directly to the sheet rather than just suggest them, switch on Agent Mode from the Tools icon under the prompt box.
I’ve been training Excel in Singapore for 24 years. The room I walk into now is different from the one I walked into even a year ago. People still want pivot tables and VLOOKUP. But the first question almost everyone asks me these days is some version of, “How do I get Copilot to actually do something useful?” The honest answer is that it’s not hard — once you know where the button is, what Agent Mode changes, and which licence you actually have. This guide covers all three, plus the new COPILOT() function, fifteen prompts you can copy and paste, and what to do when the Copilot button is missing. That last one is the single most common question in any Excel-Copilot session I run.
Copilot in Excel is the AI assistant Microsoft has built into Excel itself. It reads the data already in your worksheet and acts on it: writing formulas, building pivot tables, surfacing trends, applying conditional formatting, drafting summaries, and — when you let it — making changes directly to your sheet. There is nothing to install. Copilot is not an add-in and it is not a separate application. Think of it less like a new tool you bolt on to Excel, and more like a colleague who has been quietly given a chair next to you, can see your screen, and is willing to do the boring parts.
What Copilot in Excel does breaks into four buckets — the same four Microsoft uses in its own product documentation:
One important distinction: Copilot in Excel is not the same product as Microsoft 365 Copilot Chat, which is the free chatbot in the Microsoft 365 web app. Copilot Chat does not see your spreadsheet. Copilot in Excel does. That distinction is what makes the licensing section below worth reading carefully, especially in Singapore where most companies are on a plan that does not actually include it.
Copilot in Excel is gated by two things: the version of Excel you are running, and the Copilot licence assigned to your Microsoft 365 account. If either is missing, the Copilot button does not appear, and no amount of clicking helps. Get both right and the rest of this guide is sitting in front of you.
Step by step:
A note for Singapore readers. The single biggest confusion in our corporate training rooms is the Business Standard versus Copilot question. Microsoft 365 Business Standard — the plan most SG SMEs are on — includes Word, Excel, PowerPoint, Outlook, Teams, and OneDrive. It does not include Copilot in Excel. To get Copilot working for an SG team on Business Standard, the company has to add the separate Microsoft 365 Copilot Business licence per user. Some Copilot training in Singapore can be claimed under SkillsFuture if it is delivered through an approved provider (Intellisoft’s classroom Copilot course is one such option), but the Microsoft software licence is a separate purchase that has to come from your company’s IT budget. Two separate cheques. Don’t promise your boss otherwise.
Once the licence is in place and you have signed in, Copilot shows up in two places. Most beginners only ever notice the first one.
The Copilot sidebar is the main entry point. Click the Copilot icon on the right side of the Home ribbon, and a pane slides in from the edge of the workbook. The pane has a chat-style prompt box at the bottom, a list of suggested prompts above it, and the conversation history above that. Anything you ask Copilot — write a formula, summarise the sheet, build a pivot — happens through this pane.
The per-cell Copilot sparkle is the second entry point. Select a single cell, and a small sparkle icon appears at the corner of the cell. Click the sparkle, and a context-aware version of Copilot opens. Its suggestions are scoped to the cell you selected and the data immediately around it. The sparkle is convenient for narrow, in-line actions: explain this formula, fill this column down based on the pattern, format this range. For anything that spans the whole sheet, the sidebar is the better choice.
Both entry points talk to the same Copilot engine. The difference is only the scope and the speed of getting started.
One pre-requisite is worth pinning down before you go further. Copilot only reads data that is structured. The fastest way to give it structure is to convert your range to an Excel Table. Click any cell inside your data, press Ctrl+T, confirm “My table has headers”, and click OK. The data is now a Table with named columns, and Copilot’s accuracy on every prompt jumps immediately. If you skip this step, Copilot still tries — but it guesses at the column boundaries, and it is often wrong about which row is your header. Think of it like sending a colleague a print-out with no headings on the columns and asking them to fix it. They can try. They will get half of it wrong. Give them headings first. (If you are new to Tables, our walk-through on creating pivot tables in Excel covers the Ctrl+T step in detail.)
This is the distinction most articles about Copilot in Excel skip. It matters more than the licensing question because it changes what Copilot is actually allowed to do.
In Default Mode, Copilot suggests. You ask for a pivot table; Copilot proposes one in the sidebar with an Apply button. You ask for a formula; Copilot writes the formula in the sidebar with an Insert Column button. Nothing changes in your worksheet until you click. This is the safe mode. Every Copilot action is a review step before it lands in the data.
In Agent Mode, Copilot acts. You ask for a pivot table; Copilot builds it on a new sheet, on its own. You ask it to clean up the data; Copilot edits cells in place. You ask for conditional formatting; the colours appear. The review step is gone. Copilot edits the workbook directly, and you press Ctrl+Z if you do not like the result.
I once watched a finance manager flick to Agent Mode in the first ten minutes of class, type “fix this sheet”, and then sit back in her chair with a small smile as Copilot rebuilt three of her columns. She had been waiting twenty minutes for it to do something useful in Default Mode. The Apply-Apply-Apply rhythm had become a kind of nervous tic. The moment she let it act, she looked at me and said: “Oh. So that’s the point.” That’s the point. Agent Mode is what makes Copilot feel like a colleague rather than a polite suggestion box.
How to switch. Open the Copilot pane. Below the prompt box, click the Tools icon — it has two small horizontal slider bars stacked together — and pick Agent mode. The pane shows a small indicator that Agent mode is on. To switch back, open the same menu and select Default mode.
When to stay in Default Mode. Audited finance work. Anything where a colleague will look at the workbook later and ask “who wrote that formula?”. Anything in a regulated environment where a change log matters. Reports going to a board or a regulator. The Apply step is your audit trail.
When to use Agent Mode. Data cleanup on a sheet someone else gave you. Exploratory analysis where you do not yet know what you are looking for. Building a dashboard from raw data for the first time. Any task where the cost of an unwanted edit is “press Ctrl+Z” and the benefit is twenty fewer clicks. Agent Mode is also the only mode in which most of the more interesting Copilot tactics — clean up the spreadsheet, create new columns, build pivots in-place — actually do anything visible.
A practical pattern I teach in class: switch to Agent Mode, get the result you want, then switch back to Default Mode before sharing the workbook with anyone else. That way the next person who opens the file with a Copilot prompt does not accidentally edit it.
If you want to go further than Copilot’s agent mode and build no-code AI agents that act across multiple Microsoft 365 apps, our Create Agentic AI Automations Without Coding course covers the full agent-builder workflow. Agent Mode in Excel is the first taste. Full agentic AI is the next step.
The COPILOT() function is the newest piece of Copilot in Excel, and the one most competitor articles still do not cover because it shipped after they were published. It is also the piece that changes Excel the most.
The COPILOT() function lets you put an AI prompt into a cell, the same way you put SUM() or VLOOKUP() into a cell. The result of the prompt becomes the cell’s value. Change the inputs, and the cell recalculates. It is Copilot expressed as a formula. If SUM() is a calculator that lives inside a cell, COPILOT() is a junior analyst who lives inside a cell.
Syntax:
=COPILOT("Your prompt here", range_or_value)The first argument is a text prompt in quotes — what you want Copilot to do. The second argument is the cell or range you want it to operate on. You can chain multiple inputs by separating them with commas, the same as any other Excel function.
Worked example. Suppose column B has 200 rows of free-text expense descriptions (Lunch with client at Asia Square, Grab to client meeting, Office snacks Cold Storage) and you want a category in column C. In cell C2, type:
=COPILOT("Categorise this expense as Travel, Food, Office or Other", B2)Press Enter. Then drag the formula down or copy it to the rest of the column. Each cell in column C now contains Copilot’s classification of the matching cell in column B. Change a description in B, and the category in C recalculates. How good is that? A task that used to take someone an afternoon now takes the time to type one formula. (If your finance team works mostly in lookups today, the same logic plugs into a VLOOKUP and XLOOKUP workflow — COPILOT() complements, it does not replace.)
How it differs from the sidebar. The sidebar gives you a one-off answer in chat form. The COPILOT() function gives you values into cells like any formula, and those values are part of your data going forward — referenced by other formulas, included in pivots, included in charts, exported with the workbook. If you want the AI’s answer to live inside the spreadsheet as data, the COPILOT() function is the move. If you want the AI’s answer as a conversation, the sidebar is the move.
Limitations to know. Each cell that uses COPILOT() costs a token call to the Copilot back-end, so a 10,000-row column of COPILOT() formulas takes time to recalculate and can hit per-tenant rate limits. The function is not perfectly deterministic — running the same formula twice can return slightly different wording on free-text outputs, though categorical outputs (like the expense example above) are usually stable. And the function is rolling out gradually. If you do not see it, your tenant may not yet have it enabled even if you have a Copilot licence.
The most common reason teams adopt Copilot in Excel is the analysis workflow — feeding it a sheet of raw data and asking what is going on. There are four moves that cover most of what you will want, and they all live in the sidebar.
1. Summarise the sheet. Open the Copilot pane and type “Summarise this sheet.” Copilot returns a short paragraph plus a bullet list — what the data appears to be about, how many rows, what columns it contains, and any obvious patterns. This is the fastest way to orient yourself in a workbook someone else built. Managers can be quite demanding. They want to know what a sheet is about before lunch, not after. In Agent Mode you can ask Copilot to put the summary on a new sheet so it is saved with the workbook.
2. Find trends and outliers. Type “What trends and outliers do you see in this data?” Copilot returns a list of observations — column X is increasing over time, row 47 has an unusual value in column Y, the distribution of column Z is skewed. This is the move that catches data-entry errors and surprises in routine reports.
3. Generate a pivot table. Type “Create a pivot table that shows total sales by region and month.” In Agent Mode, Copilot builds the pivot on a new sheet. In Default Mode, Copilot proposes the pivot in the pane with an Insert button. Either way, the pivot is a real Excel pivot — fully editable, with Slicers and Timelines available the same as any pivot you built by hand.
4. Generate a chart. Type “Create a bar chart of revenue by quarter for 2025.” Copilot builds the chart, picks an appropriate type, and asks whether to place it on the current sheet or a new one. Charts from Copilot are real Excel charts, not images. You can edit the colours, axes, and labels with the standard chart tools.
A small but important habit: Copilot’s accuracy on all four of these depends on your column headers. “Sales” is fine. “S_2025_FINAL_v3” is not. Rename your columns to plain English before you ask Copilot to analyse them, and the answers improve immediately. After 24 years of training, I see one pattern repeatedly — the spreadsheets that confuse Copilot are the same ones that confuse a human colleague opening the file for the first time. Fix it for the human, and Copilot is fixed too. For teams ready to go deeper on the analysis side, the Advanced Data Analytics & Visualization with Excel course pairs naturally with Copilot — Copilot speeds up the analysis Excel can already do.
These are written so you can paste them straight into the Copilot pane and edit the column names. They are grouped by what the prompt does, not by who is asking — the same prompt is useful to a finance analyst and to an HR manager.
Clean-up prompts
Formula prompts
Analysis prompts
Formatting prompts
Summary and reporting prompts
A pattern worth noticing across the fifteen: each prompt names the exact column or range it operates on, and each prompt names the format of the output (the chart type, the colour scale, the date threshold, the number of bullet points). Copilot returns better answers when the prompt is specific. “Clean this up” gets a generic answer. “Trim leading and trailing spaces in column B and convert column C to title case” gets the right answer the first time. The skill is not in knowing AI. The skill is in writing instructions a junior colleague could follow.
The honest answer: partly yes, mostly no.
What is free. Microsoft 365 Copilot Chat — the chatbot that lives at copilot.microsoft.com and inside the Microsoft 365 web app — is free with any Microsoft account. You can ask it questions, paste data into the chat, and have it write formulas or analyse small datasets for you. That use is genuinely free.
What is not free. Copilot inside Excel — the Copilot pane in the worksheet, Agent Mode, the COPILOT() function, the per-cell sparkle — requires a paid Copilot licence. There is no free tier of Copilot in Excel itself. Pasting a hundred rows into Copilot Chat is a workaround for individuals, but it is not the same product, and it does not scale to actual spreadsheet work.
The trial routes. Microsoft 365 Personal ($10 per month, includes Copilot) offers a one-month free trial. Microsoft 365 Copilot Business and Copilot Enterprise both offer a one-month free trial for the first seat. Both are real ways to try the full Copilot-in-Excel experience without committing.
The reason this question gets asked so often is that the phrase “Copilot in Excel” is used in two different ways online — sometimes meaning the chatbot that can talk about Excel, sometimes meaning the pane that lives inside Excel. They are not the same thing. Only the second one requires a paid licence.
This is the single most-asked question in any actual Copilot training session — I have a Copilot licence, why don’t I see the button? Six things to check, in the order they usually solve the problem.
1. Confirm a Copilot licence is assigned in the Microsoft Admin Centre. In larger organisations, the company has bought Copilot licences but IT has not assigned one to your user account yet. Have your IT admin open the Microsoft 365 Admin Centre, find your user, and verify a Microsoft 365 Copilot or Microsoft 365 Copilot Business licence is ticked. This is the cause about 60% of the time in classroom rooms I run.
2. Sign out and sign back in to Excel. Licence changes do not always pick up live. Close Excel completely, sign out of your Microsoft account, sign back in, then reopen Excel. The Copilot icon often appears immediately after this. Extremely easy fix, often the right one.
3. Update Excel to the Current Channel build. Copilot in Excel requires a recent build (post 2024 for the sidebar; later for Agent Mode and the COPILOT() function). File > Account > Update Options > Update Now. If your IT department has locked Excel to the Semi-Annual Enterprise Channel, you may be on a build that simply does not have Copilot yet — that is a conversation with IT, not a setting you can change yourself.
4. Check the per-tenant Copilot rollout setting. Microsoft rolls Copilot features out gradually in different regions. Even with a licence and a current build, your tenant administrator can choose to delay or stage the rollout. The relevant setting lives in the Microsoft 365 Admin Centre under Copilot > Settings. If your admin has paused rollout, the button is genuinely not yet available. There is no client-side fix.
5. Check per-user Copilot enablement. Some organisations enable Copilot for the tenant but require an explicit opt-in per user (sometimes via a Self-Service portal, sometimes by raising a ticket). Ask IT whether your account is in the Copilot-enabled group.
6. For Mac users — confirm your build. Copilot in Excel for Mac shipped later than the Windows version, and the COPILOT() function is rolling out behind that. Excel > About Excel will show your build number. As of mid-2026, Copilot is widely available on Mac, but the COPILOT() function may still be unavailable on some build channels. Check the Microsoft release notes for the current state.
If the COPILOT() function specifically is unavailable but the sidebar is working, you are almost certainly hitting issue 4 (per-tenant rollout). The function has rolled out behind the sidebar across most tenants.
Copilot in Excel is the most concrete, most reviewable AI assistant a Microsoft 365 team is likely to use. Unlike a general chatbot, it operates on real data the team already trusts, returns answers in formats the team already reads (pivots, charts, formulas), and leaves a workbook anyone can audit. That is why it is the first AI tool most Singapore corporate training requests now ask about. Get the licensing, the Agent Mode toggle, and the COPILOT() function right and you have learned the load-bearing 80%. The other 20% is just practice.
For teams that want a structured introduction across the whole Microsoft 365 + Copilot stack — Word, Excel, PowerPoint and Outlook in one day, with hands-on exercises in a real classroom — Intellisoft’s Copilot in Microsoft 365 Office course is the WSQ-funded, SkillsFuture-claimable path. Over 24 years we have trained 48,000+ working professionals across 12,600+ companies in Singapore, and Copilot is the topic that has changed corporate training requests more in the last twelve months than the previous twelve years combined. For broader AI-at-work framing across the rest of the toolkit, the Digital Transformation with AI Tools course is the next step up.
I hope you’ll find this useful. Open Excel today, find the Copilot icon (or the troubleshooting section above if you can’t), and try three of the fifteen prompts on a real sheet you have to deal with this week. The fastest way to learn Copilot is to ask it to do something you already know how to do, watch what it does, and adjust your next prompt from there. Do try it out.
Copilot in Excel is built in, not an add-in. There is nothing to install from the Office Add-ins store. If your Microsoft 365 licence includes Copilot and you are on a current build of Excel, the Copilot icon appears on the Home tab on its own. If you cannot find a Copilot icon in the Add-ins gallery, that is expected — Copilot is not delivered as an add-in. It is delivered as part of Microsoft 365 itself. The confusion is understandable. For two decades every new Excel feature came as an add-in. Copilot does not.
No separate download is required. Copilot in Excel is part of the Microsoft 365 Apps and ships with Excel on every supported build. What you do need is a current build of Excel. Older builds, including the perpetual Excel 2019 and Excel 2021 licences, do not include Copilot at all, and no download will add it. To update, go to File > Account > Update Options > Update Now inside Excel. If the option is greyed out, your IT department controls updates centrally — speak to them.
Yes. Copilot in Excel for Mac is available, but it shipped later than the Windows version, and not every feature reaches the Mac build at the same time. The Copilot sidebar is widely available on Mac as of mid-2026. Agent Mode and the COPILOT() function rolled out to Mac builds behind the Windows release. Check your Mac Excel build under Excel > About Excel, and confirm against Microsoft’s published release notes if a specific feature is missing. The Mac version is real. It is just on a slightly slower release cadence.
The four common reasons, in order of likelihood: (1) your account does not have a Copilot licence assigned in the Microsoft Admin Centre — ask IT to check; (2) your Excel build is out of date — go to File > Account > Update Options > Update Now; (3) your organisation is on a delayed Copilot rollout schedule set by your tenant administrator; (4) you are signed into Excel with a personal account that has no Copilot licence, while your Copilot licence is on a work account. The troubleshooting section above walks through all six checks in order.
Mostly no. Microsoft 365 Copilot Chat (the chatbot at copilot.microsoft.com and inside the Microsoft 365 web app) is free, but it cannot read or edit your spreadsheet. It can only talk about it. Copilot inside Excel — the pane in the worksheet, Agent Mode, the COPILOT() function — requires a paid Copilot licence: Microsoft 365 Personal at $10 per month (Copilot included), Microsoft 365 Copilot Business at $21 per user per month, or Microsoft 365 Copilot Enterprise at $30 per user per month. All three offer a one-month free trial.
The Copilot sidebar is a chat. You ask a question, Copilot replies in the pane, and you choose whether to apply the result. The COPILOT() function is a formula. You put =COPILOT("prompt", range) into a cell and the result becomes the cell’s value, recalculating when the inputs change. Use the sidebar for one-off questions and exploratory analysis. Use the COPILOT() function when you want the AI’s answer to live inside the spreadsheet as data that other formulas, pivots and charts can reference. Sidebar is for talking. COPILOT() is for storing.
Ready to put this into practice? Join Intellisoft’s classroom Copilot training in Singapore — WSQ-funded, SkillsFuture-claimable, and built around real exercises in Excel, not slideware.
How to Use Copilot in Word: A Step-by-Step Guide (with Real Prompts) To use Copilot…
How to Create a Pivot Table in Excel (Step-by-Step Guide) To use an Excel pivot…
How to Use Copilot in PowerPoint (Step-by-Step Guide with Prompts That Work) TL;DR: To use…
After 24 years of training in Singapore, I can tell you the truth about Excel…
TL;DR: To use Excel lookup functions, pick VLOOKUP for compatibility with older Excel (2019 and…
How to Use Copilot in Outlook in 2026: A Practical Walkthrough To use Copilot in…