Foundation
- Introduction
- What is a Data Analyst?
- The role of a Data Analyst
- The characteristics of a Data Analyst
- Thinking like a Data Analyst
- Analyst Role Models
- Module 1 Quiz
Tools
- Introduction
- An Introduction to Excel
- Formatting in Excel
- Copying & pasting in Excel
- Sorting Data in Excel
- Naming cells and ranges in Excel
- Removing duplicate data in Excel
- Setting the print area
- Basic Excel formulas
- Module 2: Quiz #1
Formulas
- Excel Shortcuts
- Intermediate Excel
- Intermediate Formulas
- If Statements
- Sum If Formula
- Count if Formula
- Nested If Statements: If or
- Nested If Statements: If and
- Look-up formulas
- Hands-on with look-up formulas
Data Aggregation
- Introduction to Pivot Tables
- Hands-on with Pivot Tables
- Get Pivot Formula
- Hands-on with Get Pivot
