Here is an excellent Free Advanced Excel 2003 Training Manual,
from microsofttrainingcourses.co.uk. This training document is 155
pages in length, the zipped download size
is 1.1mb, and the resulting doc file size is 9.8mb. Advanced
Excel features and functionality covered by this Excel training manual
include: Conditional & Logical Functions, Lookup Functions, Goal
Seeking And Solving, Views and Scenarios, Reports, Manage Lists,
Advanced Filtering, Pivot Tables, Charting, Templates, Auditing,
Validation Circles, Precendents And Dependants, and Comments. For
step-by-step instructions for each Excel command demonstrated, look for
the hand icon.
Table Of Contents of Advanced Excel 2003 Training Manual:
Introduction
How To Use This Guide
Section 1
Using Advanced Worksheet Functions
Using Names
Conditional & Logical Functions
If Statementsh
And, Or, Not
Lookup Functions
Vector Lookup
Hlookup
Vlookup
Nested Lookups
Goal Seeking And Solving
Solver
Section 2
Views, Scenarios & Reports
Views & Scenarios
Custom Views
Scenario Manager
Print Reports
Section 3
Using Excel To Manage Lists
Excel Lists
Sorting Data
Adding Subtotals To A List
Filtering A List
Data Form
Advanced Filtering
Copying Filtered Data
Database Functions
Pivot Tables
Modifying A Pivot Table
Grouping Pivot Table Items
Section 4
Excel Charts
Chartwizard
Moving And Resizing Embedded Charts
Chart Types
Formatting Charts
Format Chart Elements
Manipulating Chart Data
Chart, Edit Series
Swapping The X And Y Axes
Using Charts To Change Data
Section 5
Templates
Custom Templates
Autotemplates
Opening And Editing Templates
Template Properties
Section 6
Auditing
Tracers
Comments
Validation Circles
Go To Special
Precendents And Dependants
Comments