Advanced Functions

Absolute Cell Addresses

Conditional Functions including:-

IF Statements

LookUp

VLookUp

HLookUp

Data Validation

Formatting

List Functionality

Forms

Criteria, Record count

Sorting Options

Filtering Options including:-

AutoFilter

Advanced Filter

Copy to another Location

Additional Tools

Paste Options

Working with Sheets

Comments

Smart Tags Overview

Hyperlinks

Worksheet Protection

Track Changes

Create & Define Names

Creating Styles

Hiding Columns, Data, Comments

Editing Data Entries, Cell Contents, Formulae

Subtotals

Enhanced Format Tools

Date Formats

Number Formats

Text Alignment

Indenting Lists

Drawing Toolbar

Clear:

Data, Formats Comments

All Graphics:

Clip Art, WordArt, Importing Pictures, enhancing Worksheet/Cell appearance

Compare side by side

Advanced Data Manipulation Tools

Linking:

Cells, Worksheets, Workbooks

Updating Links

Charts

Customising:-

Type, Data, Titles, Legend, Labels

Manipulation of Data

Creating a Combination Chart

Customising

Toolbars

Screen view options

Excel options

All printing options

Auditing

Precedents and Dependants

Auditing Toolbar