Recall
Set 1: Quick Check
Plan a safe cleaning sequence, preserve raw data, and distinguish TRIM from CLEAN.
Text Functions & Data Cleaning
Cleaning Text Data
Build practical skills in text functions & data cleaning.
Start Chapter PracticeChapter plan
What you will be able to do
- Apply text functions & data cleaning concepts in realistic spreadsheet work.
- Study time
- 26–32 minutes, self-paced
- Course
- Excel for Work (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Standardize case, extract a region code, and combine name fields without losing source values.
Hands-on
Set 3: Workplace Task
Clean a customer code in the spreadsheet workspace, then parse a year from a ticket ID.
Independent check
Set 4: Mastery Check
Recognize the risk of fixed-position extraction and validate cleaned output against the original.