Analyzing bike sales using Copilot for Excel

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.