ELM Computer Consulting |
| Title: | Excel 97 - Level 2 |
| Code: | EX97-2.W |
| Number of Pages: | 190 |
| Cost: | $24.95 Canadian Funds (Shipping and Handling not included) |
| Estimated Time to Complete: | 15-18 hours |
| Practice Exercises: | No |
| Review Exercises: | Yes |
| Summary of Level 1: | Yes |
| Exercise Disk: | Yes |
| Review/Exam: | No |
Summary of Level 1 Auditing Precedents - Trace Precedents in a Different Worksheet/Workbook Dependents - Trace Dependents in a Different Worksheet/Workbook Value Error Remove Arrows Auditing Toolbar Autocorrect Add Autocorrect Words Exceptions Delete Autocorrect Words Automatic Subtotals Display Subtotals Remove Subtotals Comments Display Comments Print Comments Edit Comment Resize Comment Box Move Comment Box Hide Comments Delete Comment Conditional Formatting Cell Conditional Format - Cell References - Text References - Multiple Conditions - Create Cell Conditional Formatting Formula Conditional Format Copy Conditional Formatting Remove Conditional Formatting Custom Number Formats Format Symbols Add Text To Numbers Set Color Attribute Format Positive and Negative Numbers, Zero and Text Suppress Zero Entries Select Custom Format Edit Custom Format Delete Custom Format Customized View Create Custom View Select Custom View Delete Custom View Data Form Options Error Message Data Map Create Data Map Map Toolbar Format Label or Text Format Legend Shade Options Value Symbol Pie Charts and Bar Charts Additional Map Features Custom Pins Save Map Template - Delete Map Template Resize Map Move Map Delete Map Filter Autofilter - List Highest/Lowest Values - Redisplay All Records - Customized Filter Remove Filter Buttons Advanced Filter - Edit Advanced Filter Forms Add Controls - Check Box - Options Buttons - List Box - Drop-Down List Box Delete a Control Control Sample Functions Sum Average Max Min If - Nested Functions Goal Seek Hyperlink Create Hyperlink Advance to Hyperlink Remove Hyperlink Linking Cells Protect Cells Unlink Cell Lookup Tables Vertical Lookup Tables Horizontal Lookup Tables Macros Record Macro Run a Macro - Micro Virus Prompt Add/Change Shortcut Key or Description Add Macro to Toolbar - Remove Macro from Toolbar Edit Macro Delete Macro Outline Automatic Outline Manual Outline Hide Details Display Details Display Levels - Suppress Details - Expand Details Remove Outline Pivot Tables Examples Of Pivot Tables Pivot Table Toolbar Pivot Table Functions Refresh Data Change Formatting in Pivot Table Protect Cells Protect Cells from Changes - Remove Cell Protection from Worksheet Protect Workbook from Changes - Remove Cell Protection from Workbook Access Error - Password to Open - Password to Modify - Remove Password Protection from Workbook Range Names Name Cell(S) Create Range Name - Apply Range Names - Error Message Label Range Scenarios Create Scenario Display Scenario Edit Scenario Summary Report Delete Scenarios Sort Define Single Sort Criteria Define Multiple Sort Criteria Sort Columns Horizontally Sort by Months, Days or Custom Lists - Sort Columns Horizontally Styles Create a Style - Create Style from Example Apply a Style Style List Box - Create New Style - Apply Style Modify Style Delete a Style Copy Style from Another Workbook Templates Select a Template Create Template Modify Template Autotemplate Toolbars Display Toolbar Move Toolbar Create Toolbar Customize Toolbar Rename Toolbar Delete Toolbar Track Changes User Name Track Changes to a Document Display Changes Next Time Workbook is Opened Accept or Reject Changes Resolve Conflicts Show History of Changes Merge Workbooks Update Values in Same Cell Validate Data Set Validation Rule Input Message Error Alert List Of Values Remove Validation Rule Worksheet Background Remove Background
