What this course is about
Duplicates, extra spaces, broken dates and mismatches between two lists. The AI gives you the method and the formulas, while your data stays on your computer.
Lists arrive messy: the same person is entered three times, dates come in five formats, one export has 412 rows and another has 409, and nobody knows who is missing. Such lists usually contain personal data, so you do not send them to an AI in full. In this course I show you a method that works: you describe the table structure and a couple of made-up rows to {AI}, get formulas and a plan, and do the cleanup yourself in Excel.
What you will learn
- Finding duplicates
- Marking "first" and "repeat"
- Extra spaces and letter case
- Before and after: clean company names
- Errors in dates
- Finding suspicious dates
- Empty required fields
- A "what to fill in" list
- Reconciling two lists
- Case study: who is missing from the payment list
- Reconciling several fields
- Example: reconciling charges and payments
What's inside
- Four PDF versions of the course: for ChatGPT, Gemini, Claude and Microsoft Copilot — each explains where to find the features you need in that assistant.
- 13 ready-to-use prompts and a prompt library you can copy from.
- Step-by-step tasks, before-and-after examples and a one-page cheat sheet.
- Free updates when the AI assistants change.
Who it's for
Office workers, managers, teachers, freelancers and small-business owners who want practical results from AI without technical knowledge.
KHIZHNYAKOV