Excel 2002 XP - Advanced Training Print E-mail

All our training courses can be designed to suit your company's needs. Take a look at all the different features that separate us from other XP Excel 2002 Advanced training courses.

Objectives - Delegates will acquire the necessary skills to becomeproductive in the chosen package at the desired level.

Duration: 1 day

 

Course Content

 

  Data Consolidation

Topic A: By Physical Layout or Category
Topic B: Consolidation using a Pivot Table

  Using Financial Functions

Topic A: PMT Function
Topic B: FV Function

  Working with Text Strings

Topic A: Concatenating Labels
Topic B: Text Functions

  Reports, Views and Scenarios

Topic A: Report Manager
Topic B: View Manager
Topic C: Scenario Manager
Topic D: Using the Report Manager with Views and Scenarios

  Histograms, Moving Averages & Trends

Topic A: Histograms
Topic B: Moving Averages
Topic C: Trends

  Using Macros

Topic A: Command Macros
Topic B: Recording Command Macros
Topic C: Assigning
Topic D: Introduction to Macro Sheets
Topic E: Function Macros

  Using Pivot Tables

  Goal Seeking

  Using the Solver

Contact us for Last minute offers on this course!
Excel 2002 XP - Advanced Training
 
Name:*
Contact Number:*
E-mail Address:
Type Your Message:



* This course can be tailored to meet your
exact requirement!

* One-to-One Excel 2002 XP - Advanced Training courses available!

* Group Excel 2002 XP - Advanced Training courses available at discount prices!


[Back to list]
Latest Articles
Chairing Meetings
The trainer was truly inspirational using his wide experience t...
Read more...
Managing young people’s behavior
Keystar delivered a days training in managing young people&rsqu...
Read more...
Team Building
Read more...
Interview Training
Proud father says thank you for the help you gave to my son Timo...
Read more...
Team Building
Wednesday 11th November 2009 Garry Mitchell does it again, this...
Read more...
Keystar Goes International
Keystar are pleased to advise that it has now gone international...
Read more...