Excel 2002 Advanced training course - learn Excel

Using Graphic Objects to Enhance Your Worksheet

Create Graphic Objects
Resize, Move and Copy Graphic Objects
Change the Order of Graphic Objects.
Group Graphic Objects
Format Graphic Objects
Insert clip art
Modify clipart

Importing and Exporting Data

Import Data from the Web
Import Data from an External Source
Export Data
Save a Worksheet as a Web Page
Publish a Worksheet to the Web

Working with multiple Data Sources

Create a Workspace
Consolidate Data
Link Cells in Different Work books
Edit Links
Export Excel Data as XML
Import XML Data into Excel
Create a Web Query

Working with Advanced Formulas

Create Advanced Formulas
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas

Analyzing Data

Create Scenarios
Use Solver
Use Goal Seek
Report Manager

Protecting and Sharing your Data

Protect Worksheets
Protect Workbook
Share Your Workbook
Set Revision Tracking
Merge Workbooks
Track Changes

Introduction to macros

Running a macro
Editing a Macro

Overview

Students will learn advanced techniques for analysing and manipulating data, work with multiple data sources, collaborate with other users, and enhance their spreadsheets using graphic objects.

Prerequisites

Excel 2002 Intermediate, or equivalent knowledge.

Benefits

Students will learn how to add graphics to a worksheet or chart, perform advanced operations on data, create advanced formulas, link files, and record macros.

Target student

Students should be familiar with Excel formulas and functions and basic data operations.

What's next

For those wishing to create and edit custom macros and gain an understanding of VBA code, Excel 2002 VBA Programming is the next course in the series.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates	1	2	3	4	5	6	Extra Person
At our Reading Training Centre	£495	£545	£595	£645	£695	£745	£50
On your premises	£445	£495	£545	£595	£645	£695	£50

For on-site courses only:

Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.