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.
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. Expert author Damienne FitzPatrick explains all the essential concepts and techniques in an easy to follow manner, which will help you master MS Excel 97 in the shortest time possible!
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
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
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
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649