|
Excel
2000: Intermediate
Prerequisites: Excel
2000 - Introduction or equivalent knowledge
Lesson 1: Creating charts
- Creating a chart sheet
- Creating an embedded chart
- Comparing chart sheets with
embedded charts
Lesson 2: Modifying charts
- Chart types
- Modifying embedded charts
- Adding and deleting chart items
- Moving and sizing chart items
Lesson 3: Formatting a chart
- Formatting chart text
- Formatting labels
- Formatting the chart
- Printing a chart sheet
Lesson 4: Using graphic objects
- Adding graphic objects
- Formatting graphic objects
- Using graphic objects to enhance
worksheets and charts
Lesson 5: Sorting data
- Single-level sorting
- Multiple-level sorting
- Sorting options
- Design considerations
Lesson 6: Filtering data
- Filtering a list
- Custom criteria
- Multiple-condition criteria
- Managing a filtered list
|
