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

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