Excel Intermediate
Course length: 1 day
Prerequisites: Excel Introduction or equivalent knowledge.
Overview: You will learn the skills and concepts necessary to create charts
and to use the list-management capabilities of Excel.
Course content
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
Return to Courses