Скачать или смотреть Excel's New AI Function is Absolutely Insane (Copilot Function)

🔥 400,000+ enrolled in our courses. Join them 👉 https://link.xelplus.com/yt-d-all-cou...

Excel just added the COPILOT function. Type =COPILOT() in a cell. Point to your data. Get clear answers in the grid. No extra tools.

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: https://link.xelplus.com/yt-d-newsletter

➡️ Join this channel to get access to perks:
   / @leilagharani  

🎬 LINKS to related videos:
What's Python in Excel + Do You REALLY Need it?:    • What's Python in Excel + Do You REALLY Nee...  
You're ONE DOT Away from Cleaner Excel Reports:    • You're ONE DOT Away from Cleaner Excel Rep...  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

🚩Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / 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