alphabyte - IT and Training Consultants

Course Outline

Course:

Excel 2003 Intermediate

Duration:

1 day

Objectives:

This course is designed to improve the skills of existing Excel users.  By the end of the course delegates should be able to compile work with large and complex spreadsheets.

Pre-Requisites:

Delegates must be familiar with the use of Windows and have a basic understanding of Excel.

Topics:

bullet

Working with large worksheets
bullet

Viewing options

bullet

Hiding/displaying data

bullet

Printing large worksheets

bullet

Multiple worksheets and workbooks
bullet

Linking worksheets using 3-D formulas

bullet

Data Consolidation
bullet

Consolidating data across worksheets

bullet

Consolidating data across workbooks

bullet

Advanced Formatting
bullet

Rotating and Indenting

bullet

Styles

bullet

Custom formats

bullet

Conditional formatting

bullet

Formulae
bullet

Lookups

bullet

Logical statements

bullet

Text functions

bullet

Using IF & SUMIF

bullet

Using absolute references

bullet

Date & Time Functions

bullet

Documenting and Auditing
bullet

Comments and text boxes

bullet

Auditing features

bullet

Collaborating with a workgroup
bullet

Protection

bullet

Using templates

bullet

Creating and managing templates

bullet

Naming cells and ranges

bullet

Sharing workbooks

bullet

Managing changes

bullet

Merging a shared workbook

 

Download Printer-Friendly copy (Word Format)

 
 
Proprietor: Kathy Jarvis
alphabyte, 19 Leigh Drive, Wickham Bishops, Essex CM8 3JS
Tel/Fax: 01621 892336  Mobile: 07710 534128  email: kathy@alphabyte.co.uk