Microsoft Excel 97 Tutorial - Training Videos

Training CDs > Business Tutorial Videos > MICROSOFT EXCEL 97

Affordable Training you can depend on
This Microsoft Excel 97 video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 11 hours long these Microsoft Excel 97 tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Microsoft Excel 97 training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

This Microsoft Excel tutorial video is produced with the older 97 version. Authored by Damienne Fitzpatrick, and teaches by using working examples in conjunction with narrated QuickTime movies. Ideally suited towards the beginner this tutorial starts by covering the absolute basics before moving on to cover more complex issues, users have total control of the pace of the lessons and movies can be rewound, fast – forwarded or stopped at any time. Topics covered on this MS Excel training CD include : Inserting cells, Worksheets, Number formats, Text, Calculations, Formulas, Functions, AutoSum, Linking, Charts, Macros, Graphics and much more.We also have a more current training CD : Microsoft Excel 2007 Tutorial

Microsoft Excel 97 Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

Introduction to Excel

The Basics

Worksheet Controls

Text & Number Formats

Text Formats
Align & Text Wrap
Special Alignment Effects
Borders & Shading
Number Formats
Date & Time Formats
Custom Formats
Format Painter
AutoFormat
Conditional Formats
Styles

Simple Calculations & Functions

Basic Formulae
Operators
Relative References
Absolute References
Sum Function
The Function Wizard
If, And, Or
Nested Ifs
Lookup
V & H Lookup
Trends

Analyses & Databases

Goal Seek
One-Input Tables
Two-Input Tables
Scenarios
Scenario Summaries
Pivot Tables
Create A Database
Sort Data
Filter Data
Advanced Filtering
Set Criteria
Database Functions

Optimizing Techniques

Custom Lists
Paste Special
Name Cells & Ranges
Linking
Consolidation
Automatic Subtotals
Validation
Outlining
Protect Cells
Print Preview
Headers & Footers
Print Areas
Customizing Toolbars
Create A VBA Macro
Edit A Macro

Charts

Chart Data
Create a Chart
Chart Palette
Text & Data Labels
Axes & Gridlines
Chart & Plot Area
The Legend
Edit The Series
Custom Charts

Graphics

Insert A Picture
Resize & Reposition
Create A Graphic
Shapes , Fills, Borders & Effects
Lines - Colors, Sizes & Arrows
Select, Layer & Group
Snap To & Flip
Text In Drawings
WordArt
Organization Chart

Microsoft Excel 97 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Excel 97
Instructor	:	Damienne FitzPatrick
Price	:	US$ 99.95
Duration	:	11 hours - 96 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33033

BENEFITS OF THIS TRAINING COURSE

Master Microsoft Excel 97 in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.