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