It’s no secret that Excel has been my reliable, if sometimes tedious, partner in data analysis. I was convinced that manual data cleaning and formula building were just part of the job. But after pairing Excel with Copilot, I unlocked the hidden potential in no time.

What used to be a twenty-minute struggle with pivot tables and data formatting became a twenty-second conversation with an AI assistant. I thought Excel was enough to handle my workload, but I was missing the layer of intelligence that turns raw data into actionable insights instantly.

Unlock Copilot in Excel

It’s quite easy

Copilot’s integration in Office apps has been bumpy. I spent the first morning refreshing my ribbon and wondered where my new AI assistant was hiding.

First things first — you don’t need to buy a separate Copilot Pro license anymore if you are on the right plan. Microsoft now bundles Copilot directly into Microsoft 365 Personal and Family plans. If you are already a subscriber, you likely already have access to it.

Even if you have the subscription, your Excel needs to be up to date. I went to File -> Account -> Update Options and clicked Update Now. It took about two minutes, but it’s the only way to make sure the AI brain is actually installed in your local apps.

If you are on a Microsoft 365 Family plan, make sure you are the admin of the group. If you are a member, Copilot won’t appear in your Office apps.

Copilot features in Excel

There are many of them

Once that Copilot icon lit up on my ribbon, I stopped thinking of Excel as a grid of numbers and started treating it like a conversation. Here’s a breakdown of the features that fundamentally changed my workflow.

The biggest hurdle with Excel has always been the syntax. I used to keep a cheat sheet for complex formulas. Now, I just type what I want.

I asked, "Calculate the percentage growth between 2024 and 2024 sales and highlight anything over 15% in green." It didn’t just write the formula; it added the column, named it, and applied the conditional formatting in one go.

Here is where it gets interesting. I can even enable the Agent mode and use prompts to edit the Excel file. Since it’s directly making changes to your file, you need to be careful with text prompts and be patient as Copilot takes its sweet time to read, analyze, and make changes accordingly.

In order to use Agent mode in Copilot, you need to store the spreadsheet in OneDrive. It won’t work with local files.

Most people think Excel is only for numbers. But I often have columns of customer feedback or messy descriptions. I had a sheet with 500 rows of product reviews. I told Copilot to extract the main complaint from these reviews and categorize them into Shipping, Quality, and Pricing.

Excel can even help me with instant data visualization. For example, I can say, ‘Show me a bar chart comparing regional performance,’ and it builds a new sheet in no time.

I love how I can use Copilot to break down complex formulas. I can’t tell you how many times I have received a spreadsheet from a colleague with formulas that are ten levels deep.

Now, I just highlight the cell and ask Copilot, ‘What is this formula doing?’ It breaks it down into plain English.

Boosting my spreadsheets with Copilot

Check it in action

After playing with Copilot in Excel for a while, I decided to throw a messy sales sheet at Copilot to see if it could actually handle the nuance. My data was simple: a list of every laptop sale, who sold it, revenue, profile, region, and more.

Instead of relying on Pivot tables and conditional formatting, I simply asked Copilot to list the stores with the highest profit, and it did the job in no time.

When I asked Copilot to show me sales trends over time, it calculated the overall revenue for each month and presented a clear list for review.

I even went a step further and asked Copilot to create a heatmap showing revenue by salesperson and laptop model. It generated the heatmap, offered an option to add it to a new sheet, and even provided key insights.

Of course, this is just one of the examples of using Copilot in Excel. The possibilities are endless here. It’s entirely up to you to get the best out of Microsoft’s AI assistant in Excel.

You shouldn’t blindly trust Copilot results in Excel. It gave me incorrect results a couple of times. I always advise reviewing it before presenting or sharing it with someone else.

From spreadsheets to solutions

The reality is that Excel hasn’t changed, but the way we interact with it has. I used to think being an Excel expert meant knowing the most formulas. Now, I realize it means knowing how to get to the answer the fastest. Copilot didn’t replace my skills; it unlocked them.

If you have a required Microsoft 365 plan and haven’t tried this integration yet, my advice is simple: stop avoiding and start exploring. Aside from Copilot, you should also start exploring Python integration to fly through tasks.