Spreadsheets for Analysis

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

Modules

Lessons

Exercises

~8h

Duration

Data cleaningData validationSUMIF / AVERAGEIFTrend analysisFind & replaceConditional formattingProfessional formatting

Remove leading and trailing spaces from text data.

Find and remove duplicate rows based on a key column.

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

Replace abbreviated codes with full descriptive values.