If your team needs answers from spreadsheets but nobody wants to learn pivot tables or write formulas, AI can close that gap right now – no Excel expertise required. This guide is for non-technical staff: people who work with data every day but aren’t power users. Plain-English questions, useful answers, no formula syntax to memorise.

Most business owners have a spreadsheet full of data sitting on their desktop right now. Sales figures, expense logs, staff hours, client billing records. But that data is not doing anything useful because pulling insights out of Excel has always required you to know formulas, pivot tables, and chart settings that most people never learned. That changes with Microsoft Copilot in Excel. You can now just ask it questions in plain English and get real answers from your data, without touching a single formula.

The Problem With Excel (That Nobody Talks About)

Excel is one of the most powerful business tools ever built. It is also one of the most intimidating. For every person who knows how to write a VLOOKUP or build a pivot table, there are ten more who open a spreadsheet, stare at it for five minutes, and close it again hoping someone else will deal with it.

That gap between “I have data” and “I understand my data” costs businesses real time and real money. Reports get delayed. Decisions get made on gut feel instead of evidence. And the spreadsheets just keep piling up.

Copilot in Excel is designed to close that gap completely.

What Is Copilot in Excel?

Copilot is Microsoft’s AI assistant, and it is built directly into Excel as part of Microsoft 365. Instead of needing to know which function to use, you simply describe what you want to know and Copilot figures out how to get it for you.

Think of it as having an Excel expert sitting next to you at all times. You can ask it questions, request charts, get summaries, and even have it write and explain formulas for you.

What Licence Do You Need?

To use Copilot in Excel, you need a Microsoft 365 Copilot licence. This is an add-on to your existing Microsoft 365 Business subscription. At the time of writing, it is available for Microsoft 365 Business Standard, Business Premium, and enterprise plans. If you are not sure whether your organisation has access, your IT provider can check this for you quickly.

Your data also needs to be formatted as an Excel table (Insert > Table) for Copilot to work with it most effectively. This is a one-time setup step that takes about ten seconds.

What Can You Actually Ask Copilot to Do?

This is where it gets genuinely exciting. Here are some real examples of prompts you can type directly into the Copilot panel inside Excel.

Analysing Sales Data

• “What are my top 5 sales by region?”
• “Which salesperson closed the most deals last quarter?”
• “Show me which products have declining sales over the last three months.”
• “Compare revenue from January to March and highlight the biggest drop.”

Tracking Expenses and Margins

• “Highlight rows where profit margin is below 10%.”
• “Which expense categories are over budget this month?”
• “Show me the average spend per client project.”
• “Flag any invoices that have not been paid within 30 days.”

Managing Staff Hours and Client Billing

• “Which staff members have logged more than 40 hours this week?”
• “Summarise total billable hours by client for this month.”
• “Show me any time entries that are missing a project code.”

These are not hypothetical examples. These are the kinds of questions real businesses need answered every day, and Copilot can handle them in seconds.

Creating Charts Without Any Effort

One of the most practical things Copilot can do is turn your data into a chart instantly. Instead of selecting data ranges, choosing chart types, and adjusting labels manually, you just ask.

Try prompts like these:

• “Create a bar chart showing monthly revenue for the last 12 months.”
• “Show me a pie chart of expenses by category.”
• “Build a line chart comparing this year’s sales to last year’s.”

Copilot will generate the chart, insert it into your spreadsheet, and you can adjust it from there if needed. For most people, the first result is close enough to use straight away.

Python in Excel: A Quick Word on the New Feature

Microsoft has also introduced Python in Excel, which is now available to Microsoft 365 subscribers. You do not need to know how to code to benefit from this. Copilot can write Python scripts inside Excel for you, which unlocks more advanced analysis like forecasting trends, building predictive models, and running statistical summaries on large datasets.

If you have ever wanted your spreadsheet to tell you what is likely to happen next month based on past trends, this is how you do it without hiring a data analyst. You ask Copilot to help you run the analysis, and it handles the technical side.

Understanding Formulas You Did Not Write

One of the most underrated features of Copilot is its ability to explain formulas. If you have ever inherited a spreadsheet from a colleague and had no idea what half the cells were doing, Copilot can now tell you.

Click on a cell with a formula and ask Copilot: “What does this formula do?” or “Explain this formula to me in plain English.” It will break it down step by step so you understand exactly what the calculation is doing and why.

This alone saves hours of frustration for anyone who manages data they did not originally set up.

What Copilot Cannot Do (Be Honest About This)

Copilot is genuinely powerful, but it does have real limitations worth knowing about before you rely on it for critical decisions.

• Large datasets can be slow or unreliable. Copilot works best with clean, well-structured data under a few thousand rows. Very large datasets may produce slower results or require you to break the data into smaller sections.
• Complex financial models need expert review. If your spreadsheet involves multi-layered calculations or linked workbooks, Copilot may not understand the full context. Always have a human review the output before making major business decisions.
• It needs clean data to work well. If your spreadsheet has inconsistent formats, merged cells, or missing values, Copilot will struggle. Cleaning your data first always improves the results significantly.
• It is not a substitute for accounting software. For formal financial reporting, payroll, or tax purposes, always use proper accounting tools and have a qualified professional review outputs.

Real Business Use Cases

Here is how businesses like yours are already using Copilot in Excel to save time and make better decisions.

Sales teams are using it to identify which products are performing and which are not, without waiting for a weekly report from a manager. They ask Copilot directly and get the answer in under a minute.

Operations managers are using it to track staff hours across projects and flag where time is being spent versus where it should be, giving them a clear picture without manual calculations.

Finance teams are using it to highlight expense anomalies, summarise monthly spending by department, and prepare data for board presentations in a fraction of the usual time.

Business owners are using it to finally understand their own data, instead of relying on someone else to interpret it for them. That independence is worth a great deal.

Frequently Asked Questions

Do I need to know Excel to use Copilot?

No. That is exactly the point of this feature. Copilot is designed for people who have data but do not know how to work with it. If you can describe what you want to know in plain English, Copilot can find the answer in your spreadsheet. You do not need to learn any formulas or Excel features to get started.

Is my data safe when I use Copilot?

Copilot in Microsoft 365 is governed by Microsoft’s enterprise data privacy commitments. Your data is not used to train AI models, and it stays within your Microsoft 365 tenant. For businesses handling sensitive client or financial data, this is an important distinction from consumer AI tools.

Can Copilot work with my existing spreadsheets?

Yes, in most cases. The main requirement is that your data is formatted as an Excel table. If it is not already, Copilot will often prompt you to convert it. Most standard business spreadsheets can be converted in seconds.

How much does the Microsoft 365 Copilot licence cost?

Pricing changes regularly, so we recommend contacting your IT provider or Microsoft directly for current pricing. It is an add-on to your existing Microsoft 365 subscription and is available per user per month.

Ready to Stop Guessing and Start Knowing?

Copilot in Excel is not just a productivity tool. It is a genuine shift in how businesses can work with their own data. If you have been putting off making sense of your spreadsheets because it felt too hard, that barrier no longer exists.

At Otto IT, we help professional services businesses get the most out of Microsoft 365, including setting up Copilot licences, training your team, and making sure your data is set up to give you real insights.

If you want to find out whether Copilot is right for your business, get in touch with our team or book a free consultation here. We will walk you through what is possible and how to get started.