Lesson 1: Sorting Data

Single-level Sorting
Multiple-level Sorting
Sorting Options
Design Considerations

Lesson 2: Filtering Data

Filtering a List
Custom Criteria
Multiple-condition Criteriav Managing a Filtered List

Lesson 3: Using Pivot Tables

Creating Pivot Tables
Modifying Pivot Tables
Grouping and Summarizing Data in a Pivot Table
Creating Interactive Pivot Tables for the Web
Database Functions

Lesson 4: Creating Charts

Creating a Chart Sheet
Creating an Embedded Chart
Comparing Chart Sheets with Embedded Charts

Lesson 5: Modifying Charts

Chart Types
Modifying Embedded Charts
Adding and Deleting Chart Items
Moving and Sizing Chart Items

Lesson 6: Formatting a Chart

Formatting Chart Text
Formatting Labels
Formatting the Chart
Printing a Chart Sheet

Lesson 7: Using Graphic Objects

Adding Graphic Objects
Formatting Graphic Objects
Using Graphic Objects to Enhance Worksheets and Charts