Data & Spreadsheets Basics

Course Overview

Data & Spreadsheets Basics builds practical, job-ready skills with short lessons and hands-on tasks.

What you’ll learn

  • Clean and organize data tables
  • Use formulas (SUM, AVERAGE, IF, VLOOKUP/XLOOKUP)
  • Create charts and pivot tables
  • Export and share insights safely

Time needed

~4 hours total

Course Content

Data Cleaning & Types
3 Topics
Sheet Setup
Find & Replace Patterns
Basic Validation
Formulas & Functions
3 Topics
Relative vs Absolute
IF & Nested Logic
Lookups (XLOOKUP/VLOOKUP)
Charts & Pivot Tables
3 Topics
Chart Basics
Pivot Table Setup
Visual Clean?up