Get insights about numerical data with Copilot in Excel
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. Start your free trial of Microsoft 365 today or learn How Copilot works with and without a Microsoft 365 Copilot license.
- Open Excel.
- From the Home tab on the ribbon, select Copilot
👁 small image of the Copilot icon.
. - 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.
- Copilot analyzes your data to show insights as charts, PivotTables, summaries, trends, or outliers.
- Review the insights provided to find ones that help you the most.
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