2 Microsoft Excel Intermediate 2003, XP or 2000 1 Day Training Course

£ 175.00 

Course Outline

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