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 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
| Homepage | Company Profile | About the Authors | List of Dos Manuals | List of Windows Manuals | Overview of Training Manuals | Order Information and Form |