Tutorials and Online Training Videos

Microsoft Excel 97 Tutorial


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.

Introduction to Excel

Play Me First
Getting Started
Interface
Save
Simple Printing
Close & Exit
Get Help
Office Assistant

The Basics

Selection Techniques
Enter Data
Edit & Delete Data
Cut, Copy & Paste
Drag & Drop
Undo & Redo
The Fill Handle
AutoCorrect
Spelling
Find & Replace

Worksheet Controls

Navigate A Document
Zoom Control
Insert Cells
Delete Cells
Resize Rows & Columns
Hide & Unhide
Insert & Delete Worksheets
Move & Copy Worksheets
Views
Splits & Panes

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


Related Books on Microsoft Excel 97







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts