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