Excel Windows 97: Transition

Course Code: EXCW97-T
Time: 7 hours
Prerequisites: Windows 95: Introduction
The Basics
Setting Up For Class
The Transition
What Skills should you already have?
Starting Excel 97
Windows 95 Screen Elements
Excel Screen Elements
Moving Around the Workbook
1-2-3 Navigation Keys
Transition File Compatibility
Excel Data Types
Text (Labels)
Values
Pre-Selecting Data Entry Range
Formulas
Basic Formula Entry
Basic Function Entry
SUM() Function
AutoSum
Controlling AutoSum
Multiple AutoSums
Natural Language Formulas
Undo
Redo

Worksheet Mechanics
Moving Data
The Fill Handle
Editing Formulas - The Range Finder
Formatting the Worksheet
Number Formats
Overflow Markers #########
The Formatting Toolbar
Alignment
Merging Cells
Merge and Center
Fonts
Borders
Patterns
Adding and Deleting Rows, Columns, or Sheets
Print Features
Print Preview
Page Setup
Page Settings
Page Break Preview
Header/Footer Tab
Sheet Tab
The Collapse Dialog Button
Manual Page Breaks
Margin Tab
Printing a Specific Page

Neat Stuff
AutoCorrect
AutoComplete
AutoCalculate
Controlling AutoCalculate
Cell Comments
We’re Out of Here!!

Return to Course Listing | Home Page