Identify insights with Copilot in Excel
Copilot for Microsoft 365 can show insights based on your data or a specific question you ask about your data.
-
Format the data in your spreadsheet as a table, then select it.
-
Select the Copilot button in the ribbon.
-
Select Get started.
-
Select Analyze and choose a suggested prompt. Or describe what you’d like to know by asking a question about your data in your own words.
-
Select Send. Copilot analyzes your data to show insights as charts, PivotTable objects, summaries, trends, or outliers.
-
Use the refresh button to discover more prompts.
-
After Copilot has analyzed your data, review many different insights to find ones that help you make the most of your data.
-
To add a chart to the sheet, select Add to sheet. If multiple insights are available, you can add all insights to a grid in a new sheet. To undo this, select Undo.
Try this
Here are some suggestions for prompts you might want to try. Copy them and modify them to suit your data.
-
Plot sales by category over time.
-
Show total sales for each product.
-
Show the total of advertising sales for each region last year .
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.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Find solutions to common problems or get help from a support agent.
