United States Microsoft Excel 97 Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Excel 97
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
With Microsoft Excel 97, you can take advantage of comprehensive tools to easily create spreadsheets. Excel 97 allows you to analyze data with charts and graphs. You can even use automatic formatting to create data-rich spreadsheets. In this tutorial, you are guided from basic thorough advanced techniques by author Damienne Fitzpatrick. She easily explains need-to-know topics such as columns and rows, workbooks and worksheets, basic and advanced formulas, and even how to insert graphics. If you need to know Excel, why not start now? Simply click a topic below.
Choose your media type:
|
Introduction to Excel
|
|||
| Play Me First | (01:19) | ||
| Getting Started | (12:22) | ||
| Interface | (09:42) | ||
| Save | (06:43) | ||
| Simple Printing | (03:28) | ||
| Close & Exit | (03:40) | ||
| Get Help | (11:29) | ||
| Office Assistant | (03:47) | ||
|
The Basics
|
|||
| Selection Techniques | (06:53) | ||
| Enter Data | (08:56) | ||
| Edit & Delete Data | (04:29) | ||
| Cut, Copy & Paste | (10:58) | ||
| Drag & Drop | (06:03) | ||
| Undo & Redo | (06:04) | ||
| The Fill Handle | (11:13) | ||
| AutoCorrect | (05:06) | ||
| Spelling | (02:58) | ||
| Find & Replace | (09:23) | ||
|
Worksheet Controls
|
|||
| Navigate A Document | (05:30) | ||
| Zoom Control | (02:23) | ||
| Insert Cells | (06:28) | ||
| Delete Cells | (02:38) | ||
| Resize Rows & Columns | (05:56) | ||
| Hide & Unhide | (03:13) | ||
| Insert & Delete Worksheets | (05:39) | ||
| Move & Copy Worksheets | (05:18) | ||
| Views | (05:08) | ||
| Splits & Panes | (05:35) | ||
|
Text & Number Formats
|
|||
| Text Formats | (07:03) | ||
| Align & Text Wrap | (09:35) | ||
| Special Alignment Effects | (07:30) | ||
| Borders & Shading | (09:41) | ||
| Number Formats | (09:33) | ||
| Date & Time Formats | (02:53) | ||
| Custom Formats | (09:42) | ||
| Format Painter | (02:24) | ||
| AutoFormat | (02:32) | ||
| Conditional Formats | (03:29) | ||
| Styles | (03:57) | ||
|
Simple Calculations & Functions
|
|||
| Basic Formulae | (10:46) | ||
| Operators | (03:41) | ||
| Relative References | (02:52) | ||
| Absolute References | (10:20) | ||
| Sum Function | (06:30) | ||
| The Function Wizard | (09:59) | ||
| If, And, Or | (11:51) | ||
| Nested Ifs | (13:38) | ||
| Lookup | (04:38) | ||
| V & H Lookup | (07:02) | ||
| Trends | (04:28) | ||
|
Analyses & Databases
|
|||
| Goal Seek | (04:28) | ||
| One-Input Tables | (07:06) | ||
| Two-Input Tables | (04:09) | ||
| Scenarios | (10:01) | ||
| Scenario Summaries | (01:52) | ||
| Pivot Tables | (10:09) | ||
| Create A Database | (09:09) | ||
| Sort Data | (06:53) | ||
| Filter Data | (09:02) | ||
| Advanced Filtering | (07:04) | ||
| Set Criteria | (08:18) | ||
| Database Functions | (07:53) | ||
|
Optimizing Techniques
|
|||
| Custom Lists | (04:14) | ||
| Paste Special | (03:17) | ||
| Name Cells & Ranges | (10:27) | ||
| Linking | (11:37) | ||
| Consolidation | (04:21) | ||
| Automatic Subtotals | (02:58) | ||
| Validation | (04:41) | ||
| Outlining | (12:03) | ||
| Protect Cells | (04:06) | ||
| Print Preview | (10:44) | ||
| Headers & Footers | (08:36) | ||
| Print Areas | (08:38) | ||
| Customizing Toolbars | (09:23) | ||
| Create A VBA Macro | (09:16) | ||
| Edit A Macro | (02:42) | ||
|
Charts
|
|||
| Chart Data | (03:32) | ||
| Create a Chart | (08:45) | ||
| Chart Palette | (05:54) | ||
| Text & Data Labels | (08:23) | ||
| Axes & Gridlines | (07:18) | ||
| Chart & Plot Area | (05:27) | ||
| The Legend | (03:55) | ||
| Edit The Series | (07:59) | ||
| Custom Charts | (04:18) | ||
|
Graphics
|
|||
| Insert A Picture | (07:20) | ||
| Resize & Reposition | (01:53) | ||
| Create A Graphic | (10:36) | ||
| Shapes , Fills, Borders & Effects | (07:15) | ||
| Lines - Colors, Sizes & Arrows | (13:37) | ||
| Select, Layer & Group | (07:45) | ||
| Snap To & Flip | (05:46) | ||
| Text In Drawings | (04:59) | ||
| WordArt | (06:37) | ||
| Organization Chart | (09:48) | ||
Email this Page 
Send us FeedbackCourse Information
| Course: | Microsoft Excel 97 |
| Author: | Damienne FitzPatrick |
| SKU: | 33033 |
| ISBN: | 1889347310 |
| Release Date: | 1996-01-01 |
| Duration: | 11 hrs / 96 tutorials |
| Work Files: |
Yes |
| Captions: | No |
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com's entire library of video tutorials.
If you are already a member, please login here.