Excel XP/2003: Charting and Organizing Data (Level 2)

Overview: Students 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 numbers
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 97 and the Internet