|
|
|
|
|
|
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
Now that you have completed the first two levels of Excel 2002, you are ready to continue on to the third level. You already know the basic and some advanced operations in Excel, now you will learn even more.
Course Objectives
You will customize your workbook, work with multiple data sources, and collaborate with others using shared workbooks. You will also enhance your worksheets using charts and graphic objects.
Prerequisites
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
- Windows 2000 Introduction
- Excel 2002 Level 1
- Excel 2002 Level 2
Target Student
Persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel at the expert level and who already have knowledge of the Microsoft Windows 98 or above operating system, and an intermediate knowledge of Excel 2002.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- customize your workbook by applying conditional formatting,
adding data validation criteria, customizing menus and toolbars, creating
and editing a macro, and grouping and outlining structured data.
- work with multiple workbooks to
create a workspace, consolidate data, link cells, edit links, export Excel
data into XML, import XML data into Excel, and create a Web query.
- collaborate with other Excel users by protecting your workbook,
sharing your workbook, setting revision tracking, merging multiple copies
of the same workbook, and tracking changes.
- chart non-adjacent data, modify chart items, and create
a trendline.
- use multiple graphic objects to enhance your worksheet.
Certification
Excel 2002: Level 3 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.
Delivery Method
Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Customizing
your Workbook
- Topic 1A: Apply Conditional Formatting
- Topic 1B: Add Data
Validation Criteria
- Topic 1C: Customize Menus
- Topic 1D: Customize
Toolbars
- Topic 1E: Create a
Macro
- Topic 1F: Edit a Macro
- Topic 1G: Group and
Outline Structured Data
Lesson 2: Working
with Multiple Data Sources
- Topic 2A: Create a
Workspace
- Topic 2B: Consolidate
Data
- Topic 2C: Link Cells
in Different Workbooks
- Topic 2D: Edit Links
- Topic 2E: Export Excel Data as XML
- Topic 2F: Import XML Data into Excel
- Topic 2G: Create a Web Query
Lesson 3: Collaborating
with Others Using Workbooks
- Topic 3A: Protect
your Worksheets
- Topic 3B: Protect
Your Workbook
- Topic 3C: Share Your
Workbook
- Topic 3D: Set Revision
Tracking
- Topic 3E: Merge Workbooks
- Topic 3F: Track Changes
Lesson 4: Enhancing
Your Worksheet Using Charts
- Topic 4A: Chart Non-adjacent Data
- Topic 4B: Modify Chart
Items
- Topic 4C: Create a Trendline
Lesson 5: Using Graphic
Objects to Enhance your Worksheets
- Topic 5A: Create Graphic Objects
- Topic 5B: Resize, Move, and Copy Graphic Objects
- Topic 5C: Change the
Order of Graphic Objects
- Topic 5D: Group Graphic
Objects
- Topic 5E: Format Graphic
Objects
- Topic 5F: Insert Clip
Art
- Topic 5G: Modify Clip Art
Appendix A: Microsoft
Office Specialist 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.
- 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 floppy-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 sound card.
Software Requirements
- A custom installation of Microsoft Office XP Professional—see
the Class Setup Requirements for additional instructions.
|
|
|
|
|
