Customising Excel

Creating a Custom View

Showing a Custom View

Deleting a Custom View

Customising a Toolbar

Customising a Menu

Creating Toolbar Buttons

Excel Options

Advanced Custom Lists

Workbook Databases

Database Terms

Creating a Database

Sorting Tools & Data

Data Filtering

Custom Autofilters

Advanced Filtering

Outlines, Subtotals & Consolidation

Automatic Outlining

Manual Outlining

Subtotals

Data Consolidation

Pivot Tables

Creating a Pivot Table

PivotTable Toolbar

Managing Pivot Table

Grouping Items

Creating a Chart from a Pivot Table

Goal Seek

Solver

External Data

The Query Toolbar

Creating a Query from Excel

Updating and Modifying Queries

Templates

Creating a WorkBook Template

Templates Folder

XLStart Folder

Advanced Charting Features

AutoFormats

Adding and Deleting Chart data

Trend Lines

Combination Charts

Picture Charts

Changing Values

The 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