Databases

Database Functions

Sorting Data

Custom Filters

Advanced Filtering

Filter to Another Location

Unique Values

Outlining

Automatic Outlining

Manual Outlining

Subtotals

Data Consolidation

Pivot Tables

Creating a Pivot Table

PivotTable Toolbar

Managing Pivot Table

Grouping Items

Pivot Charts

Goal Seek

Solver

External Data

Import External Data

Web Queries

Database Queries

Templates

Creating a Workbook Template

Templates Folder

XLStart Folder

Advanced Charting Features

AutoFormats

Adding & Deleting Chart Data

Trend Lines

Combination Charts

Picture Charts

Changing Values

Scenario Manager

Creating a Scenario

Editing a Scenario

Summaries

Merging Scenarios

Introduction to Macros

Recording Basic Macros

Running Macros

Assigning Macros to a Toolbar Button