Microsoft Excel 97

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