Excel 97 - 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 97 advanced training courses.
 

Objectives :

This course provides an Advance level of training

Who should Attend :

Existing Users or those who have attended the Intermediate Course.

Duration :

1 days

Course Content      
 

 USING MACROS

Introduction to Macro Sheets
Function Macros
Command Macros
Macro Command Types
Recording
Assigning

 Using Pivot Tables
     Goal Seeking
     Using the Solver

Reporting with the Scenario Manager
Using the Scenario Manager
View Manager
Using the Report Manager with a Scenario

  Future Projections with Moving Averages
     Linear Regression & Series

         Future Prediction with Trend
         Trend with All Numeric Data
         Predicated Value Range Exceeds Input Data