How to Do Sentiment Analysis in Excel (Step-by-Step Guide)

About this video

Kevin Stratvert demonstrates sentiment analysis in Microsoft Excel using Microsoft 365 Copilot, working with a list of Kevin Cookie Company customer feedback. The feature requires Microsoft 365 with Copilot and a workbook saved in the cloud. First, via the Copilot chat pane on the Home tab, he prompts for a high-level summary that returns overall sentiment (mostly positive in the example), positive and negative themes, and a summary table, then asks Copilot to filter to pricing-related feedback and to generate a word cloud using Python, which Copilot writes and runs automatically. Second, he uses the in-cell COPILOT function — e.g. =COPILOT(“Give me the sentiment”, [feedback range]) — to return sentiment per row, spot-checking examples, and revises the prompt to return emoji faces instead of text. He then applies Excel filters to isolate negative feedback, uses the same function with a theme/category prompt (which can return multiple categories such as delivery and customer service for one comment), and shows results update automatically when a feedback entry is changed. Finally he summarizes counts with a PivotTable (in the example 9 happy, 3 neutral, 3 mad) and visualizes theme counts with a PivotChart pie chart.

Key takeaways

• Sentiment analysis in this workflow requires Microsoft 365 with Copilot and a cloud-saved workbook
• Copilot chat can summarize overall sentiment, break out positive/negative themes, and filter feedback by topic such as pricing without reading every comment
• The in-cell COPILOT function takes a natural-language prompt plus a context range and returns per-row sentiment or theme/category, updating automatically when source text changes
• Prompts can be customized, for example to return emoji faces instead of text labels, and results can then be filtered in Excel
• PivotTables and PivotCharts can count sentiment or theme frequencies to surface patterns such as the most common feedback category

Episode details: published September 26, 2025 · 9:39 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: PowerPoint Copilot Tutorial: How Microsoft’s New AI Changes Everything · Next: How to Use n8n for FREE (with Docker) →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube