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 will once again use this table of book sales, using Copilot to find more insights.

Table of book sales with columns for Book Id, Release date, Author, Category, Publishing Branch, User Rating and Sales

I ask Copilot:

Which category has the best user ratings

Copilot in Excel pane showing above prompt and response, The category with the best user ratings is Children Books with an average user rating of 3.861.

I would also like to know which author is best, so I ask Copilot:

Which author has the highest average user rating?

Copilot in Excel pane showing the above prompt and the response, The author with the highest average user rating is Kenneth Liew with an average user rating of 4.533.

After getting that response, I would like to know more than just the top author, so I ask:

Show me the top 5 authors by user rating

Copilot in Excel pane with the above prompt and the response: The top 5 authors by average user rating are Kenneth Liew (4.53), Tania Agius (4.5), Bernadette Leblanc (4.4), Andrew Fenec (4.35), and Belinda Kaur (4.33)

With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation.

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 will once again use this table of book sales, using Copilot to find more insights.
 
Table of book sales with columns for Book Id, Release date, Author, Category, Publishing Branch, User Rating and Sales
 
I ask Copilot:
Which category has the best user ratings
 
Copilot in Excel pane showing above prompt and response, The category with the best user ratings is Children Books with an average user rating of 3.861.
 
I would also like to know which author is best, so I ask Copilot:
Which author has the highest average user rating?
 
Copilot in Excel pane showing the above prompt and the response, The author with the highest average user rating is Kenneth Liew with an average user rating of 4.533.
 
After getting that response, I would like to know more than just the top author, so I ask:
Show me the top 5 authors by user rating
 
Copilot in Excel pane with the above prompt and the response: The top 5 authors by average user rating are Kenneth Liew (4.53), Tania Agius (4.5), Bernadette Leblanc (4.4), Andrew Fenec (4.35), and Belinda Kaur (4.33)
 
With that response, I can insert the Summary into a new sheet or copy the textual summary to add to a document or presentation.
 
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

​