Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I want to do some further analysis of bikes for my (fictional) company. At the request of some, I have attached the workbook I used for this and previous posts.

Bike sales table showing columns for Year, Category, Product, Sales and Rating.

I’d like to dive deeper into the ratings for bike products. I ask copilot:

chart ratings by year for bikes

Copilot in Excel pane showing the above prompt and a chart showing the average rating of bikes for the years 2015-2017.

The ratings are poor and I’d like to expand to the product level, so I ask Copilot:

now show ratings by year by product for the bikes category

Copilot in Excel pane showing a chart of ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.

I click on the Add to a new sheet button in the pane and the following is inserted into a new sheet:

Excel PivotTable and Chart showing ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.

All products improved for 2017, but ratings for Touring bikes are very low.

Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I want to do some further analysis of bikes for my (fictional) company. At the request of some, I have attached the workbook I used for this and previous posts.
Bike sales table showing columns for Year, Category, Product, Sales and Rating.
 
I’d like to dive deeper into the ratings for bike products. I ask copilot:
chart ratings by year for bikes
 
Copilot in Excel pane showing the above prompt and a chart showing the average rating of bikes for the years 2015-2017.
 
The ratings are poor and I’d like to expand to the product level, so I ask Copilot:
now show ratings by year by product for the bikes category
 
Copilot in Excel pane showing a chart of ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.
 
I click on the Add to a new sheet button in the pane and the following is inserted into a new sheet:
 
Excel PivotTable and Chart showing ‘Rating’ by ‘Year’ and ‘Product’ for ‘Category’ ‘Bikes’.
 
All products improved for 2017, but ratings for Touring bikes are very low.
 
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​