Excel 2000 - Advanced Training

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

Useful Links:
Online Tutorial
Microsoft Excel Home Page
(Amazon) Excel Books

Contact us for Last minute offers on this Course!

Excel 2000 - Advanced Training

Name:*

Contact Number:*

E-mail Address:

Type Your Message:

Type the digits you see in the picture below.

* 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]