Course Length: 1 day
Prerequisites: None
Certification:
Product code:

 

 

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

Appendix A: Querying data

• Database functions
• External databases and queries
• Excel 2000 and the Internet