Basic Tech & Web Skills · BEGINNER
Spreadsheet Text Cleanup Basics
Practise spreadsheet text cleanup basics with worked examples, useful checklists and fictional projects. Learn free; a Certificate of Completion is optional.
What you’ll be able to do
- Apply the workflow: inspect text before changing it.
- Apply the workflow: clean ordinary spaces carefully.
- Apply the workflow: standardise case and labels.
- Apply the workflow: split and join text with purpose.
- Apply the workflow: validate and retain the original data.
Your course, step by step
- Inspect text before changing it
- Clean ordinary spaces carefully
- Standardise case and labels
- Split and join text with purpose
- Validate and retain the original data
How completion works
Pass the practice question in every lesson first, then pass four assessment sets in order. Each set has 10 distinct questions and requires at least 80% (8 out of 10). All four must be passed; a high score in one cannot compensate for another. It is open-book and must be your own work. This automated assessment checks course understanding; it does not independently verify identity or workplace competence.
Each set attempt has its own 15-minute window. Starting an attempt counts even if you abandon it. Wait 15 minutes from the start before a retake; after every third attempt of the same set wait 24 hours. Passed sets stay saved. A live attempt can be resumed. Retakes and learning remain free.