Excel 2002 (XP): Level 2

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 (IC³)

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:

• Excel 2002 Level 1

Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

Certification

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 (IC³): 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 (IC³) 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 IC³ certification.

Hardware Requirements

• A Pentium 133 MHz or higher processor required for all operating systems.
• A minimum of 64 MB of RAM, recommended, for Windows 2000 Professional; in addition, you should have 8 MB of RAM for each application running simultaneously. (Note: Memory requirements may differ for other operating systems.)
• A minimum of 516 MB of free hard-disk space. (Under Windows 2000, at least 4 MB of space must be available in the Registry.)
• Either a local CD-ROM drive or access to a networked CD-ROM drive.
• A 3.5”-disk drive.
• A two-button mouse, an IntelliMouse, or compatible pointing device.
• A VGA or higher-resolution monitor; Super VGA recommended.
• An installed printer driver.
• A 9600 baud modem or higher. An Internet connection with access to the World Wide Web is necessary to complete some tasks throughout the book. (Note: Internet access may require payment of a separate fee to a service provider; local charges may also apply).
• Access to a discussion server if you want to complete the activities in the “Create Discussion Comments” and “Respond to Discussion Comments” topics.

Platform Requirements

• The Windows platform.

Software Requirements

• A complete installation of Microsoft Office XP Professional with FrontPage—see the Class Setup Requirements for additional instructions.

Performance-Based Objectives

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

• use Excel templates and user-defined templates to create templates and workbooks.
• use a variety of techniques to sort and filter data.
• re-use and share data by importing and exporting and saving to the Web.
• use various functions and auditing features to create advanced formulas and audit worksheets.
• use PivotTables, PivotCharts, and other analysis tools to analyze data.
• use Web features and comments to collaborate with others.

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