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