Intermediate Excel


Wednesday, December 4, 2019, 9:30am to 4:30pm

Repeats every month on the 21 of January until Tue Jan 21 2020


Center for Workplace Development, 124 Mt. Auburn Street, Cambridge

This is a course outline. If time permits, all topics listed may be covered.


Working with Functions
  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
Working with Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features
Analyzing Data with PivotTables and PivotCharts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers
Audience: All
Pre-Requisites: Introduction to Excel
Software Version: Microsoft Office 2016
Cost: $180.00
Late Drop/Cancel Fee: $180.00

Please email with all technical questions or issues and direct class content and logistics questions to
Learn more and register on the Harvard Training Portal. Find class information here.