Microsoft Excel 2002: Level 3

Revision: TE1312_20060318

Course Length:

1 Day

Course Description:

Students will customize their workbooks, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using charts and graphic objects.

Who Should Attend:

The target student for this course is a user who has worked with personal computers and used Windows to manage information, run programs, access the Web, and who has a working knowledge of Excel 2002.

Benefits of Attendance:

Upon 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.

Prerequisites:

Students should have taken Windows 2000: Introduction, Excel 2002: Level 1, and Excel 2002: Level 2.

Course Outline:

• Chapter 1: Customizing Your Workbook
  1. Applying Conditional Formatting
  2. Adding Data Validation Criteria
  3. Customizing Menus
  4. Customizing Toolbars
  5. Creating a Macro
  6. Editing a Macro
  7. Grouping and Outlining Structured Data
• Chapter 2: Working With Multiple Data Sources
  1. Creating a Workspace
  2. Consolidating Data
  3. Linking Cells in Different Workbooks
  4. Editing Links
  5. Exporting Excel Data as XML
  6. Importing XML Data in Excel
  7. Create a Web Query
• Chapter 3: Collaborating With Others Using Workbooks
  1. Protecting Your Worksheets
  2. Protecting Your Workbook
  3. Protecting Your Workbook
  4. Setting Revision Tracking
  5. Merging Workbooks
  6. Tracking Changes
• Chapter 4: Enhancing Your Worksheet Using Charts
  1. Charting Non-adjacent Data
  2. Modifying Chart Items
  3. Creating a Trend Line
• Chapter 5: Using Graphic Objects To Enhance Your Worksheet
  1. Creating Graphic Objects
  2. Resizing, Moving, and Copying Graphic Objects
  3. Changing the Order of Graphic Objects
  4. Grouping Graphic Objects
  5. Formatting Graphic Objects
  6. Inserting Clip Art
  7. Modifying Clip Art