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 ExcelPlay Me FirstGetting StartedInterfaceSaveSimple PrintingClose && ExitGet HelpOffice AssistantThe BasicsSelection TechniquesEnter DataEdit && Delete DataCut, Copy && PasteDrag && DropUndo && RedoThe Fill HandleAutoCorrectSpellingFind && ReplaceWorksheet ControlsNavigate A DocumentZoom ControlInsert CellsDelete CellsResize Rows && ColumnsHide && UnhideInsert && Delete WorksheetsMove && Copy WorksheetsViewsSplits && PanesText && Number FormatsText Formats
Align && Text Wrap
Special Alignment Effects
Borders && Shading
Number Formats
Date && Time Formats
Custom Formats
Format Painter
AutoFormat
Conditional Formats
Styles
Simple Calculations && FunctionsBasic Formulae
Operators
Relative References
Absolute References
Sum Function
The Function Wizard
If, And, Or
Nested Ifs
Lookup
V && H Lookup
Trends
Analyses && DatabasesGoal 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 TechniquesCustom 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
ChartsChart Data
Create a Chart
Chart Palette
Text && Data Labels
Axes && Gridlines
Chart && Plot Area
The Legend
Edit The Series
Custom Charts
GraphicsInsert 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
Click here to find out more about the Microsoft Excel 97 Training CD