Customer Data Cleaning & Organization (Excel)

Overview

This project demonstrates data cleaning and organization skills using Microsoft Excel. The dataset contains customer records including names, contact details, company information, and subscription dates. The goal of the project was to improve data consistency and prepare the dataset for accurate analysis and reporting.

Tools Used

• Microsoft Excel

Key Tasks Completed

• Cleaned and standardized customer contact data (phone number formatting and date formatting)
• Organized customer records for improved readability and consistency
• Applied multi-level sorting with mixed ascending and descending order
• Ensured structured data layout for future analysis and reporting

Dataset Fields

The dataset includes fields such as:

• Customer ID, Name, Company, City, Country
• Phone numbers (multiple columns)
• Email and Website
• Subscription Date

Outcome

The final dataset is cleaner, more consistent, and formatted for easier filtering, sorting, and analysis.

File Included

• Customer_Data_Cleaning.xlsx