Excel 2000 Day 5

Creating/Revising PivotTables

Creating a PivotTable Report

Adding PivotTable Report Fields

Selecting a Page Field Item

Refreshing a PivotTable Report

Changing the Summary Function

Adding New Fields to a PivotTable Report

Moving PivotTable Report Fields

Hiding and Unhiding Items

Deleting PivotTable Report Fields

Creating a Page Field Report

Formatting a PivotTable Report

Creating a PivotChart Report

Creating Interactive PivotTables - Web

Adding Fields to a PivotTable - Browser

Creating/Revising PivotTables

Using Advanced Functions

Using Lookup Functions

Using the VLOOKUP Function

Using the HLOOKUP Function

Using the IF Function

Using Nested IF Functions

Using the ISERROR Function

Using an AND Condition with IF

Using an OR Condition with IF

Using the ROUND Function

Limiting the Precision of Numbers

Using Advanced Functions

Using Scenarios and Goal Seeking

Using the Scenario Manager

Creating a Scenario

Displaying a Scenario

Editing a Scenario

Creating a Scenario Summary Report

Using Goal Seek

Using Scenarios and Goal Seeking

Using Data Tables

Using Data Tables

Placing Formulas in Data Tables

Creating a One-Variable Table

Creating a Two-Variable Table

Using Data Tables

Using Auditing Tools

Displaying the Auditing Toolbar

Displaying/Removing Dependent Arrows

Displaying/Removing Precedent Arrows

Removing Tracer Arrows

Tracing Cells Causing Errors

Using Auditing Tools

Solving Problems

Using Solver

Saving a Solution as a Scenario

Restoring the Original Values

Changing a Constraint

Creating a Solver Report

Using Scenarios to View Solutions

Solving Problems

Working with Views

Using Views

Creating a Normal View

Creating a Custom View

Displaying a View

Deleting a View

Working with Views

Using the Report Manager

Working with the Report Manager

Using Sheets in a Report

Printing a Report

Using Scenarios and Views in a Report

Reordering Sections in a Report

Using the Report Manager