Excel 97 - Intermediate Training Print E-mail

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
Contact us for Last minute offers on this Course!
Excel 97 - Intermediate Training
 
Name:*
Contact Number:*
E-mail Address:
Type Your Message:
Type the digits you see in the picture below.




* This course can be tailored to meet your
exact requirement!

* One-to-One Excel 97 - Intermediate Training courses available!

* Group Excel 97 - Intermediate Training courses available at discount prices!


[Back to list]
Latest Information
Computer Generated Solutions (New York)
It gives me great pleasure to write a letter of recommendation f...
Read more...
Our Work with the London Metropolitan University
Bobby, we were very pleased with the success of our recent away ...
Read more...
What Credit Crunch
As soon as the Credit Crunch took hold Keystar training saw the ...
Read more...
What A surprise
February 2011 A recent delegate was more than surprised when at...
Read more...
What a difference
September 2011 After taking the Minutes at my company's meetings...
Read more...
Time Management Training
Once again Keystar has been contacted by the press, on this occa...
Read more...