International Data Cleaning & Formatting – 100-Row Practice Project I also Completed a 100-row in...International Data Cleaning & Formatting – 100-Row Practice Project I also Completed a 100-row in...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
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
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started