InsideEdgeInsideEdge
Download App

Phase 2 · Excel & Spreadsheets

Topics

Data Cleaning in Excel

Part of the Data Analyst Roadmap.

Summary

Using TRIM, TEXT-to-COLUMNS, Find & Replace, and Remove Duplicates to fix messy real-world data before any analysis is trustworthy.

How to Learn This

  • 1Take a deliberately messy dataset (extra spaces, inconsistent casing) and clean it fully.
  • 2Learn TRIM, CLEAN, and PROPER/UPPER/LOWER for text normalization.
  • 3Practice using Text-to-Columns to split a combined field into separate columns.

Previous

Conditional Formatting

Next

Excel Charts & Dashboards

More topics in Excel & Spreadsheets

Excel FundamentalsFormulas & Functions (VLOOKUP, INDEX-MATCH, XLOOKUP)PivotTables & PivotChartsConditional FormattingExcel Charts & DashboardsPower QueryGoogle Sheets EssentialsData Validation in SpreadsheetsExcel Shortcuts & Productivity
InsideEdge

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download
InsideEdge