PRODUCT INFO

Product Guarantee

Testimonials

MAIN LINKS

Multi User Training CDs

	This Week's Special Offer NEW TITLE DISCOUNT!
Adobe Fireworks CS4 Tutorial

Quicktime is required for the movies, click here to download if needed.
Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality. Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials Please do not hesitate to contact us for download help.

Microsoft Excel 97 Tutorial

Professionally created, self-study video training.

About this Tutorial

show details

If you really want to get to grips with this powerful spreadsheet application then you might like to take a look at this beginners Microsoft Excel 97 tutorial. Using step by step video training movies, expert author Damienne FitzPatrick explains all the essential tools, concepts and techniques in an easy to follow manner, which will help you master MS Excel 97 in the shortest time possible! Click any of the blue linked lessons below for FREE MS Excel tutorials...

hide details

Try this training now - See below for FREE tutorials

LATER VERSIONS AVAILABLE

View the more recent
Microsoft Excel 2007 Tutorial

Or, see our complete range of
Microsoft Excel Tutorials

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on all Orders

Microsoft Excel 97 Tutorial Info
	CLICK HERE TO BUY THIS CD
Tutor: Damienne FitzPatrick
Duration: 11 hrs / 96 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33033
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world IN STOCK - All CDs Shipped Carriage FREE -
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9

Benefits of this Software Training

Tuition by expert tutors.

Narrated training videos demonstrate the key tools and techniques

Simplistic terms and minimal jargon.

Step by step video training from your own desktop via CD ROM or online tuition.

The tutor transfers knowledge to you quickly and effectively.

All the concepts of each application are explained clearly and precisely.

Every course works on PC and Mac.

Alternative to a boring book or manual and expensive training courses & classes.

Jump to and from lessons - learn at your own pace.

The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials

CD CONTENTS & FREE VIDEO TUTORIALS

Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Intro to Microsoft Excel 97 Tutorial

Saving

Using the Office Assistant

Excel Fundamentals

Selection Techniques Explained

Entering Data

Editing and Deleting Data

Cut, Copy and Paste

Dragging and Dropping

Undo and Redo

The Fill Handle

Using AutoCorrect

Spelling

Find and Replace

Worksheet Controls

Navigating A Document

Using the Zoom Control

Inserting Cells

Deleting Cells

Resize Rows and Columns

Hide and Unhide

Inserting and Deleting Worksheets

Moving and Copying Worksheets

Views in Excel

Splits and Panes

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Text & Number Formats
Chapter Overview
Aligning and Text Wrap
Alignment Effects in Excel
Borders and Shading
Number Formats
Date and Time Formats
Custom Formats in Excel
Using the Format Painter
AutoFormat
Conditional Formats
Working with Styles

Simple Calculations & Functions
Simple Formulae
Operators
Relative and Absolute References - Lesson 1
Relative and Absolute References - Lesson 2
Sum Function
The Function Wizard
If, And, Or
Nested Ifs Explained
Lookup
V and H Lookup
Trends

Analyses & Databases
Goal Seek
One-Input and Two-Input Tables
Scenarios and Scenario Summaries
Pivot Tables
Creating A Database
Sort and Filter Data
Advanced Filtering
Setting Criteria
Database Functions

Optimising Techniques
Custom Lists
Pasting Special
Naming Cells & Ranges
Linking
Consolidation
Automatic Subtotals
Validating
Outline
Protecting Cells
Print Preview
Applying Headers and Footers
Printing Areas
How to Customise Toolbars in Excel
Creating A VBA Macro
Editing A Macro

Charts
Chapter Overview
Creating a Chart
Chart Palette
Text and Data Labels
Axes and Gridlines Explained
Chart and Plot Area
The Legend in Excel
Editing The Series
Custom Charts

Graphics in Excel
Inserting A Picture
Resize and Reposition
Creating a Graphic
Shapes , Fills, Borders and Effects
Lines - Colours, Sizes and Arrows
Select, Layer and Group
Snapping To and Flip
Applying Text to Drawings
WordArt
Organisation Chart


[ Home \| Video Training CDs/DVD \| Site Map \| Resources \| Specialist Categories \| Specialist Categories 2 ]
UK & Europe Marrutt Software Training Bellbrook Industrial Estate Uckfield, East Sussex, TN22 1QL United Kingdom UK Tel: +44 (0) 1825 764057 UK Fax: +44 (0) 1825 768841	US & Canada Marrutt Software Training 244 5th Ave # 1877 New York, NY 10001 United States US Tel: 646-736-7932 US Fax: 646-895-7649