:: Site Search
Excel 2000 - 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 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
 
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 courses available!

* Group Excel 2000 - 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