Lesson 1: Working with Databases
Defining Database Components
Adding Database Components
Modifying Database Records
Modifying Database Records Using Basic Worksheet Techniques
Using Data Forms to Navigate, Enter, and Edit Records
Using Data Forms to Find Records

Lesson 2: Sorting Database Data
Sorting Records from Top to Bottom
Sorting Field Data from Left to Right
Sorting by Four or More Columns
Specifying Custom Sort Orders

Lesson 3: Using Database Functions
Using the DAVERAGE Function
Using the DCOUNT and DSUM Functions
Using the DMIN and DMAX Functions
Using the VLOOKUP Function

Lesson 4: Using Filters and Queries
Using the AutoFilter Feature
Specifying Single Comparison Criteria
Specifying Custom Criteria
Removing Filters
Using the Advanced Filter Feature
Setting up a Criteria Range
Specifying Multiple Comparison Criteria
Extracting Data
Working with Extracted Data
Querying an External Database
Working with Queried Data

Lesson 5: Using Automated Features
Using the Automatic Subtotals Feature
Inserting Automatic Subtotals
Choosing Multiple Summary Functions
Hiding and Showing Record Detail
Using Conditional Formatting
Using the AutoFormat Feature

Lesson 6: Using PivotTables
Creating PivotTables
Editing PivotTables
Using PivotTable AutoFormat
Changing PivotTable Field Names and Functions
Formatting Numbers in PivotTable Fields

Lesson 7: Modifying PivotTable Data
Deleting PivotTable Data
Displaying and Hiding PivotTable Data
Refreshing PivotTable Data
Sorting PivotTable Data
Using the GETPIVOTDATA Function

Lesson 8: Using Advanced Data Analysis to Audit Worksheets
Tracing Precedents, Dependents, and Errors
Removing Arrows
Finding Cells with Specific Characteristics or Entries
Using the Goal Seek Feature
Using the Solver Feature

Lesson 9: Working with Scenarios
Creating Scenarios
Displaying Scenarios
Editing and Deleting Scenarios
Protecting Scenarios
Creating Scenario Summary Reports

Lesson 10: Creating Reports
Creating Custom Reports
Printing Custom Reports
Creating PivotChart Reports