Excel 2000 - Advanced
 

All our training courses can be tailored to suit your company's needs.
Take a look at all the features that set us apart 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 days

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