Attention: this is very old content, revived mostly for historical interest.
Many of the pages on this site
are still useful, but please bear in mind that they may be out of date. (Especially, do not try to use contact information, phone numbers, etc.
found on these pages unless you couldn't find anything more recent.)
See here for more information.
ELM Computer Consulting |
| 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
| Homepage | Company Profile | About the Authors | List of Dos Manuals | List of Windows Manuals | Overview of Training Manuals | Order Information and Form |