Date:
Wednesday, December 4, 2019, 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
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.