Excel 2002: Level 2

Course Specifications

Course number: 084201
Software: A complete installation of Microsoft Office XP Professional with FrontPage—see the Class Setup Requirements for additional instructions.
Course length: 1.0 day(s)
Certification: Microsoft Office Specialist, Internet and Computing Core Certification (IC3)

Course Description

This course is the second in a three-course series that satisfies the requirements for the Microsoft Office User Specialist (MOUS) certification. This course will expand upon the skills you learned in the Excel 2002Level 1 course and give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration.

Course Objective: You will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web in Excel.

Target Student: Students desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets and charts. In addition, students desiring to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web in Excel.

Prerequisites: To ensure your success, we recommend that you have experience accessing Web pages in a browser. Also, taking the following Element K course or having equivalent knowledge is recommended: Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.


Microsoft: Excel 2002: Level 2 is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Internet and Computing Core Certification (IC3): Excel 2002: Level 2 is one of four Element K courseware titles that address the Module 2 (Key Applications) objectives of the Internet and Computing Core Certification (IC3) program. Modules 1 (Computing Fundamentals) and 3 (Living Online) objectives are addressed in other Element K courseware titles. Certification candidates must pass three exams--one associated with each module--in order to earn IC3 certification.

Hardware Requirements

Platform Requirements

Software Requirements

Performance-Based Objectives

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

Course Content

Lesson 1: Working with Templates
Topic 1A: Create a Workbook from an Excel Template
Topic 1B: Create a Template
Topic 1C: Create a Graphic
Topic 1D: Create a Workbook from a User-defined Template

Lesson 2: Sorting and Filtering Data
Topic 2A: Sort Data
Topic 2B: Add Subtotals to a Worksheet
Topic 2C: Filter Lists
Topic 2D: Create and Apply Custom Filters

Lesson 3: Importing and Exporting Data
Topic 3A: Import Data from the Web
Topic 3B: Import Data from an External Source
Topic 3C: Export Data
Topic 3D: Save a Worksheet as a Web Page
Topic 3E: Publish a Worksheet to the Web

Lesson 4: Working with Advanced Formulas
Topic 4A: Share Data Among Worksheets
Topic 4B: Create a Name for a Range of Cells
Topic 4C: Use Functions to Create Advanced Formulas
Topic 4D: Trace Cell Precedents
Topic 4E: Trace Cell Dependents
Topic 4F: Locate Errors in Formulas

Lesson 5: Analyzing Data
Topic 5A: Create a PivotTable Report
Topic 5B: Create a PivotChart Report
Topic 5C: Create Scenarios
Topic 5D: Use Solver
Topic 5E: Use Goal Seek

Lesson 6: Collaborating
Topic 6A: Insert and Edit a Hyperlink
Topic 6B: Add and Edit Comments in a Worksheet
Topic 6C: Create Discussion Comments
Topic 6D: Respond to Discussion Comments

Appendix A: Microsoft Office Specialist Program

Appendix B: Internet and Computing Core Certification (IC³) Program