COURSE OUTLINE

Working With Multiple Worksheets and Workbooks
Use Links and External References
Use 3-D References
Consolidate Data

Using Lookup Formulas 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
Map Data

Forecasting Data
Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Forecasting Data Trends