AI for Office Work Lesson 5: Cleaning and Classifying Data

AI for Office Work Lesson 5: Cleaning and Classifying Data featured illustration

πŸ“Ž This article includes 1 downloadable practice file ↓

⏱ 1 min read

πŸ“˜ AI for Office Work Course Β· Lesson 5 of 8

In this article
  1. Classify
  2. Standardise
  3. Extract
  4. Scale: ask for the tool, not the answer
  5. Practice
  6. Continue learning

AI is excellent at messy-text jobs that are tedious by hand: categorising bank narrations, standardising names, pulling fields out of free text.

Advertisement

Classify

“Categorise each line into Salary, Rent, Utilities, Vendor payment, Customer receipt, Bank charges or Other. Return a two-column table.” Give the fixed list of categories, or you’ll get a different set each time.

Standardise

“Standardise these company names: remove M/s, fix abbreviations, Title Case.” Ask for a mapping table (original β†’ clean) so you can review and reuse it with XLOOKUP.

Extract

From addresses, emails or descriptions: “Extract city, state and PIN code as a table; null if missing.”

Scale: ask for the tool, not the answer

For 50 rows, paste and clean. For 50,000 rows every month, ask: “Give me Power Query steps (or an Excel formula / Python script) that does this for any number of rows.” Then the cleaning is repeatable and auditable.

Advertisement
πŸ’‘ Spot-check 10% of AI-classified rows, focusing on the ‘Other’ bucket and borderline cases, before using the results in a report.
⚠️ Remove account numbers, PAN, Aadhaar and personal details before pasting data into any AI tool that isn’t approved for confidential data.

Practice

Try the three exercises with anonymised data.

πŸ“Ž Practice files for this article

Free to use for learning. Files with macros (.bas) are plain text β€” import them with Alt+F11 β†’ File β†’ Import File, and always test on a copy.

✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free Β· AI can be wrong