Microsoft Excel 97 Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Excel 97 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Introduction to Excel
- Play Me First Demo
- Getting Started Demo
- Interface Demo
- Save Demo
- Simple Printing Demo
- Close & Exit Demo
- Get Help Demo
- Office Assistant Demo
The Basics
- Selection Techniques Demo
- Enter Data Demo
- Edit & Delete Data Demo
- Cut, Copy & Paste Demo
- Drag & Drop Demo
- Undo & Redo Demo
- The Fill Handle Demo
- AutoCorrect Demo
- Spelling Demo
- Find & Replace Demo
Worksheet Controls
- Navigate A Document Demo
- Zoom Control Demo
- Insert Cells Demo
- Delete Cells Demo
- Resize Rows & Columns Demo
- Hide & Unhide Demo
- Insert & Delete Worksheets Demo
- Move & Copy Worksheets Demo
- Views Demo
- Splits & Panes Demo
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
If you would like to own this Microsoft Excel training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
After you have completed a tutorial, a
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.