Microsoft Excel: Part III
$202/Attendee
Cost
Program Length
2 Days
Course Overview
Course Outline
Working with Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data
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
Using Lookup Functions and Formula Auditing
Use Lookup Functions
Trace Cells
Watch and Evaluate Formulas
Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecast Data Trends
Creating Sparklines and Mapping Data
Create Sparklines
Map Data
For cancellation notices received more than fifteen business days prior to the class date, students may receive either a full refund or reschedule into another class date.
For cancellation notice less than fifteen business days prior to the class start date, students will receive an voucher in the amount of the paid tuition to use for the same course up to a six months’ time frame and will be automatically put onto the wait list of the course of their choice and granted final admission ten business days prior to class start day based on enrollment levels.