Intermediate Excel

Date: 

Tuesday, January 21, 2020, 9:30am to 4:30pm

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

Location: 

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 trainingportalhelp@harvard.edu with all technical questions or issues and direct class content and logistics questions to training@harvard.edu.
 
Learn more and register on the Harvard Training Portal. Find class information here.