- Home /
- Excel 2002 (XP): Level 3
Product Description
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
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:
Excel 2002: Level 3
Course Specifications
Course number: 084202Software: 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
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