Using Advanced Functions and Summarizing Data

Using Absolute References and IF Functions

Understanding Absolute vs. Relative Cell References

Understanding IF Functions

Creating IF Statements

Nesting IF Statements

Creating VLOOKUP Formulas

Examining the VLOOKUP Function Syntax

Creating Lookup Tables

Creating Named Ranges

Writing VLOOKUP Formulas

Using ISERROR Functions

Using PivotTable Reports to Summarize Data

Creating PivotTables

Changing the PivotTable Field List View

Adding Fields

Grouping Items

Rearranging Fields

Using Report Filters

Removing Fields

Changing Value Field Settings

Updating PivotTables

Using Data Analysis Tools

Creating Scenarios

Showing Scenarios

Editing Scenarios

Summarizing Scenarios

Using the Subtotal Feature

Outlining Worksheets

Creating Manual Outlines

Showing or Hiding Details

Ungrouping Columns and Rows

Clearing Outlines

Creating Automatic Outlines

Working with Custom Views - 2003 Only

Creating Custom Views

Showing Custom Views

Deleting Custom Views