Uploaded September 2025 | Updated September 2026, 17 hours ago
📌 NOTE: Microsoft officially retired the Excel Copilot function on September 14, 2026. This video is kept for reference/archival purposes.
🔥 400,000+ enrolled in our courses. Join them 👉 link.xelplus.com/yt-d-all-courses
In this video you’ll see how I use COPILOT to understand the meaning behind the text and classify text into categories. For example to pull Next Steps from shift notes, split free text into Topic, Risk, Owner, Due Date, run sentiment analysis, and clean job titles to a standard list. Yes. You can do fuzzy text matching with copilot not based on the letters in words but based on the underlying meaning to text. Fast and practical.
00:00 New Excel COPILOT Function
01:37 Extract Next Steps from notes with COPILOT Function
03:38 Split free text into multiple columns
05:59 Sentiment analysis on customer reviews in Excel
09:38 Clean inconsistent data
11:04 COPILOT pros, cons, limits and best practices
11:45 Wrap up
Who this helps
Project managers. Analysts. HR and Ops teams. Anyone who deals with messy text and wants clean, useful output inside Excel.
What you’ll learn
- Write short prompts that reference your cells
- Turn notes into a structured table
- Tag reviews with sentiment and categories
- Normalize labels and get a confidence score
- When to lock results by pasting Values
- How to combine COPILOT with FILTER() and LEN()
Availability and requirements
- COPILOT is currently in Beta for Microsoft 365 Insider Beta Channel and requires a Microsoft 365 Copilot license.
- Usage limits apply. Up to 100 COPILOT calls per 10 minutes. Results may change on recalculation. Review outputs before you rely on them.
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
What's Python in Excel + Do You REALLY Need it?: youtu.be/5PB4yeZucUk
You're ONE DOT Away from Cleaner Excel Reports: youtu.be/5h4wRTbmsSw
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
📌 NOTE: Microsoft officially retired the Excel Copilot function on September 14, 2026. This video is kept for reference/archival purposes.
🔥 400,000+ enrolled in our courses. Join them 👉 link.xelplus.com/yt-d-all-courses
In this video you’ll see how I use COPILOT to understand the meaning behind the text and classify text into categories. For example to pull Next Steps from shift notes, split free text into Topic, Risk, Owner, Due Date, run sentiment analysis, and clean job titles to a standard list. Yes. You can do fuzzy text matching with copilot not based on the letters in words but based on the underlying meaning to text. Fast and practical.
00:00 New Excel COPILOT Function
01:37 Extract Next Steps from notes with COPILOT Function
03:38 Split free text into multiple columns
05:59 Sentiment analysis on customer reviews in Excel
09:38 Clean inconsistent data
11:04 COPILOT pros, cons, limits and best practices
11:45 Wrap up
Who this helps
Project managers. Analysts. HR and Ops teams. Anyone who deals with messy text and wants clean, useful output inside Excel.
What you’ll learn
- Write short prompts that reference your cells
- Turn notes into a structured table
- Tag reviews with sentiment and categories
- Normalize labels and get a confidence score
- When to lock results by pasting Values
- How to combine COPILOT with FILTER() and LEN()
Availability and requirements
- COPILOT is currently in Beta for Microsoft 365 Insider Beta Channel and requires a Microsoft 365 Copilot license.
- Usage limits apply. Up to 100 COPILOT calls per 10 minutes. Results may change on recalculation. Review outputs before you rely on them.
📨 Subscribe to "Between the Sheets" newsletter to stay on top of office tips and Excel hacks: link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
What's Python in Excel + Do You REALLY Need it?: youtu.be/5PB4yeZucUk
You're ONE DOT Away from Cleaner Excel Reports: youtu.be/5h4wRTbmsSw
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
More resources on my Amazon page: amazon.com/shop/leilagharani
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
