How to use copilot in excel
Copilot in Excel is an AI assistant built directly into Microsoft Excel that lets you analyse data, write formulas, build charts, create pivot tables, and clean up spreadsheets using plain English instructions instead of manual commands. It works inside Excel for Microsoft 365 on desktop, web, and iPad, and requires a qualifying Microsoft 365 Copilot subscription. You access it from the Copilot icon on the Home tab of the ribbon, which opens a side panel where you can type questions, request formulas, or ask Copilot to edit your workbook step by step.
Now, with the definition out of the way, let me ask you something honest. How many hours have you wasted in Excel trying to remember whether it was VLOOKUP or XLOOKUP? Or staring at a column of numbers wondering which chart makes sense? If you have felt this way, you are not alone. Excel has been the silent boss of offices for almost forty years, and most of us have just learned to deal with the pain.
But things are changing. Microsoft has been putting this AI assistant right inside Excel, and it is genuinely useful. Not in a hyped-up “this will replace you” way. More in a “wait, it just wrote that formula for me?” way. Once you start using Copilot, going back to plain Excel feels like going back to dial-up internet.
In this guide, I will walk you through how Copilot in Excel works, how to switch it on, and how to use it.
Why Copilot in Excel Is a Big Deal
Think of Copilot as a colleague sitting next to you who happens to know every Excel formula ever invented. The big shift here is that you no longer need to memorise function names. You can just say something like, “Show me total sales by region for last quarter” or “Highlight the rows where profit dropped below zero.” Copilot reads your data and does the work.
For people learning data analytics, this is a quiet game changer. It does not replace your skills. It accelerates them. You still need to understand what a pivot table is and why you would use one. But you save the hour you would have spent fighting with the interface.
Before You Start: What You Actually Need
Here is the part nobody tells you upfront. Copilot is not free, and it is not included in every Microsoft 365 plan. This trips up almost everyone the first time.
To use Copilot in Excel, you generally need a Microsoft 365 Personal or Family subscription with the Copilot add-on, or a Microsoft 365 Premium plan. For work or school accounts, you need the Microsoft 365 Copilot add-on license assigned by your IT admin.
You also need to be online. Copilot runs on Microsoft’s servers, so a stable connection is non-negotiable. Your Excel must be up to date. If you are still on Office 2019, this will not work. The web version of Excel works fine if you are a subscriber.
If your organisation is on the Semi-Annual Enterprise Channel, Copilot will not show up. Ask IT to switch you to Current Channel or Monthly Enterprise Channel. Or just use the web version while you wait.
How to Enable Copilot in Excel: The Steps
Now to the practical part. If you have the right subscription, Copilot should appear automatically. But in real life, this is often not the case. Here is what to do.
Step one : Open Excel on your desktop or on the web at excel.cloud.microsoft.
Step two : Look at the Home tab on the ribbon at the very top. On the right side, you should see a Copilot icon. It looks like a small sparkle. If you see it, click it and the Copilot panel will slide in from the right.
Step three : If you do not see the Copilot icon, do not panic. The most common fix is to refresh your license. Go to File, then Account, and click Update License. Sometimes you need to click it twice. Then sign in again with the Microsoft account that has your Copilot subscription attached.
Step four : Close every Excel window you have open. Then open Excel again. The Copilot icon should now sit in the Home tab.
If it is still missing, the issue is usually one of three things. Either your subscription does not include Copilot, you are signed in with a personal account when your Copilot license is on a work account, or your Office installation needs an update. Go to File, Account, and click Update Options to install the latest version.
This whole process of how to enable Copilot in Excel takes about five minutes when things go smoothly. When they do not, expect twenty minutes and some swearing.
How to Use Copilot in Excel for Real Work
Once Copilot is enabled, the trick to using it well is starting small.
First, make sure your data is in a proper table. Copilot works best when your data is structured. Select your range, press Ctrl plus T, and confirm that your data has headers. This single step prevents about half the problems beginners run into.
Now click the Copilot icon. A side panel opens with suggestion chips like “Show data insights” or “Suggest formula columns.” You can click these, or type your own question.
Here are a few prompts you can use right now.
For a quick summary, type “Give me a summary of this data and highlight any unusual trends.” Copilot scans the sheet and tells you what stands out.
For a formula, type something like “Add a column that calculates the profit margin as a percentage.” Copilot writes the formula and offers to insert it.
For a chart, try “Create a bar chart showing total sales by month.” Copilot generates it and lets you tweak the styling.
For messy data, type “Find duplicate rows and highlight them.” Or “Sort this table by revenue, highest first.”
The Copilot function inside cells is another one worth knowing. You can type =COPILOT(“classify sentiment”, A2:A50) directly into a cell, and it will return AI-generated results right in the grid. Useful for tagging feedback, summarising text columns, or creating sample data.
There is also an editing mode that lets Copilot make multi-step changes for you. You can ask it to reshape data, merge sheets, or build a full report. It shows you a plan first, you approve it, and then it runs.
Where Most Beginners Slip Up
A few honest warnings.
Copilot is helpful, but not perfect. Sometimes it misreads column names or makes assumptions about what you meant. Always check the formula or chart before you trust it in a real report. Treat it like a fast junior analyst, not an infallible expert.
Also, Copilot will not work on workbooks marked as Highly Confidential. There are limits on how many AI calls you can make in a given window. And results can change slightly each time you ask. If you need stable numbers, copy the result and paste it as a value.
Why This Matters If You Are Learning Data Analytics
Here is the part I want every fresher in Kerala to hear. Companies are not hiring for “knows Excel” anymore. They are hiring for “can find insights fast.” Copilot does not remove the need to understand data. It raises the bar on what you are expected to deliver.
If you can explain what a pivot table is, why a particular formula is right, and how to read what Copilot gives you, you become genuinely valuable. The tools are getting faster. The thinking is what earns the salary.
This is why our Data Analytics course at Edure is built around real datasets and real client-style problems. We cover Excel, Power BI, SQL, Python, and AI tools like Copilot, because that is the stack you will use in your first job.
If you want to stop watching tutorials and start building skills that get you placed, check out our Data Analytics programme. Weekend and weekday batches, in Trivandrum and Kochi. Walk in for a free demo and see what your first month would look like.
Excel is not going away. The way we use Excel is changing fast. The sooner you work alongside Copilot, the sooner you stand out.
