Contents:

Working with advanced filters

Creating and using a criteria range Using comparison criteria
Using advanced And/Or conditions

Working with named ranges

Creating named ranges
Using the Go To command
Range names in formulae

Importing data

Using Paste Special
Object linking and embedding
Importing a text file

Working with multiple workbooks

Creating custom views
Linking workbooks

Register your interest

Back to course list

Auditing a worksheet

Auditing tools
Data entry validation
Auditing data dependency

Look up and reference functions

Using the LOOKUP function
Using the VLOOKUP function
Using the HLOOKUP function

Pivot tables

Creating and editing pivot tables

Using analysis tools

Goal seek
Using Solver
The Scenario Manager

Printing workbooks and reports
Printing multiple worksheets
Printing multiple workbooks
Using the Report Manager