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: 
•	Windows 2000 Introduction 
•	Excel 2002 Level 1 
•	Excel 2002 Level 2 
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
•	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. 
Platform Requirements
•	Windows.
Software Requirements
•	A custom installation of Microsoft Office XP Professional—see the Class Setup Requirements for additional instructions. 
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.
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