ELM Computer Consulting |
| Title: | Excel 97 |
| Code: | EX97.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 97 Excel 97 Screen Elements of a Document Window Menu Bar Standard Toolbar Formatting Toolbar Formula Bar Dialog Boxes Help Menu - Index - Contents Office Assistant Tipwizard Close Document Window Reset Menus and Toolbars Exit Excel 97 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 - Save in New Folder 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 Range of Pages - Print Multiple Worksheets Exercises 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(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 Workbooks(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 Page Break Print 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 Exercises Module 9: Move/Copy Move Data - Insert Cut Data - 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 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 Autosum Autofill Error Messages Display Formulas Functions - Function Wizard Exercises Module 11: Charts Introduction Chart Data Chart Labels Chartwizard Move a Chart Size a Chart Chart/Axes Titles - Add Title - Edit Title - Change Font or Font Size - Move Titles - Delete Titles Data Values/Labels - Data and Label Font Change Data Series Remove/Add Chart Legend - Move Chart Legend - Change Font/Font Size of Chart Legend - Resize Chart Legend Show Data Table Axis Text - Change Font/Font Size of Axis Text - Rotate Axis Text Add/Remove Grid Lines Change Colors Change Data Range Change Chart Type Delete a Chart Exercises Summary
