Skip to content

AkulaSrilasya/Excel-Data-Cleaning-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 

Repository files navigation

Excel Data Cleaning Project

Project Overview

This project demonstrates data cleaning techniques using Microsoft Excel. The objective was to transform raw data into a clean, accurate, and analysis-ready dataset.

Tools Used

  • Microsoft Excel
  • Sorting & Filtering
  • Remove Duplicates
  • Find & Replace
  • Data Validation
  • Excel Functions

Data Cleaning Steps

  • Removed duplicate records
  • Handled missing values
  • Standardized date formats
  • Corrected formatting inconsistencies
  • Removed unnecessary columns
  • Trimmed extra spaces
  • Validated data accuracy

Skills Demonstrated

  • Data Cleaning
  • Data Preparation
  • Data Validation
  • Data Quality Management
  • Microsoft Excel
  • Analytical Thinking

Outcome

The dataset was cleaned and prepared for analysis, improving data quality and reliability.

Author

Srilasya Akula Aspiring Data Analyst

About

Excel data cleaning project demonstrating data preparation, validation, and quality improvement techniques.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors