|
|
|
|
|
|
This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview
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:
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.
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
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.
|
|
|
|
|
