Pivot Tables

What is a Pivot Table?

Pivot Table Definitions

Creating a Pivot Table

Managing Pivot Tables

Adjusting the Information in a Pivot Table

Page Fields

Grouping Row and Column Fields

Changing How Information is Displayed

Changing the Summary Calculations

Updating Data and Pivot Tables

Formatting Pivot Tables

 

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

 

Scenario Manager

What is Scenario Manager?

Comparing Scenarios with Scenario Manager

Defining the Scenarios

Creating a Summary Report

Goal Seek

What is Goal Seek?

Using Goal Seek to Achieve Your Target Figures

 

Solver

What is Solver?

Using the Solver Tool to Get the Best Results

 

Protecting and Hiding Information

Protecting Cells

Turning On Protection

Turning Off Protection

Hiding Information

 

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

 

Working with Interactive Excel Web Documents

Saving Excel WorkSheets as Web Documents

Spreadsheet Web Components