Advanced Functions

Absolute vs. Relative

IF Statements

LookUp

VLookUp

HLookUp

Data Validation

Conditional Formatting

List Functionality

Forms

AutoFilter

Sort

Criteria

Advanced Filter

Unique Records

Additional Tools

Paste Options

Comments

Naming Ranges

Styles

Hide Options

Window Panes/Freeze

Subtotals

Introduction to Pivot Tables and Charts

Enhanced Format Tools

Drawing Toolbar

ClipArt

WordArt

Importing Pictures

Charts

Creating by Wizard

Creating by Keyboard

Chart Types

Amending/displaying Data

Chart Options

Combination Charts

Colour & Design

Printing

Margins

Landscape

Headers & Footers

Print Titles

Print Comments

Auditing

Precedents & Dependents

Auditing Toolbar