|
Title: | Excel 2000 - Level 1
|
| Code: | EX2-1.W
|
| Number of Pages: | 180
|
| 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 2000
Excel 2000 Screen
Elements of a Document Window
Menu Bar
Dialog Boxes
Standard and Formatting Toolbars
- Hide/Display Standard and Formatting Toolbar
- Display Standard and Formatting Toolbars on Separate Rows
Formula Bar
- Hide/Display Formula Bar
Help
- Office Assistant
- Index
- Help Toolbar
- Dialog Box Help
- TipWizard
Close Document Window
Reset Menus and Toolbars
Exit Excel 2000
Exit Windows 95
Exercises
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
Change System Default Drive
Automatic Backup
- Autosave Add-In
Exercises
Module 3: Access/Print Multiple Workbooks
Create New Workbook/File
- Advance To New Worksheet
Display Open Workbooks
- Cascade/Tile Open Workbooks
Switch Worksheets
Workspace
Close a Workbook
- Close Multiple Workbooks
Print Preview
Print
- Standard Toolbar
- Print Multiple Worksheets
Exercises
Module 4: Edit a Workbook
Open a Workbook
- View Options
- File List
- History Folder
- Favorites Folder
- 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(s)
- Select Column(s)
- 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(s)
Delete Workbook(s)
Hide Row(s) or Column(s)
Freeze Row(s) or Column(s)
Column Width
- Change Column Width
- Autofit
- Default Standard Width
Spelling
Save (Replace)
Exercises
Module 5: Cell Formatting
Attributes
- Bold, Italic, Underline
- Double And Accounting Underline
- Strikethrough
- Superscript/Subscript
Font
- Font Box
Selecting Characters in a Cell
Alignment
- Align Left, Center and Align Right in a Cell
- Center Across Selection
- Fill
Copy Formatting
Clear Formatting
Exercises
Module 6: Special Effects
Rotate Data
Wrap Text/Shrink to Fit
Merge Cells
Vertical Row Alignment
Justify Text
Shade/Color/Patterns
- Formatting Toolbar
Color Text
- Formatting Toolbar
Border
Autoformat
Exercises
Module 7: Number/Date/Time Formatting
Numbers
- Comma Style
- Decimal Places
Scientific Notation
Fractions
Currency
- Currency Style
Percent
- Percent Style
Date
Time
Exercises
Module 8: Page Setup
Introduction
Margins
Center Pages Vertically/Horizontally
Paper Orientation
Paper Size
Page Break
- Page Break Preview
- Remove Manual Page Break
Print Row and Column Headings
Print Row and Column Titles
Print Area
Headers and Footers
- Customized Headers and Footers
- Change Header/Footer Margins
Turn Off Grid Lines
Force Print
- Change Print Percentage
- Fit to Specified Number of Pages
Exercises
Module 9: Move/Copy
Move Data
- Drag and Drop
Move Worksheet
- Drag and Drop
Copy Data
- Drag and Drop
Office Clipboard
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
Exercises
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
Display Sum, Average or Count
Autofill
Error Messages
Display Formulas
Functions
- Function Wizard
Exercises
Module 11: Charts
Introduction
Chart Data
Chart Labels
Chartwizard
Chart Toolbar
Move a Chart
Size a Chart
Change Chart Type
Delete a Chart
Exercises
Summary
HTML Editing by: James Lepard, ELM Computer Consulting (August/99)