alphabyte - IT and Training Consultants

Course Outline

Course:

Excel 2003 Advanced

Duration:

1 day

Objectives:

This course is designed to introduce existing Excel users to the uses of Excel as a database and for “what if” analysis.  By the end of the course delegates should be able to compile work with and analyse large and complex spreadsheets.

Pre-Requisites:

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

Topics:

bullet

Data Management
bullet

Creating lists

bullet

Sorting and filtering lists

bullet

Advanced filtering

bullet

Subtotals

bullet

Importing & Exporting Data
bullet

Importing data

bullet

Exporting data

bullet

Pivot Tables & Pivot Charts
bullet

Using the pivot table wizard

bullet

Modifying the pivot table

bullet

Creating a pivot chart

bullet

What if Analysis
bullet

Using Goal Seek

bullet

Using Solver

bullet

Scenarios and the Scenario Manager

bullet

Data Validation

bullet

Using the data validation feature

bullet

Finding invalid data

bullet

Advanced Output Features
bullet

Custom Views

bullet

Report Manager

bullet

Customizing Excel
bullet

Changing options

bullet

Customizing toolbars and menus

bullet

Macros
bullet

Introduction to Macros

bullet

Recording a Macro

bullet

Running a macro from a button, keystroke or a menu

 

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