Excel Classes: Online or In-Person

We offer live, interactive Excel classes over Zoom. Register for a public open-enrollment workshop, or ask us about private corporate training for groups or individuals.

Woman looking at simple Excel charts and tables

Excel Basics

Syllabus
Enroll

Dates:

  • Wed, Sep 16, 11am - 5:30pm EST
  • Wed, Sep 23, 11am - 5:30pm EST
  • Wed, Sep 30, 11am - 5:30pm EST

Price: $275
Duration: 6 hours
Topics:

  • Online Excel vs. the desktop edition
  • Navigating the Excel interface
  • Adjusting rows and columns
  • Creating formulas that reference specific cells
  • Absolute vs. relative cell references
  • Common functions: sum(), average(), etc.
  • Formatting text, cells, and layout
  • Printing and sharing workbooks
  • Basic chart creation
  • Using templates
  • …and much more!
Woman looking at pie charts and spreadsheets from Excel Intermediate workshop

Excel Intermediate

Syllabus
Enroll

Dates:

  • Thu, Sep 10, 11am - 5:30pm EST
  • Thu, Sep 17, 11am - 5:30pm EST
  • Thu, Sep 24, 11am - 5:30pm EST

Price: $295
Duration: 6 hours
Topics:

  • Sorting and filtering data
  • Conditional formatting
  • Grouping and generating subtotals
  • Referencing data in other workbooks and named ranges
  • Data validation
  • Formatting and adding images
  • Advanced charting
  • Pivot Tables
  • Pivot Charts
  • Collaboration features
  • …and much more!
Man looking at dashboards from Excel Advanced workshop

Excel Advanced

Syllabus
Enroll

Dates:

  • Fri, Sep 11, 11am - 5:30pm EST
  • Fri, Sep 18, 11am - 5:30pm EST
  • Fri, Sep 25, 11am - 5:30pm EST

Price: $345
Duration: 6 hours
Topics:

  • IF(), SUMIF() and other decision functions
  • Auditing and debugging features
  • Date and text functions
  • Array functions
  • Power pivot and external data
  • Exporting data
  • What-if analysis
  • Goal seek and solver
  • Designing forms with macros and VBA code
  • Internationalization and accessibility
  • …and much more!
Scroll to Top