Get insights about numerical data with Copilot in Excel
Applies To
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
-
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.
|
|
|
|
|
|
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
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.
