|
Title: | Excel 5.0
| Code: | EX50.W
| | Number of Pages: | 168
| | Cost: | $24.95 Canadian Funds (Shipping and Handling not included)
| | Estimated Time to Complete: | 12 hours
| | Practice Exercises: | Yes
| | Review Exercises: | Yes
| | Summary of Features: | Yes
| | Exercise Disk: | Yes
| | Review/Exam: | No |
|
Module 1: Introduction
Elements of a Document Window
Menu Bar, Standard Toolbar
Formatting Toolbar
Formula Bar
Dialog Boxes
Help
TipWizard
Closing Document Window
Exiting Excel 5.0/Windows
Module 2: Create a Worksheet
Cell Identification Number
Active Cell
Cell Movement Keys
Go To
Types of Data
AutoSum
Saving a Workbook
Module 3: Access/Print Multiple Worksheets
Opening New Workbook
Displaying Open Windows
Switching Workbooks
Closing a Workbook
Print Preview, Printing a Worksheet
Module 4: Edit a Workbook
Opening a Workbook
Erasing/Replacing/Editing a Cell
Selecting Cell(s)/Row(s)/Column(s)
Undo
Inserting Row(s)/Column(s)/Worksheet
Renaming a Worksheet
Deleting Row(s)/Column(s)/File(s)
Deleting a Worksheet
Hiding Row(s)/Column(s)
Freezing Row(s)/Column(s)
Setting Column Width, AutoFit
Spelling
Module 5: Cell Formatting
Bold, Italic, Underline
Font
Superscript, Subscript
Text Alignment
Copying Formatting
Clearing Formatting
Module 6: Special Effects
Rotating Data
Wrapping Text
Vertical Row Alignment
Justifying Text
Shade/Color/Patterns
Color Text
Adding Borders
AutoFormat
Module 7: Number/Date/Time Formatting
Number Formats
Scientific Notation
Fractions
Currency
Percent
Date, Time
Module 8: Page Setup
Changing Margins
Centering Pages Vertically/Horizontally
Changing Paper Orientation, Size
Inserting a Page Break
Adding Row and Column Headings/Titles
Adding Headers and Footers
Printing Grid Lines
Force Print
Module 9: Move/Copy
Moving Data
Copying Data
Moving Worksheets
Copying Worksheets
Copying Formatting
Grouping Worksheets
AutoFill
Fill Patterns
Creating Custom Lists
Fill Series: Linear, Growth, Date
Module 10: Formulas
Operators
Entering formulas
Changing Precedence
Cell References
Error Messages
Displaying Formulas
Functions, Function Wizard
AutoFill to Copy Formula
Module 11: Charts
Charting Data, Labels
Moving Charts
Sizing Charts
Editing Charts
Adding Chart/Axes Titles
Adding Data Values/Labels
Removing/Adding Chart Legend
Rotating Axis Text
Adding/Removing Grid Lines
Changing Item Colors
Changing Data Range
Changing Chart Type
Deleting Chart
Summary
HTML Editing by: [Coastal WebWorks]