Скачать или смотреть 17 Ways to Use Excel’s New COPILOT Function (🤯 Data Cleanup)

Excel’s new COPILOT function allows you to prompt ChatGPT in a formula. In this video I share 17 creative ways to use it to save hours with data cleanup tasks including: categorizing bank statements, fixing semantic duplicates, figuring out what to cook for dinner, planning your next roadtrip, and more. It's pretty mind blowing to see how AI can help us with everyday Excel tasks.

👉Download the Excel file I use in the video (includes the prompts): https://www.excelcampus.com/functions...

📚Resources:
Microsoft's Announcement: https://techcommunity.microsoft.com/b...
COPILOT Function help page with availability and usage limits: https://support.microsoft.com/en-us/o...

Try Wispr Flow: Voice to Text app I use in the video: https://ref.wisprflow.ai/excel-campus
Wispr Flow Video:    • This AI app has TRIPLED my Productivity  

How to create Dynamic Start Rating Formula:    • How to Create a Dynamic Star Rating in Exc...  

00:00 - Introduction
00:20 - Text Parsing
02:45 - Return Multiple Columns
04:07 - Potluck Planner
06:35 - Meal Planner
07:30 - Splitting Names
09:00 - Trip Planner
10:06 - Categorize Bank Statements
12:30 - Sentiment Analysis
13:26 - Seating Planner
13:56 - Standardize Dates
14:25 - Standardize Company Names
15:37 - Extract Order Details
16:06 - Categorize Support Issues
16:31 - Semantic Duplicates
17:00 - Shorten Job Titles
17:32 - Address Cleanup
17:53 - Customized Emails