
π This article includes 1 downloadable practice file β
In this article
AI is excellent at messy-text jobs that are tedious by hand: categorising bank narrations, standardising names, pulling fields out of free text.
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.
Practice
Try the three exercises with anonymised data.
π Practice files for this article
- πLesson 5 worksheetPrompts and exercises for this lesson.β¬ TXT Β· 434 B
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.
Stuck on a step? Ask a question and the AI answers using this article.