Microsoft Excel 2000 Level 2

Creating charts

Creating a chart sheet
Creating an embedded chart
Comparing chart sheets with embedded charts

Modifying charts

Chart types
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items

Formatting a chart

Formatting chart text
Formatting labels
Formatting the chart
Printing a chart sheet

Using graphic objects

Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts

Sorting data

Single-level sorting
Multiple-level sorting
Sorting options
Design considerations

Filtering data

Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list

top of page

Class Information

Duration: 1 day

Prerequisite: Microsoft Excel 2000 Level 1 or equivalent experience.

Course Materials: Course manual (074201S3 - Excel 2000: Charting And Organizing Data)

Description: Students will learn the skills and concepts necessary to create and modify charts, and to use the list-management capabilities of Excel 2000.