Tracks/Spreadsheets (Excel/Google Sheets)/Spreadsheets for Analysis
Intermediate

Spreadsheets for Analysis

Clean messy data, add validation, create pivot summaries, build charts, and use conditional formatting.

5
Modules
15
Lessons
0
Exercises
~8h
Duration
Data cleaningData validationPivot summariesLine chartsFind & replaceConditional formattingData bars
Start Course

Recommended Prerequisites

spreadsheets fundamentals
1

Trim Whitespace

Remove leading and trailing spaces from text data.

08m
2

Remove Duplicates

Find and remove duplicate rows based on a key column.

010m
3

Split Column by Delimiter

Split a text column into multiple columns using a delimiter.

010m
4

Find and Replace Values

Use find and replace to clean up inconsistent data.

08m