Catfish Your Manager -- CLEAN an Excel Dataset using Chat GPT. No Excel Skills Required!
DOWNLOAD THE WORKBOOK:
https://www.cellmatestraining.com/download-excel-catfishing
Imagine the scenario. You're a new employee and the first task your manager has asked you do is take a messy dataset and clean it up in Excel ready for analysis with a Pivot Table. However, you have very basic Excel skills and don't know where to start!
No problem! Get Chat GPT to do the heavy lifting.
In this video, we are going to upload a dataset into Chat GPT that has several issues - blank rows, duplicate entries, inconsistent case, spacing issues, incorrect formatting to name a few. We'll then get Chat GPT to identify the issues and through a series of well constructed prompts, use AI to fix the issues.
It's like having an Excel Expert on hand at all times!
🔗LINKS to related videos
🤖 Generate Excel Data with Chat GPT
https://youtu.be/uXCW8i5NTuY?si=3yIZkUYgOxnuteS0
📉 FIRST LOOK - Microsoft Copilot + Excel
https://youtu.be/GYaX-LaMyVA?si=PfQk38bQD6YKWXbl
📊The FILTER Function in Excel + Bonus Tips
https://youtu.be/ZMEYajwCKew?si=Mwmc9oYDOvhMCyxq
************************************************
🤝Let's CONNECT on social:
➡️TikTok: https://www.tiktok.com/@cellmates_
➡️Instagram: https://www.instagram.com/cellmatestr...
➡️LinkedIn: https://www.linkedin.com/in/deborahas...
➡️Twitter: https://twitter.com/CellMates_
➡️Facebook: https://www.facebook.com/CellMates/