Excel 2002 (XP): Level 2

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 Objectives

You will 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 course or having equivalent knowledge is recommended:

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. Performance-Based Objectives

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.

Certification

Microsoft

Excel 2002: Level 2 is one of a series of 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 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 courseware titles. Certification candidates must pass three exams--one associated with each module--in order to earn IC3 certification.

Delivery Method

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

Course duration

1 Day(s) Course outline

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 ProgramAppendix B: Internet and Computing Core Certification (IC³) Program Platform Requirements

The Windows platform.

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.

Software Requirements

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

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.