Data Cleaning & Preparation in Excel
Trim, split, convert, map, de-duplicate, fill, flag and validate: 8 labs that turn messy exports into analysis-ready tables.
The first lesson is free — no account needed.
Lessons
- Trimming Spaces & Fixing Case: TRIM, PROPER, UPPERFree
- Splitting Codes & Names: LEFT, MID, FIND Pro
- Converting Text Numbers & Text Dates into Real Values Pro
- Standardising Categories with a Mapping Table (XLOOKUP) Pro
- Finding Duplicates & First Occurrences with COUNTIFS Pro
- Handling Blanks & Outliers: IF, MEDIAN and Flags Pro
- Validating Rows: Rule Checks with AND, OR and an Error Count Pro
- Capstone: an Analysis-Ready Table and a Region × Month Summary Pro