Pivot Tables
What is a Pivot Table?
Pivot Table Definitions
Creating a Pivot Table
Managing Pivot Tables
Adjusting the Information in a Pivot Table
Multi-Layered Pivot Tables
Filtering a Pivot Table
Pivot Charts

Data Forms
What is a Data Form?
Viewing Records with a Data Form
Deleting Records with a Data Form
Adding New Records with a Data Form
Changing Records with a Data Form
Finding Specific Records with a Data Form

Data Tables
What is a Data Table?
Using Data Tables for Forecasting
Creating a One Input Data Table
Creating a Two Input Data Table

Scenarios
Creaing a Scenario
Managing Scenarios
Creating a Summary Report

Goal Seek
What is Goal Seek?
Using Goal Seek to Achieve Your Target Figures
Goal Seeking with Complex Equations

Solver
What is Solver?
Defining a Problem in Solver
Using the Solver Tool to Get the Best Results

Sharing Workbooks
Inserting Comments
Tracking Changes
Understanding the Change Log
Highlighting Changes
Accepting and Rejecting Changes
Sharing a WorkBook
Opening a Shared WorkBook
Saving Changes to a Shared WorkBook
Resolving Conflicts

Protecting and Hiding Information
Protecting Cells
Turning On Protection
Turning Off Protection
Hiding Information

Data Validation
Understanding Data Validation
Input Messages
Error Alerts
Using Lists

Macros
What is a Macro?
Recording a Macro
Running a Macro
Personal Macro Workbook
Adding a Macro to a Toolbar
Excels Visual Basic Programming Language

Web Queries
Undestanding Web Queries
Creating a Web Query