Excel 2002: Level 3

Course Specifications

Course number: 084202
Software: A custom installation of Microsoft Office XP Professional—see the Class Setup Requirements for additional instructions.
Course length: 1.0 day(s)
Certification: Microsoft Office Specialist

Course Description

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 Objective: 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.

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.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge: Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

Certification

Excel 2002: Level 3 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.

Hardware Requirements

Platform Requirements

Software Requirements

Performance-Based Objectives

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

Course Content

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