Microsoft Excel 2002 Level 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Excel 2002 Level 1 or equivalent experience. |
| Course Materials: | Course manual (084201S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web in Excel. |
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