Get insights about numerical data with Copilot in Excel

Get insights about your data

1. Open Excel.

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

3. From the Home tab, select the Copilot ​​​​​​​ button in the ribbon.

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.

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