:: Site Search
Excel 2002 XP - Advanced 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
 
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 courses available!

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


[Back to list]
 
  more...



  more...
New Courses
01 Feb 2007
New Courses Keystar Training are pleased to inform both our exi...

More About Letter Writing
24 Jul 2006
It's strange that for a long time you never hear of something an...

BBC Interview
21 Jul 2006
I am pleased to announce that at 3.30pm this afternoon 21st July...

Public Speaking
19 May 2006
After several enquiries for courses on Public Speaking and not b...

 

Go To Top
 
Tel: +44 (0) 208 559 8097 || Fax: +44 (0) 208 501 4903|| © 2005 Keystar Training. All Rights Reserved.
Powered by
e-IT Solutions (UK)
www.eits.info