|
Title: | Excel 4.0
| Code: | EX40.W
| | Number of Pages: | 166
| | Cost: | $24.95 Canadian Funds (Shipping and Handling not included)
| | Estimated Time to Complete: | 12 hours
| | Practice Exercises: | No
| | Review Exercises: | Yes
| | Summary of Features: | Yes
| | Exercise Disk: | Yes
| | Review/Exam: | No |
|
Module 1: Introduction
Elements of a Document Window
Menu Bar
Toolbar
Formula Bar
Dialog Boxes
Help
Exiting Excel 4.0
Module 2: Create a Worksheet
Cell Identification Number
Active Cell
Cell Movement Keys
Entering Different Types of Data
Text Entries
Numbers, Date/Time
AutoSum
Clearing the Screen
Module 3: Save and Print a Worksheet
Saving a Document
Print Preview/Print
Opening New Document Window
Displaying Open Windows
Switching Documents
Closing Document Window
Module 4: Edit a Worksheet
Opening a Document
Overwriting a Document
Go To
Erasing/Replacing/Editing Contents of a Cell
Inserting/Deleting Rows/Columns
Deleting a File
Selecting Cells/Rows/Worksheet
Erasing Selected Cells
Clearing Cell Contents
Undo
Changing Column Width
Best Fit
Module 5: Cell Formatting
Adding Attributes
Text Alignment
Rotating Data
Changing Font
Shading Cells
Adding Borders
Wrapping Text
Vertical Row Alignment
Justifying Text
AutoFormat
Copying Formatting
Clearing Formatting
Module 6: Number/Date/Time Formatting
Number Formats
Scientific Notation
Fractions
Currency
Percent
Date, Time
Module 7: Page Setup
Changing Margins
Centering Pages Vertically/Horizontally
Changing Paper Orientation/Size
Inserting a Page Break
Adding Row and Column Headings
Adding Headers and Footers
Print to Fit
Module 8: Move/Copy
Moving Cell Contents
Copying Cell Contents
AutoFill
Data Series
Module 9: Formulas
Entering Formulas
Changing Precedence
Cell References
Displaying Formulas
AutoFill
Module 10: Charts
Creating Charts
Moving a Chart
Sizing a Chart
Revising a Chart
Removing/Adding Chart Legend
Rotating X-Axis Text
Changing X-Axis Font
Chart Toolbar
Deleting a Chart
Summary
HTML Editing by: [Coastal WebWorks]