Explanation

Data cleaning prepares raw business data for reliable analysis.

Common Problems

  • Blank cells
  • Duplicate records
  • Extra spaces
  • Inconsistent spelling
  • Wrong capitalization
  • Incorrect data types
  • Formula errors
  • Invalid dates
  • Missing values

Useful Cleaning Functions

=TRIM(A2)

=PROPER(A2)

=UPPER(A2)

=LOWER(A2)

Handling Blank Data

Identify blanks using:

=ISBLANK(A2)

Or:

=IF(A2=””,”Missing”,”Available”)

Handling Errors

=IFERROR(A2/B2,0)

This prevents errors such as #DIV/0! from appearing in reports.

Data Preparation Workflow

Raw Data → Check → Clean → Validate → Format → Remove Duplicates → Handle Blanks/Errors → Table → Analyze

PreviousNext