Summarizing survey results with Copilot in Excel

Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel.

 

Today I will show you how you can use Copilot to summarize feedback that’s in an Excel workbook. I’ll start with some feedback about a fictional product shown below:

 

A one column table containing feedback text responses about a product.

I ask Copilot in Excel to:  Summarize the Feedback

 

Copilot in Excel pane showing 5 categories of feedback (User-Friendly Interface and Setup, Performance and Reliability, Voice Recognition and Customization, Sustainability and Energy Efficiency, Customer support and Updates)

 

Copilot returns these 5 categories that summarize the feedback received:

Here's a summary of column 'Feedback':

• User-Friendly Interface and Setup: The product is praised for its intuitive and user-friendly interface, clean layout, and easy navigation. Users appreciate the quick and hassle-free setup process, allowing them to start using the product within minutes.
• Performance and Reliability: The product is noted for its reliable performance, quick response to commands, and ability to work well even in noisy environments. Users rarely experience lag or delays, and the product consistently performs well without major issues.
• Voice Recognition and Customization: The voice recognition feature is impressive, accurately understanding commands. Users appreciate the ability to customize settings and create routines, enhancing their smart home experience.
• Sustainability and Energy Efficiency: The product's focus on sustainability and energy efficiency is well-received. Energy-saving features help reduce electricity bills, and the product automatically turns off devices when not in use.
• Customer Support and Updates: The support team is knowledgeable, friendly, and responsive, quickly resolving any issues. The product receives regular updates that add new features and improve performance, with seamless updates that don't disrupt usage.

Copilot provided a great summary of the feedback. I see that there is both positive and negative feedback for this product. I would like to break it down in that way, so I follow-up with another question for Copilot:

 

That's good but please summarize into 2 categories, one for positive feedback and one for negative

 

Copilot in Excel window showing the above prompt and a summary of positive and negative feedback.

 

Copilot returns a summary of the positive and negative feedback for the product which I can use to communicate with my team and provide an overview of feedback received.

 

Here's a summary of column 'Feedback':

• Positive Feedback: Users appreciate the intuitive and user-friendly interface, seamless integration with smart home setups, and the ability to customize settings and create routines. The voice recognition feature is praised for its accuracy, and the product's performance is noted for being reliable and responsive. Other positive aspects include the focus on sustainability and energy efficiency, sleek and modern design, and the helpful and knowledgeable customer support team. Regular updates that add new features and improve performance are also highlighted.
• Negative Feedback: Some users encountered compatibility issues with older smart devices and expressed concerns about privacy and data security. There are occasional struggles with accents, and some older devices don't work as well with the assistant. Users also mentioned the desire for the product to support a wider range of devices and the need for transparency about data usage.

 

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.