Copilot
Copilot in Excel
Copilot in Excel
Get insights about numerical data with Copilot in Excel
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Microsoft365.com Excel for iPad Excel Web App Microsoft Office

Gain a better understanding of your numerical data with charts, summaries, trends, and outliers by using Copilot in Excel.

Get insights about your data

Note: To use the feature described here, you need a work or school account with a qualifying Microsoft 365 business subscription, and a Microsoft 365 Copilot add-on license. See How Copilot works with and without a Microsoft 365 Copilot license.

  1. Open Excel.

  2. Make sure to format your data in a table or supported range.

  3. From the Home tab on the ribbon, select Copilot small image of the Copilot icon. > App Skills.

  4. Ask Copilot to find the insights you're looking for. Type something in your own words, or modify one of the example prompts. The more specific your question, the better the answer Copilot can find. If you want your insights in a specific format, such as a PivotTable, specify that in your prompt.

  5. Copilot analyzes your data to show insights as charts, PivotTables, summaries, trends, or outliers.

  6. Review the insights provided to find ones that help you the most.

  7. To add a generated chart to a sheet, select Add to a new sheet. If Copilot provided you multiple insights, you can add all insights to a grid in a new sheet.

  8. Select Undo if you want to remove the insights from your new sheet.

Get insights with example prompts:

These prompts are based on a data set that includes people with their country and dates of birth and death.

Icon depicting a document with sparkles How many people in this list are still alive?

Icon depicting a document with sparkles How many people in this list were born in Africa?

Icon depicting a document with sparkles How many women in this list were born in the 1800s?

Tip: Be specific with your questions - the more detail you provide the better Copilot can help. This includes clearly specifying the column headers you want to reference for formatting or analysis queries.

More ways to analyze data with Copilot in Excel

Get insights about text-based data with Copilot in Excel

Create PivotTables with Copilot in Excel

Perform advanced analysis with Copilot in Excel with Python

Facebook LinkedIn Email

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center