Large-Scale People Data Cleaning & Organization (Excel)

Overview

This project focuses on cleaning and organizing a large dataset containing over 500,000 records. The dataset includes personal and job-related information such as names, contact details, and job titles. The main objective was to improve formatting, consistency, and usability for future analysis.

Tools Used

• Microsoft Excel

Key Tasks Completed

• Processed and organized a dataset containing 500,000+ records
• Cleaned and formatted key fields such as names, phone numbers, and dates of birth
• Organized job-related fields (job titles) for easier review
• Improved dataset readability and ensured consistent formatting across columns

Dataset Fields

The dataset includes fields such as:

• User ID, First Name, Last Name
• Sex, Email, Phone
• Date of Birth
• Job Title

Outcome

The dataset is structured, consistently formatted, and prepared for analysis, filtering, and reporting.

File Included

• Large_Scale_People_Data_Cleaning.xlsx