Excel Data Cleaning Practice
Real-world data is messy. Learn to identify duplicates, fix inconsistent branch codes, remove extra spaces and prepare data for analysis.
What you will practise
- Finding duplicate order IDs, employee IDs or product codes.
- Removing leading and trailing spaces with TRIM.
- Standardising inconsistent branch or department names.
- Handling blank or missing values before calculating summaries.
Try a data-cleaning exercise
The Daily Sales MIS Report introduces duplicate records and inconsistent branch codes.
Start Sales Exercise