I worked on cleaning and organizing a messy Excel sales dataset containing customer details, phone numbers, email addresses, order dates, product information, pricing, discounts, and payment methods. I focused on identifying inconsistent formats, correcting data entry issues, standardizing values, and flagging missing or invalid information. I also worked on identifying suspicious phone numbers and maintaining data accuracy while preserving the original records.
0
3
I worked on cleaning a messy 2,000-row dataset containing inconsistent customer names, phone numbers, email addresses, dates, product names, and sales information. I focused on standardizing formats, removing unnecessary separators, identifying phone numbers with fewer than 10 digits, and flagging missing or suspicious values for review. My goal was to make the data more consistent, accurate, and organized while preserving the original records.
0
12
Excel Data Cleaning & Organization
Transformed an unstructured dataset containing multiple fields in a single text column into a structured, organized Excel table.
Work performed:
Separated combined records into individual columns.
Organized fields under clear, descriptive column headers.
Applied consistent formatting and table styling.
Improved readability and prepared the dataset for sorting, filtering, and further analysis.
Tools: Microsoft Excel
Outcome: Converted difficult-to-read raw data into a structured dataset ready for further analysis.
0
25