Create PivotTables with Copilot in Excel

If you want to see specific data from a large data set, you can ask Copilot to create a PivotTable. With Copilot, you don't have to do a lot of steps—just ask for what you want.

Let's say you have a large data set from your Marketing team. Perhaps it includes data for year, month, type of marketing campaign, product, cost of campaign, budget, revenue, and much more. If you just want to compare what was budgeted for different types of campaigns, you could ask Copilot for a PivotTable that includes only the campaign types and the average budget for each type.

Note: To access Copilot, you'll need the right license.

Create a PivotTable with Copilot

Open Excel.
Make sure to format your data in a table or supported range for Copilot.
Select the Copilot button in the ribbon.
Ask Copilot to create a PivotTable for you. The more details you include, the more accurate and useful Copilot's results will be. Try one of the sample prompts, or type something in your own words.
If Copilot's suggestions don't match what you want, you can add more details and ask Copilot to generate again.