Microsoft Excel 2002: Level 2

Revision: TE1311_20060318

Course Length:

1 Day

Course Description:

Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.

Who Should Attend:

The target student for this course is a user who has worked with Excel and has experience creating basic worksheets and charts.

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Use Excel and user-defined templates to create templates and workbooks.
• Use a variety of techniques to sort and filter data.
• Reuse and share data by importing and exporting.
• Use various functions and auditing features to create advanced formulas and audit worksheets.
• Use PivotTable reports, PivotChart reports, and other analysis tools to analyze data.
• Use Web features and comments to collaborate with others.

Prerequisites:

Students should have taken Excel 2002: Level 1.

Course Outline:

• Chapter 1: Working With Templates
  1. Create a Workbook from an Excel Template
  2. Create a Template
  3. Create a Graphic
  4. Create a Workbook from a User-Defined Template
• Chapter 2: Sorting And Filtering Data
  1. Sort Data
  2. Add Subtotals to a Worksheet
  3. Filter Lists
  4. Create and Apply Custom Filters
• Chapter 3: Importing And Exporting Data
  1. Import Data from the Web
  2. Import Data from an External Source
  3. Export Data
  4. Save a Worksheet as a Web Page
  5. Publish a Worksheet to the Web
• Chapter 4: Working With Advanced Formulas
  1. Share Data Among Worksheets
  2. Create a Name for a Range of Cells
  3. Use Functions to Create Advanced Formulas
  4. Trace Cell Precedents
  5. Trace Cell Dependents
  6. Locate Errors in Formulas
• Chapter 5: Analyzing Data
  1. Create a PivotTable Report
  2. Create a PivotChart Report
  3. Create Scenarios
  4. Use Solver
  5. Use Goal Seek
• Chapter 6: Collaborating
  1. Insert and Edit a Hyperlink
  2. Add and Edit Comments in a Worksheet
  3. Create Discussion Comments
  4. Respond to Discussion Comments