Excel 97 - Intermediate

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 intermediate training courses.
 

Objectives :

This course provides an Intermediate level of training

Who should Attend :

Existing users or delegates who have attended the introduction course. .

Duration :

1 days

Course Content      
 

 ADVANCED PRINTING
       Page Break View
       Printing Titles
       Page Set-Up

 PROTECTION
       Cell Protection
       Worksheet Protection

 NAMING RANGES IN FORMULAS
       Creating named Ranges
       Using named Ranges

 CUSTOM FORMATS, STYLES &
     TEMPLATES
       Dates, Text, Numbers
       Styles
       Templates

 USING LISTS (DATABASES)
       Creating a basic Database List
       Using the Data Form
       Sorting data
       Filtering Data
       Using Subtotals
       Introduction to Pivot Tables

 LINKING
       Using Multiple Sheets
       Linking Mulitple Files
       Working with Linked Files
       Editing Links
       Consolodating Data

 ADVANCED CHARTING TECHNIQUES
       Editing a Data Series
       Enhancing Charts with Graphics
       Creating & Editing a Pictograph

 ADVANCED FUNCTIONS
       Using the IF Function
       Using Lookup Tables and the VLOOKUP
       Function