Copilot for Excel can help you complete spreadsheet tasks using everyday language, so you spend less time managing cells and more time making decisions. Whether you are preparing a sales report, tracking expenses, reviewing business performance or building a budget, Copilot can help generate formulas, identify trends, create charts and analyze spreadsheet data.
In this guide, you will learn how to use Copilot in Excel, explore seven practical prompts, and follow a real-world business example. You will also understand its limitations and what to check before relying on AI-generated results.
Discover how Copilot can simplify spreadsheet tasks, improve reporting and help you make more informed business decisions.
What is Copilot for Excel?
Copilot for Excel is Microsoft’s AI assistant for working with spreadsheets. It allows you to describe a task in natural language and use supported Copilot features to analyse, create or modify workbook content.
Depending on your licence, application and available features, Copilot can help you:
- Generate and explain Excel formulas.
- Summarise large datasets and identify trends.
- Create charts and PivotTables.
- Sort, filter and format data.
- Highlight unusual values and potential inconsistencies.
- Build or update worksheets and reporting templates.
- Explore questions about your data without manually constructing every analysis.
For example, instead of manually creating a formula to calculate monthly sales growth, you could ask Copilot to calculate the percentage change between months and explain the formula it uses.
Copilot can make spreadsheet work more accessible, but its results still need to be checked. It is an assistant, not a replacement for understanding your data.
How to use Copilot in Excel
The exact interface depends on your account, Excel version and available Copilot features. The following steps describe a general workflow.
Step 1: Open Excel and check Copilot access
Open your workbook in a supported version of Excel and sign in with the relevant Microsoft account. Look for the Copilot icon or option in the application.
If Copilot is missing, check your subscription, application version, account type and organisation settings. Different subscriptions provide different levels of access.
Step 2: Prepare your spreadsheet
Copilot works best when your data is organised and understandable.
Before asking a question:
- Give columns clear headings, such as Date, Product, Revenue and Region.
- Keep each row focused on one record where possible.
- Check that dates and numbers use consistent formats.
- Remove unnecessary blank rows and investigate duplicate records.
- Use an appropriate Excel table or supported data range.
For example, a sales dataset with clear column headings is easier to analyse than a worksheet containing merged cells, inconsistent labels and unexplained totals.
Step 3: Ask Copilot a specific question
Describe the task, the relevant data and the result you want.
Instead of asking, “Analyse this spreadsheet”, try:
Example prompt:
Analyse the sales data in this workbook. Identify the
three products with the highest total revenue, compare
monthly performance and highlight any unusual changes.
Explain the findings in plain English and show the
relevant figures.
A specific request gives Copilot a clearer objective and makes its response easier to evaluate.
Step 4: Review the result
Depending on the available mode, Copilot may provide an explanation, suggest a plan or make changes directly in your workbook.
Review the proposed formulas, calculations, charts and formatting. If the result is not quite right, refine your instruction.
Example prompt:
Recalculate the monthly growth rate using the previous
month’s revenue as the comparison. Show the formula and
flag any months where the previous month’s value is zero
or missing.
Step 5: Verify before using the data
Check the result against the source data, particularly when preparing financial reports, budgets, forecasts or management dashboards.
Make sure the formula references the correct cells, the totals reconcile and the chart communicates the right message. Save a version of the workbook before making substantial AI-assisted changes.
7 useful Copilot for Excel prompts
These prompts address common spreadsheet tasks. Replace the sample instructions with your own data and business requirements.
1. Generate an Excel formula
Best for: Calculations that would otherwise require writing and debugging a formula manually.
Prompt:
Create an Excel formula that calculates the percentage
change between the current month’s revenue in cell C2
and the previous month’s revenue in cell B2. Handle a
zero or blank previous-month value appropriately and
explain how the formula works.
Why it helps: You get a starting formula and an explanation, which makes it easier to understand and verify the calculation.
Always check that the formula uses the correct cell references and handles exceptional values in the way your business expects.
2. Analyse sales performance
Best for: Finding patterns in sales reports.
Prompt:
Analyse this sales table by product, region and month.
Identify the top five products by total revenue, compare
regional performance and highlight the largest month-on-month
changes. Show the supporting figures and distinguish
observations from possible explanations.
Why it helps: It focuses the analysis on specific business questions instead of generating a broad summary with little practical value.
3. Find unusual values or inconsistencies
Best for: Reviewing data before sharing a report.
Prompt:
Check this dataset for missing values, duplicate records,
inconsistent category names and unusual figures. Report
the affected rows and explain why each item may need
attention. Do not delete or change records without my approval.
Why it helps: It creates a useful review checklist while keeping you in control of changes to the source data.
An unusual value is not necessarily an error. Investigate it before deciding whether it should be corrected or retained.
4. Create a chart from spreadsheet data
Best for: Turning a table of numbers into a clear visual.
Prompt:
Create a chart showing monthly revenue by region. Use a
chart type that makes regional trends easy to compare,
include a clear title and labelled axes, and keep the
legend readable. Explain the main pattern shown by the chart.
Why it helps: It combines a visualisation request with instructions about how the chart should communicate the data.
Review the selected chart type, labels and underlying data range before using it in a report.
5. Summarise a large dataset
Best for: Preparing a quick overview before a meeting.
Prompt:
Summarise this dataset for a business manager. Provide
the total revenue, average order value, strongest-performing
category and three important trends. Include the figures
used to support each finding and flag any limitations in the data.
Why it helps: It gives you a concise starting point for a report without removing the need to check the figures.
6. Build a budget tracker
Best for: Setting up a basic budget monitoring worksheet.
Prompt:
Help me build a monthly budget tracker with columns for
budget category, planned amount, actual amount, variance
and variance percentage. Suggest suitable formulas, flag
overspending and include a summary of total planned and
actual expenditure. Explain the formulas before applying changes.
Why it helps: It provides a structured starting point for routine budget monitoring.
Review the variance formula carefully. A positive or negative variance can mean different things depending on whether the category represents income or expenditure.
7. Create a management dashboard
Best for: Bringing several key performance indicators into one view.
Prompt:
Help me create a management dashboard from this workbook.
Include total revenue, month-on-month growth, performance
by region and the five highest-performing products.
Recommend suitable charts and show the calculations
behind each metric. Do not invent missing data.
Why it helps: It gives Copilot a defined set of metrics and a clear reporting purpose.
A dashboard should highlight the information that supports decisions, rather than include every available number.
Practical example: Turn a sales spreadsheet into a business report
Imagine you manage a sales team. Your Excel workbook contains thousands of order records, including order dates, product names, regions, quantities and revenue.
You need to prepare a short performance summary for your manager, but you do not have time to build every formula and chart from scratch.
Here is a practical way to approach the task.
Step 1: Ask Copilot to review the data
Start with:
Prompt:
Review this sales dataset. Identify the available columns,
check for missing or inconsistent data and recommend the
steps needed to prepare it for monthly sales analysis.
Do not change the source data yet.
Review the findings before making changes.
Step 2: Ask for the key calculations
Once the data is ready, ask:
Prompt:
Calculate total revenue by month and region. Identify
the highest-revenue region and calculate month-on-month
revenue growth. Explain the calculations and flag cases
where a comparison cannot be made reliably.
Check the totals against the original records and confirm that the dates have been grouped correctly.
Step 3: Create a useful visual
Next, ask:
Prompt:
Create a chart comparing monthly revenue across regions.
Use clear labels and a suitable chart type. Explain the
two most important patterns shown by the data, using
the actual figures.
A chart can make regional differences easier to see than a long list of figures.
Step 4: Turn the findings into an action summary
Finally, ask:
Prompt:
Summarise the results for a sales manager in five bullet
points. Include the strongest-performing region, the main
changes in revenue, any data-quality concerns and three
questions the team should investigate next. Do not present
correlation as proof of cause.
The result is a more structured starting point for a business review. You still need to verify the figures and decide which recommendations make sense.
How to get better results from Copilot in Excel
The best results come from combining clear instructions with well-prepared data.
Ask a specific question
Give Copilot a task, not just a topic. Explain which columns or metrics matter, what comparison you want and how you intend to use the result.
Example: “Compare quarterly revenue by region and identify the largest percentage change” is more useful than “Tell me about sales”.
Explain how calculations should work
Business metrics can be defined in different ways. If you are calculating profit margin, growth or variance, specify the formula or business rule you want to use.
This reduces ambiguity and makes it easier to validate the result.
Work in stages
For a complex workbook, use a sequence of smaller requests:
- Check the data structure.
- Identify missing or inconsistent values.
- Generate the required calculations.
- Create charts or summaries.
- Verify the results and prepare the final report.
This is easier to review than asking Copilot to transform a large workbook in one step.
Keep the original data safe
Before asking Copilot to make significant changes, save a separate copy or confirm that you can restore an earlier version. Review proposed changes before applying them, especially in shared workbooks.
Use the right level of access
Copilot’s available modes and features vary across devices and subscriptions. Microsoft’s documentation describes edit, plan and chat modes in supported Excel experiences. Some platforms may offer a different set of modes.
What are the limitations of Copilot for Excel?
Copilot can speed up spreadsheet tasks, but it is important to understand where human review remains essential.
| Limitation | What you should do |
|---|---|
| Incorrect formulas or calculations | Check cell references, logic and totals against the source data. |
| Misinterpreted data | Confirm the meaning of column headings, units and categories. |
| Missing or inconsistent records | Review data quality before drawing conclusions. |
| Misleading charts | Check the chart type, data range, labels and scale. |
| Changes to workbook content | Review changes and keep a recoverable version of the file. |
| Features missing from your account | Check your licence, application version and organisation settings. |
Do not rely on AI-generated calculations without checking them, particularly for financial reporting, tax, legal matters or other decisions where errors could have significant consequences.
Is Copilot for Excel included with Microsoft 365?
Copilot availability in Excel depends on your subscription and account configuration. Different Microsoft 365 plans and Copilot offerings provide different levels of access.
Some eligible users may have access to standard Copilot capabilities, while a commercial Copilot add-on can provide additional functionality. Personal subscriptions also have their own eligibility and AI usage conditions.
If you cannot see Copilot in Excel, check your account and subscription before assuming that you need to purchase another licence.
For details about Copilot pricing, eligible subscriptions and available features, explore our guides to Microsoft 365 Copilot pricing in India .
If you are evaluating Microsoft software for your organisation, you can also explore the AppBowl Microsoft marketplace. Confirm the exact product, licence and included capabilities before purchasing.
Make Spreadsheet Work Easier with AppBowl
Copilot for Excel can help you spend less time writing formulas, building charts and manually reviewing data. Its greatest value comes when you combine clear prompts with reliable source information and careful validation.
If your team regularly works with budgets, sales reports or operational spreadsheets, start with one repetitive task and measure whether Copilot makes the process easier.
Explore the AppBowl Microsoft marketplace to review available Microsoft software listings. Before purchasing, confirm the relevant subscription, Copilot features and licensing requirements for your organisation.
Ready to make Excel work smarter for your team?
Explore Microsoft software options and find the right solution for your business.
See Copilot PricingFrequently asked questions about Copilot for Excel
1. What can Copilot do in Excel?
Depending on your subscription and available features, Copilot can help generate formulas, analyse data, create charts and PivotTables, summarise findings and make changes to workbook content.
2. Can Copilot write Excel formulas?
Yes. You can describe a calculation in everyday language and ask Copilot to generate or explain a formula. Check the cell references, calculation logic and results before relying on it.
3. Can Copilot analyse data in Excel?
Yes. It can help summarise datasets, identify trends and outliers, compare categories and present insights through supported charts, PivotTables or written summaries. Results should be checked against the original data.
4. Can Copilot create charts in Excel?
Yes. Supported Copilot features can create and edit charts based on workbook data. You should still check the chart type, data range, labels and interpretation.
5. Can Copilot clean Excel data?
Copilot can help identify inconsistencies and perform supported data transformations. Review proposed changes carefully, as an unusual value may be valid rather than an error.
6. Why can’t I see Copilot in Excel?
Possible reasons include an ineligible subscription, account restrictions, an unsupported application version or organisation settings. Check Microsoft’s current requirements and contact your administrator if you use a work account.
7. Does Copilot in Excel work with large datasets?
Its suitability depends on workbook size, data structure, the task and the available Copilot experience. Well-organised data and focused prompts can make analysis easier, but you should test the workflow with your actual workbook.
8. Can I trust Copilot’s calculations?
Not without verification. Copilot can generate incorrect formulas or misinterpret data. Check the calculations against the source records before using them in financial or business decisions.
9. What is Copilot for Excel?
Copilot for Excel is Microsoft’s AI assistant, designed to help users work with spreadsheet data using natural language. It can assist with understanding data, exploring trends, creating formulas, generating summaries and improving spreadsheet workflows. It brings AI-powered assistance into supported Excel experiences, helping users complete tasks more efficiently.
10. How do I use Copilot in Excel?
To use Copilot in Excel, open a supported workbook with an eligible Microsoft account and select the Copilot option. Enter a prompt describing what you want to accomplish, such as summarising sales figures, comparing monthly performance or explaining a formula. Review the response and refine your instructions to get more relevant results. Availability depends on your subscription, Excel version and organisation settings.
11. Can Copilot create PivotTables in Excel?
Copilot can help users summarise and explore spreadsheet data, including identifying useful ways to group and compare information. Depending on the available Excel features, it can assist with PivotTable-related analysis. You can ask it to summarise sales by region, compare revenue by product or identify patterns across categories. Check the resulting fields and calculations before using the summary.
12. Is Copilot for Excel suitable for beginners?
Yes. Copilot for Excel can help beginners complete spreadsheet tasks by allowing them to describe what they need in everyday language. Users can ask for explanations, formula suggestions, data summaries and help understanding spreadsheet information. Basic Excel knowledge remains useful for checking results and understanding how the workbook is structured.
13. Is Copilot in Excel free?
Copilot in Excel is not automatically included with every Microsoft 365 subscription. Access to paid Copilot features generally requires an eligible Microsoft 365 base plan and the relevant Copilot licence. Some Copilot Chat capabilities may be available at no additional cost to eligible users, but this does not mean they receive the full Copilot experience within Excel.
14. Which Microsoft 365 plans support Copilot for Excel?
Copilot for Excel is available with eligible Microsoft 365 subscriptions and the required Copilot licence. Eligible base plans can include Microsoft 365 Business Basic, Business Standard and Business Premium, subject to Microsoft’s current licensing terms. Organisations should confirm their plan eligibility and add-on requirements before purchasing.
15. Can I use Copilot in Excel online?
Yes. Copilot is available in supported Excel for the web experiences for eligible users. Sign in with the Microsoft account associated with your Copilot licence and open a supported workbook. Available features may vary depending on your subscription, account configuration and Microsoft’s feature rollout.
16. Can Copilot explain complex Excel formulas?
Yes. You can ask Copilot to explain an existing Excel formula in plain language, describe what individual functions do or clarify how cell references work. This can be particularly helpful when reviewing complex spreadsheets or understanding formulas created by another team member. Always check the explanation against the actual formula.
17. How can businesses get Copilot for Excel licences in India?
Businesses in India can purchase eligible Microsoft 365 subscriptions and Copilot licences directly from Microsoft or through authorised licensing partners and software marketplaces such as AppBowl. Before purchasing, check the eligible base subscription, Copilot licence requirements, subscription duration and applicable taxes.