Page 10 - Exceloutline

Microsoft Excel Level 3
Course Outline

Auditing Worksheets
This module explains how to audit worksheets.

� Tracing Precedents
� Tracing Dependents
� Showing Formulas
� Using Formulas That Span Multiple Worksheets

Data Tools What-If Analyses
This module explains how to work with data tools.

� Converting Text to Columns
� Data Validation
� Consolidating Data
� Goal Seek
� Creating Scenarios
� Use the Scenario Manager
� Utilize the Watch Window
� Consolidate Data
� Data Input tables
� Solver

Protection
This module explains how to Protect Worksheets and Workbooks in
Excel.

� Protecting Worksheets and Workbooks

henitectraining@aol.com