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.
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 (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
- 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
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