|
Title: | Excel 7.0
|
| Code: | EX70.W
|
| Number of Pages: | 170
|
| Cost: | $24.95 Canadian Funds (Shipping and Handling not included)
|
| Estimated Time to Complete: | 15-18 hours
|
| Practice Exercises: | Yes
|
| Review Exercises: | Yes
|
| Summary of Features: | Yes
|
| Exercise Disk: | Yes
|
| Review/Exam: | No |
Module 1: Introduction
Introduction
The Keyboard
- Typewriter Keyboard
- Function Keys
- Cell Movement Keys/Numeric Key Pad
Using the Mouse
Load Excel 7.0
Excel 7.0 Screen
Elements of a Document Window
Menu Bar
Standard Toolbar
Formatting Toolbar
Formula Bar
Dialog Boxes
Help Menu
- Print Help Information Box
- Context-Sensitive Help
Tipwizard
Close Document Window
Reset Menu Bar
Exit Excel 7.0
Exit Windows 95
Module 2: Create a Workbook
Workbooks (Filename)
Cell Identification Number
Active Cell
Cell Movement Keys
- Using the Mouse
Go To
- Name Box
- Go To Previous Location
Enter Data
- Edit Entry Before Accepting
Types of Data
Text Entries
- Numeric Text
Numbers
- General Format
- Large Numbers
- Negative Numbers
- Fractions
- Currency
- Percent
Date
Time
AutoSum
- Automatic Recalculation
- Autocalculate
Save a Workbook
- Filenames
- Save in New Folder
Change System Default Drive
Automatic Backup
- Autosave Add-In
Module 3: Access/Print Multiple Workbooks
Create New Workbook
- Create New Worksheet
Display Open Workbooks
- Cascade/Tile Open Workbooks
Switch Worksheets
Close a Workbook
- Close Multiple Workbooks
Print Preview
Print
- Standard Toolbar
- Print Range of Pages
- Print Multiple Worksheets
Module 4: Edit a Workbook
Open a Workbook
- File List
- Favorites
- Open Multiple Workbooks
Erase Contents of a Cell
Replace Contents of a Cell
Edit Contents of a Cell
- Insertion Movement Keys
Edit Part of a Cell
Select Cells
Select Row
Select Column
Select To End of Document
Select Entire Worksheet
Erase Selected Cells
Clear Cell Contents
Undo
Insert Blank Row(s)
Insert Blank Column(s)
Insert Blank Worksheet
Rename Worksheet
Delete Row(s) or Column(s)
Delete Worksheet
Delete Workbook(s)
Hide Row(s) or Column(s)
Freeze Row(s) or Column(s)
Column Width
- Change Column Width
- Autofit
- Reset Standard Width
Spelling
Save (Replace)
Module 5: Cell Formatting
Attributes
- Bold and Italic
- Underline
- Single Underline
- Strikethrough
- Superscript/Subscript
Font
- Font Box
Selecting Characters in a Cell
Alignment
- Align Left, Center and Align Right in a Cell
- Center Across Columns
- Fill
Copy Formatting
Clear Formatting
Module 6: Special Effects
Rotate Data
Wrap Text
Vertical Row Alignment
Justify Text
Shade/Color/Patterns
- Formatting Toolbar
Color Text
- Formatting Toolbar
Border
- Remove Borders
AutoFormat
- Remove AutoFormat
Module 7: Number/Date/Time Formatting
Numbers
- Number Style
- Decimal Places
Scientific Notation
Fractions
Currency
- Currency Style
Percent
- Percent Style
Date
Time
Module 8: Page Setup
Introduction
Margins
Center Pages Vertically
Center Pages Horizontally
Paper Orientation
Paper Size
Page Break
- Remove Page Break
Row and Column Headings
Print Row and Column Titles
Headers and Footers
- Customized Headers and Footers
- Change Header/Footer Margins
- Remove Header/Footer
Turn Off Grid Lines
Force Print
- Change Print Percentage
- Fit To Specified Number of Pages
Module 9: Move/Copy
Move Data
- Cut and Insert Paste
- Drag and Drop
Move Worksheet
- Drag and Drop
- Move Worksheet to a Different Workbook
Copy Data
- Copy and Insert Paste
- Drag and Drop
Copy Entire Worksheet
- Drag and Drop
- Copy Worksheet to a Different Workbook
Copy Formatting
Enter Data/Formatting into Multiple Worksheets
Autofill
- Fill Cells
- Fill Patterns
- Preset Fill Patterns
- Create Custom List
Fill Series
- Linear
- Growth
- Date
Module 10: Formulas
Operators
Enter a Formula
- Manual Recalculation
Precedence
- Addition and Subtraction
- Multiplication and Division
- Exponentiation
- Changing Precedence
Cell References
- Relative Cell Reference
- Absolute Cell Reference
Autofill
Error Messages
Display Formulas
Functions
- Function Wizard
Module 11: Charts
Introduction
Chart Data
Chart Labels
ChartWizard
Move a Chart
Size a Chart
Edit Chart Design
Chart/Axes Titles
- Add Titles
- Change Font or Font Size
- Move Titles
- Delete Titles
Data Values/Labels
- Data and Label Font
Remove/Add a Chart Legend
- Move/Resize Legend in a Chart
Rotate Axis Text
Add/Remove Grid Lines
Change Item Colors
Change Data Range
Change Chart Type
Delete a Chart
Summary
HTML Editing by: James Lepard, ELM Computer Consulting (March/98)