Microsoft Excel 2002 Level 2
Working with Templates
Create a Workbook from an Excel Template
Create a Template
Create a Graphic
Create a Workbook from a User-defined Template
Sorting and Filtering Data
Sort Data
Add Subtotals to a Worksheet
Filter Lists
Create and Apply Custom Filters
Importing and Exporting Data
Import Data from the Web
Import Data from an External Source
Export Data
Save a Worksheet as a Web Page
Publish a Worksheet to the Web
Working with Advanced Formulas
Share Data Among Worksheets
Create a Name for a Range of Cells
Use Functions to Create Advanced Formulas
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Analyzing Data
Create a PivotTable Report
Create a PivotChart Report
Create Scenarios
Use Solver
Use Goal Seek
Collaborating
Insert and Edit a Hyperlink
Add and Edit Comments in a Worksheet
Create Discussion Comments
Respond to Discussion Comments
Class Information
Duration: 1 day
Prerequisite: Microsoft Excel 2002 Level 1 or equivalent experience.
Course Materials: Course manual (084201S3)
Description: Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web in Excel.