Excel 2002: Level 3

Course Description

Overview: Students will customize thier workbooks, work with multiple data sources, collaborate with other users, enhcance thier spreadsheets using charts and graphic objects.

Prerequisites:

• Windows 2000: Introduction
• Excel 2002: Level 1
• Excel 2002: Level 2

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• apply conditional formatting; add data validation criteria; customize menus and toolbars; and create, edit, and run macros. The student will also view data using the outline.
• create a workspace, consolidate data, view the consolidated data, and link cells.
  
• protect their worksheet, protect their workbook, add and remove file passwords, share their workbooks, set revision tracking, merge workbooks, and track changes.
  
• chart non-adjacent data, modify embedded charts and chart items, and add a trend line to their chart.
  
• create, change the order of, group, move, copy, and format graphic objects. They will also insert and modify clip art.
  

Course Content

Lesson 1: Customizing Your Workbook

Topic 1A: Applying Conditional Formatting

Topic 1B: Adding Data Validation Criteria

Topic 1C: Customizing Menus

Topic 1D: Customizing Toolbars

Topic 1E: Creating a Macro

Topic 1F: Editing a Macros

Topic 1G: Grouping and Outlining Structured Data

Lesson 2: Working with multiple Data Sources

Topic 2A: Creating a Workspace

Topic 2B: Consolidating Data

Topic 2C: Linking Cells in Different Work books

Topic 2D: Editing Links

Topic 2E: Exporting Excel Data as XML

Topic 2F: Importing XML Data into Excel

Topic 2G: Create a Web Query

Lesson 3: Collaborating with Others using Workbooks

Topic 3A: Protecting Your Worksheets

Topic 3B: Protecting Your Workbook

Topic 3C: Sharing Your workbook

Topic 3D: Setting Revision Tracking

Topic 3E: Merging Workbooks

Topic 3F: Tracking Changes

Lesson 4: Enhancing Your Worksheet using Charts

Topic 4A: Charting Non-adjacent Data

Topic 4B: Modifying chart items

Topic 4C: Creating a Trend Line

Lesson 5: Using Graphic Objects to Enhance Your Worksheet

Topic 5A: Creating Graphic Objects

Topic 5B: Resizing, Moving and Copying Graphic Objects

Topic 5C: Changing the Order of Graphic Objects.

Topic 5D: Grouping Graphic Objects

Topic 5E: Formatting Graphic Objects

Topic 5F: Inserting clip art

Topic 5G: Modifying clipart