Advanced Excel

Date: 

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

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 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 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