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.