Easy data analysis with Copilot in Excel

When data stops being helpful and starts being heavy

Most people are comfortable with Excel until the spreadsheet grows up.

A few dozen rows is fine. A few more is manageable. Then suddenly you’re scrolling, filtering, and recalculating, and still not sure what actually changed or why. You might notice a total went up, but not what drove it. Or you see month-to-month movement but can’t tell if it’s meaningful or just normal fluctuation.

The challenge isn’t access to data. It’s knowing where to start.

Copilot in Excel can help by reading the data you already have and surfacing the kinds of insights you’d normally uncover only after a long analysis session.^1,2

Ask Copilot in Excel questions like a human would

Instead of starting with formulas or charts, you can start with curiosity.

Copilot lets you ask plain-language questions about the data you’re already looking at. Open a spreadsheet you already have— like an expense report, a monthly budget, a sales tracker, or a project log. To get started, open your spreadsheet in Excel and click anywhere inside your data table. Then select the Copilot button in the Home tab of the ribbon. A panel will open on the right side of your screen where you can type or ask (via voice chat) your questions in plain language. Ask a question like:

• What changed in this data last month?
• Are any categories increasing faster than others?
• What stands out in this table?

Example:
Say you open a simple expense report with columns like Date, Vendor, Category, and Amount. You could ask:

• Which categories increased the most last month?
• What were my top 10 expenses in January?
• Did any vendor spend spike compared to the prior month?

Copilot can summarize what shifted (and what drove it), so you get a quick read before deciding how deep to go.

Effortlessly track expenses with Excel

Manage your finances with this free expense tracker template

Go to Excel

Use Excel AI insight to turn “interesting” numbers into intel

A spreadsheet can show numbers. Copilot in Excel can help explain what they mean even if you’re not a mathematician or know what a Pivot Table is.

Once Copilot identifies a pattern, you can dig deeper with follow-up questions like:

• Why did spending increase in March?
• Which items contributed most to this change?
• Is this trend consistent or a one-time spike?

Example:
In a sales or income tracker, Copilot might point out that most growth came from one product or client, something that’s easy to miss when you’re focused on totals alone.

This kind of explanation is especially useful when:

• Something looks off, but you can’t tell why
• A trend feels important, but you can’t explain it yet
• You need a quick read before deciding

See the story faster with visuals

Once you understand what’s happening, Copilot in Excel can help you visualize it.

You can ask Copilot to create charts directly from your data, such as:

• Show revenue by month
• Compare spending by category
• Visualize changes over time

Copilot can help generate the chart based on your question, no manual setup required. If the result isn’t quite right, you can refine it by adjusting the timeframe, category, or focus.

Tip: If you’re not sure what kind of chart you need, ask Copilot to summarize the data first. Then turn that insight into a visual.

From Excel data analysis to action

The real value of analysis isn’t understanding everything; it’s knowing what matters most right now.

Copilot can help you move from observation to action by answering questions like:

• What should I investigate further?
• Where am I losing momentum?
• What’s having the biggest impact on results?

Everyday examples:

• A freelancer identifies which clients drive most income
• A budget owner spots a category quietly increasing month over month
• A project lead sees where progress has slowed before deadlines slip

A few ways to get more useful answers

Copilot in Excel works best when the spreadsheet gives it something clear to work with.

A few small habits make a big difference:

• Use clear column headers so the data has meaning, and Copilot can understand what each column is referring to.
• Keep your main data in one clean, formatted table. Copilot works best with structured Excel tables (you can create one by selecting your data and choosing Insert > Table). Unstructured ranges or data scattered across multiple areas can limit the quality of results.
• Ask one question at a time, then build from there.
• Treat the first answer as a starting point, not the final word.

Think of Copilot as an assistant inside Excel—not a replacement for your judgment, but a way to get clarity from your data.

Turn everyday spreadsheets into insight with Microsoft 365

Copilot in Excel doesn’t ask you to change how you work. It works with the spreadsheets you already have to read your data, answer real questions, and help you understand what’s happening without complex formulas or setup.

Try Copilot in Excel with Microsoft 365 and start getting more value from the data you already track.

---