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

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