Excel 2000 - 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 Excel 2000 Advanced training courses.

Objectives: This course provides an Advanced level of training.

Who should Attend: Existing Users or those who have attended the Intermediate Course.

Duration: 1 day

 

Course Content

 

  DATA COSOLIDATION

By Physical Layout
By Category

  USING FINANCIAL FUNCTIONS

PMT Function
FV Function
Financial Analysis Table

  WORKING WITH TEXT STRINGS

Concatenating Labels
Text Functions
Proper, Lower, Upper Functions

  USING PIVOT TABLES

  BACKSOLVING

Using Goal Seek
Using Solver

  SCENARIOS

Reporting with the Scenario Manager
Using the Scenario Manager

  VIEW & REPORT MANAGERS

Using View Manager (Custom Views)
Using the Report Manager with a Scenario

  INTRODUCTION TO VISUAL BASIC

Recording Macros
User defined Functions
The Visual Basic editor
Assigning macros to buttons

 

Contact us for Last minute offers on this course!
Excel 2000 - 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 2000 - Advanced Training courses available!

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


[Back to list]
Latest Articles
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...