Summary

Excel Data Analysis & Charting

This is a 2-hour virtual instructor-led class, and in celebration of our 30th Anniversary, it will be held for $30!

Outline

  • Lesson 1: Working with Lists 

    • Topic A: Sort Data 
    • Topic B: Filter Data 
    • Topic C: Query Data with Database Functions 
    • Topic D: Outline and Subtotal Data 
  • Lesson 2: Analyzing Data 

    • Topic A: Create and Modify Tables
    • Topic B: Apply Intermediate Conditional Formatting
    • Topic C: Apply Advanced Conditional Formatting
  • Lesson 3: Visualizing Data with Charts 

    • Topic A: Create Charts
    • Topic B: Modify and Format Charts
    • Topic C: Use Advanced Chart Features

Course Schedule

*Indicates a course that spans over multiple days.

**Indicates a course that is only a half day.