Microsoft Excel 2003 Advanced Guide

By the end of this Excel 2003 advanced course you will be able to use PivotTables to summarise and analyse data; use a collection of data management tools and functions to extract data from large data lists; import and export data to and from Excel and record and execute Excel macros.

Don't forget the end of guide quiz to test what you have learnt

Auditing Worksheets

Data Validation

Validate a Worksheet

Tracing Formulas

Formula Errors

Data Management

Subtotal

Advanced Filter

Database Functions

Using Excel Lists

Converting Text to Columns

Joining Cell Data

PivotTables and PivotCharts

Creating a PivotTable

Specifying PivotTable Data

Changing a PivotTables Calculation

Updating a PivotTable

Sorting and filtering a PivotTable

Grouping PivotTable data

Formatting a PivotTable

PivotTable options

Creating a PivotChart

What If Analysis

Goal Seek

Data Tables

Using Scenarios

Solver

Excel 2003 Macros

Record a Macro

Assign a Macro to a Button

Relative References in Macros

Macro Security

Email Stumble

Guides