Lesson 2.3 Data Cleaning Techniques in Excel

Clean datasets lead to accurate analysis.

Common Data Quality Issues

• Duplicates
• Missing values
• Extra spaces or inconsistent formatting
• Incorrect data types

Cleaning Tools & Techniques

• Remove Duplicates
• Find & Replace for standardization
• Text to Columns to split combined fields
• Data Validation to restrict invalid inputs
• Flash Fill to automate repetitive cleaning patterns
• TRIM() / CLEAN() for fixing text

Example Use Case

A customer dataset may have inconsistent phone numbers. Using cleaning functions, formatting tools, and validation rules ensures accuracy and consistency.