5 practical ways to use Copilot in Excel

1) Clean up messy business data in minutes

Before spreadsheets can help you make decisions, the data has to be usable. That’s often where small businesses get stuck, especially when data comes from multiple systems or people.

Copilot in Excel^1,2 can help automate common data cleanup tasks that usually take far too long.

Where this helps most:
Customer and vendor lists, CRM exports, expense logs, sales reports, or any spreadsheet pulled from another tool.

With Copilot, you can:

• Remove duplicate customer or vendor records
• Standardize inconsistent entries (dates, names, categories)
• Identify missing or incorrect values

Prompts to try:

• “Find duplicate customer names and remove them.”
• “Fix inconsistent date formats in this column.”
• “Identify rows with missing or incorrect values.”

Helpful hint:
Start by making the sheet easier to scan: clean headers, consistent formats, and a clear table layout help Copilot interpret your data. If you need a quick refresh, use these Excel formatting tips and tricks.

Turn data into insights with Excel

Make better decisions backed by data and insights

Learn more

2) Turn raw numbers into clear business insights

Once your data is clean, Copilot in Excel^1,2 can help you understand what’s actually happening, without building complex formulas or dashboards.

This is especially useful for quick performance check-ins, like reviewing monthly results or comparing time periods.

Great for everyday questions like:

• Are revenue and expenses trending up or down?
• Which products, services, or marketing channels are driving growth?
• What changed the most compared to last quarter?
• Are any seasonal patterns starting to appear?

Prompts to try:

• “Summarize total sales by month and call out the highest and lowest months.”
• “Compare this quarter to last quarter and explain the biggest differences.”
• “Break revenue down by product/service and show what’s growing fastest.”
• “Identify any trends in expenses by category over the last 6 months.”

Refinement tip:
If Copilot’s answer feels too broad, tighten the scope: “Use only the last 60 days,” “Focus on top 10 customers,” or “Exclude refunds.”

3) Understand why numbers changed, not just that they did

Seeing that numbers changed is easy. Understanding why they changed is where most small business owners lose time.

Copilot in Excel^1,2 can help connect the dots by surfacing patterns, comparisons, and anomalies that explain shifts in your data.

This is especially helpful when reviewing:

• Sales dips or spikes
• Expense overruns
• Margin changes
• Inventory or demand fluctuations

Prompts to try:

• “Explain the biggest changes and what likely caused them.”
• “What would you investigate first if this were your business?”
• “Which changes look like one-time issues versus ongoing trends?”

Pro tip:
Follow up with “What evidence in the data supports that?” to keep insights grounded in the numbers.

4) Create charts and visuals automatically

Charts are one of the most useful tools in Excel. Copilot can help generate visuals directly from your data.

This works well for internal reviews, reports, or presentations when you want insights at a glance.

With Copilot in Excel^1,2, you can:

• Let Excel choose an appropriate chart type
• Highlight key takeaways visually

Prompts to try:

• “Create a chart showing revenue trends over time.”
• “Visualize expenses by category.”
• “Highlight the biggest changes in this data.”

5) Organize and plan with smarter data analysis in Excel

Excel often doubles as a planning tool used for budgets, forecasts, project tracking, or inventory management. Copilot^1,2 can help make those spreadsheets more actionable.

Where this helps most:
Cash flow planning, tracking ongoing work, or keeping an eye on areas that could become problems.

Prompts to try:

• “Create a simple cash flow forecast based on this data.”
• “Flag rows where expenses exceed budget.”
• “Which months look most at risk?”

Good to know:
Treat forecasts as planning tools, not predictions. Copilot^1,2 can help surface patterns, but your judgment still matters.

Tips for getting better answers from Excel for small businesses

Want better output from Copilot? Set it up for success.

• Use clear column headers. “Expense” beats “Stuff” every time.
• Keep one clean table. Move notes and totals outside the dataset.
• Ask follow-up questions. “Why?” “Show examples.” “What’s driving that?”
• Be specific. Add limits like “last 90 days” or “top 10 customers.”
• Treat Copilot as a starting point. Always do a quick human review.

Bottom line: the clearer your spreadsheet and your prompt, the faster Copilot can help to deliver insights you can actually use.

AI in Excel is becoming a big win for small businesses

For small businesses, speed matters. Copilot in Excel^1,2 can support data cleanup, help surface patterns, and assist in creating visuals without requiring advanced formulas, offering a helpful starting point for moving from numbers toward insights.

Try Microsoft 365 to use Copilot in Excel^1,2 on a real spreadsheet (like your expenses, sales tracker, or customer list) and see how it can turn messy rows into clear next steps.

---