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 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 day
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
|
|
|