Introduction to Data Validation: Spreadsheets for Analysis | EdLight Code

Spreadsheets for AnalysisIntroduction to Data Validation

5 / 15In progressIn progress

Spreadsheets for Analysis

Course Progress0/15

1

Cleaning Data

Trim Whitespace
Remove Duplicates
Split Column with Formulas
Find and Replace Values

2

Data Validation

Introduction to Data Validation
Fix Invalid Status Values
Fix Out-of-Range Ratings

3

Formula-based Summaries

Create Monthly Revenue Summary
Calculate Average by Region

4

Trends & Analysis

Choosing the Right Chart Type
Revenue Trend Analysis

5

Conditional Formatting

Introduction to Conditional Formatting
Highlight Large Expenses
Color-Code Status Values
Format Progress Indicators

Spreadsheets for Analysis

Course Progress0/15

1

Cleaning Data

Trim Whitespace
Remove Duplicates
Split Column with Formulas
Find and Replace Values

2

Data Validation

Introduction to Data Validation
Fix Invalid Status Values
Fix Out-of-Range Ratings

3

Formula-based Summaries

Create Monthly Revenue Summary
Calculate Average by Region

4

Trends & Analysis

Choosing the Right Chart Type
Revenue Trend Analysis

5

Conditional Formatting

Introduction to Conditional Formatting
Highlight Large Expenses
Color-Code Status Values
Format Progress Indicators

Loading lesson…

Loading lesson…