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 XP - Level 2 |
| Code: | ExcelXP-1.W |
| Number of Pages: | 164 |
| Cost: | $27.95 Canadian Funds (S/H, tax included) |
| Estimated Time to Complete: | 15-18 hours |
| Practice Exercises: | No |
| Review Exercises: | Yes |
| Summary of Features: | Level 1 |
| Exercise Disk: | Yes |
| Review/Exam: | No |
SUMMARY OF LEVEL 1 AUDITING PRECEDENTS DEPENDENTS VALUE ERROR FORMULA AUDITING TOOLBAR AUTOMATIC SUBTOTALS DISPLAY/SUPPRESS DETAIL REMOVE SUBTOTALS CHARTS CREATE CHART EDIT CHART DATA CHANGE AREA TO BE CHARTED MOVE CHART SIZE A CHART ADD/EDIT CHART AND AXIS TITLES CHART TOOLBAR CHANGE SERIES COLORS - Gradient Fill Effect - Texture Fill Effect - Pattern Fill Effect - Picture Fill Effect ROTATE LABEL TEXT FONT CHANGE CHART TYPE CHANGE CHART/PLOT AREA BACKGROUND COLOR DELETE CHART COMMENTS CREATE COMMENT DISPLAY/HIDE COMMENT REVIEWING TOOLBAR MOVE COMMENT BOX PRINT COMMENT RESIZE COMMENT BOX EDIT COMMENT REMOVE A COMMENT CONDITIONAL FORMATTING ADD CONDITIONAL FORMAT FORMULA CONDITIONAL FORMAT COMPARE TEXT REMOVE CONDITIONAL FORMAT CUSTOM NUMBER FORMATS FORMAT SYMBOLS ADD TEXT TO NUMBERS CREATE CUSTOM NUMBER FORMAT SELECT CUSTOM FORMAT SET COLOR ATTRIBUTE POSITIVE AND NEGATIVE NUMBERS, ZERO AND TEXT SUPPRESS ZERO ENTRIES EDIT CUSTOM FORMAT REMOVE CUSTOM FORMAT DATA FORM OPTIONS DISPLAY SPECIFIC RECORD SPECIFY CRITERIA ERROR MESSAGE FILTER CREATE AUTOFILTER REDISPLAY ALL RECORDS DISPLAY HIGHEST/LOWEST VALUES CUSTOMIZED FILTER REMOVE FILTER BUTTONS FUNCTIONS SUM AVERAGE MAX MIN IF - Nested IF Functions LINK CELLS UNLINK CELL LOCK CELLS REMOVE CELL PROTECTION PROTECT WORKBOOK - Remove Password Protection PROTECT WORKBOOK STRUCTURE - Remove Workbook Protection LOOKUP TABLES VERTICAL LOOKUP TABLE HORIZONTAL LOOKUP TABLE MACROS OVERVIEW RECORD MACRO RUN MACRO SAVE PERSONAL MACROS KEYBOARD SHORTCUT KEY - Add Keyboard Shortcut Key - Remove Keyboard Shortcut Key ADD MACRO TO TOOLBAR - Remove Macro from Toolbar EDIT MACRO DELETE MACRO PIVOT TABLES CREATE PIVOT TABLE - Example of Pivot Tables PIVOT TABLE TOOLBAR EDIT DATA SORT SORT BY SINGLE COLUMN SORT BY MULTIPLE COLUMNS SORT COLUMNS HORIZONTALLY SORT BY MONTHS, DAYS OR CUSTOM LIST TEMPLATES CREATE TEMPLATE SELECT TEMPLATE MODIFY TEMPLATE AUTOTEMPLATE TOOLBARS DISPLAY TOOLBAR CREATE TOOLBAR CUSTOMIZE TOOLBAR RESET SYSTEM TOOLBARS DELETE TOOLBAR VALIDATION DATA TYPES SET VALIDATION RULE INPUT MESSAGE ERROR MESSAGE REMOVE VALIDATION
| Homepage | Company Profile | About the Authors | List of Dos Manuals | List of Windows Manuals | Overview of Training Manuals | Order Information and Form |