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.

Auditing Worksheets

Data Validation

Validate a Worksheet

Tracing Formulas

Formula Errors

Data Management


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


Excel 2003 Macros

Record a Macro

Assign a Macro to a Button

Relative References in Macros

Macro Security

Follow us on

Facebook  Twitter  You Tube