Tracks/Spreadsheets (Excel/Google Sheets)/Spreadsheets for Analysis
Intermediate
5 modules · ~8h

Spreadsheets for Analysis

Clean messy data, validate values, create formula summaries, analyze trends, and format professional reports.

5 modules15 lessons~8h
Data cleaningData validationSUMIF / AVERAGEIFTrend analysisFind & replaceConditional formattingProfessional formatting
Start course

Recommended prerequisites

Spreadsheets Fundamentals
Content

Course modules

1

Trim Whitespace

Remove leading and trailing spaces from text data.

2

Remove Duplicates

Find and remove duplicate rows based on a key column.

3

Split Column with Formulas

Use LEFT, RIGHT, and FIND formulas to split a name column.

4

Find and Replace Values

Replace abbreviated codes with full descriptive values.