Advanced Excel


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


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 Multiple Worksheets and Workbooks
  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
Using Lookup Functions and Formula Auditing
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
Sharing and Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
Automating Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
Creating Sparklines and Mapping Data
  • Create Sparklines
  • Mapping Data
Forecasting Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Audience: All
Pre-Requisites: Introduction to Excel, Intermediate 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