KHIZHNYAKOV

← Courses

Cleaning and Reconciling Lists — AI Course

Remove duplicates, fix messy entries and match lists against each other with AI help.

Cleaning and Reconciling Lists — AI Course
≈ $4.99
395 ₽
ZIP with 4 PDF versions: ChatGPT, Gemini, Claude, Copilot · ready-to-use prompts · free updates
Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

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.

Questions and answers

Which AI assistant do I need?
Any of the four: ChatGPT, Gemini, Claude or Microsoft Copilot. The free plan is enough for most tasks; each PDF version notes where a paid plan helps.
What format is the course?
A ZIP archive with four PDF files, one for each AI assistant. Read on screen or print.
Do I need technical skills?
No. Every lesson shows the exact prompt to copy and an example of a good result.
Can I use the prompts at work?
Yes. Just never paste personal or confidential data into an AI assistant — the course explains how to anonymize documents.