Excel’s new =COPILOT() function can clean messy data in seconds — but only if you know how to prompt it properly. In this video, I show you exactly how I used Excel’s AI to fix duplicates, inconsistent dates, messy formatting, and more… all with ONE prompt. I also show the mistake it made (and why!) — plus how to avoid it. If you work in finance, operations, or any role where spreadsheets eat your time, this update will genuinely save you hours. 🧠 Try the prompts from this video =COPILOT("Remove duplicates and fix formatting", A1:D500) =COPILOT("Remove duplicates, fix formatting, and extract the currency into a new column called 'Currency'", A1:D500) ---------------------------------------------------- 🔗 LinkedIn: I post daily tips on Excel, AI, and smarter workflows. 👋🏽 About Me: I help professionals work smarter with AI & Excel tools. If you're tired of spending hours on tasks that could take minutes, subscribe for weekly tutorials on Copilot in Excel, Excel mastery, and AI productivity workflows. #CopilotInExcel #ExcelSetup #ExcelAI #MicrosoftCopilot #ExcelTips #AIProductivity