International Data Cleaning & Formatting – 100-Row Practice Project
I also Completed a 100-row international data-cleaning practice project using Microsoft Excel. The dataset contained customer information from different countries and included common data-quality issues such as inconsistent capitalization, extra spaces, incorrect phone-number formats, missing information, duplicate records, and inconsistent formatting.
I cleaned, standardized, and organized the dataset to improve accuracy, consistency, and readability while applying Excel data-cleaning techniques and formulas.
Skills demonstrated:
Microsoft Excel
Data Cleaning & Data Entry
Data Formatting
Removing Duplicates
Text Cleaning with TRIM
Standardizing Names and Locations
Phone Number Formatting
Identifying Missing Data
Spreadsheet Organization
Quality Checking