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 1 |
| 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: | Yes |
| Review Exercises: | Yes |
| Summary of Features: | Yes |
| Exercise Disk: | Yes |
| Review/Exam: | No |
CHAPTER 1. INTRODUCTION TO EXCEL INTRODUCTION OPEN EXCEL XP ELEMENTS OF THE APPLICATION WINDOW WORKSHEET TASK PANE TOOLBARS - Standard Toolbar - Formatting Toolbar HELP - Help Index - Help Toolbar - Definition Terms CLOSE WORKBOOK RESTORE DOCUMENT WINDOW CLOSE EXCEL XP CHAPTER 2. CREATE A WORKBOOK WORKBOOKS CELL IDENTIFICATION NUMBER ACTIVE CELL ENTER DATA GO TO - Name Box TYPES OF DATA - Text - Numbers - Date - Time AUTOSUM SAVE A WORKBOOK SYSTEM DEFAULT FILE LOCATION AUTOMATIC BACKUP CHAPTER 3. MULTIPLE WORKBOOKS AND PRINTING CREATE NEW WORKBOOK ADVANCE TO NEW WORKSHEET LIST OPEN WORKBOOKS DISPLAY ALL OPEN WORKBOOKS PRINT PREVIEW PRINT WORKSHEET CLOSE ALL OPEN WORKBOOKS - Restore Document Window CHAPTER 4. EDIT A WORKBOOK OPEN A WORKBOOK - View Options SELECT - Text in Cell - Cells - Consecutive Range of Cells - Non-Consecutive Range of Cells - Extend - Row(s) - Column(s) - End of Data in Worksheet - Entire Worksheet ERASE CONTENTS OF A CELL REPLACE CONTENTS OF A CELL CLEAR CELL CONTENTS UNDO INSERT BLANK ROW(S) INSERT BLANK COLUMN(S) INSERT BLANK WORKSHEET - Change Default Number of Worksheets DISPLAY NEXT/PREVIOUS WORKSHEET RENAME WORKSHEET DELETE ROW(S) DELETE COLUMN(S) DELETE WORKSHEET(S) HIDE ROW(S) HIDE COLUMN(S) FREEZE ROW(S) OR COLUMN(S) COLUMN WIDTH MOVE DATA - Drag and Drop COPY DATA - Drag and Drop MOVE WORKSHEET COPY WORKSHEET FIND REPLACE SPELLER AUTOCORRECT UPDATE/REPLACE WORKBOOK CHAPTER 5. CHARACTER FORMATTING FONT - Formatting Toolbar CHANGE DEFAULT FONT BOLD AND ITALIC UNDERLINE - Other Underlining FONT COLOR CHARACTER EFFECTS ALIGN DATA IN A CELL CENTER ACROSS SELECTION COPY CHARACTER FORMATTING CLEAR FORMATTING CHAPTER 6. SPECIAL CHARACTER FORMATTING ROTATE CELL CONTENTS WRAP TEXT/SHRINK TO FIT ROW HEIGHT VERTICAL ROW HEIGHT CELL SHADING BORDER LINES COPY FORMATTING AUTOFORMAT - Remove Autoformat CHAPTER 7. FORMATTING NUMBERS AND DATES NEGATIVE NUMBERS FRACTIONS PERCENT COMMA STYLE CURRENCY STYLE DECIMAL PLACES DATE CHAPTER 8. PAGE SETUP PAGE BREAKS MARGINS CENTER PAGES VERTICALLY/HORIZONTALLY PAPER SIZE AND ORIENTATION FIT PAGE PRINT ROW AND COLUMN HEADINGS REPEAT ROW AND COLUMN TITLES HEADERS AND FOOTERS PRINT GRIDLINES CHAPTER 9. SERIES AND CUSTOM LISTS AUTOFILL DATES - Fill Series - Increment by Date Interval CUSTOM LISTS - Delete Custom List CHAPTER 10. FORMULAS AND FUNCTIONS FORMULAS - Relative References - Absolute References - Precedence - Addition and Subtraction - Multiplication and Division - Change Precedence FUNCTIONS - Function List LINK CELLS DISPLAY FORMULAS SUMMARY
| Homepage | Company Profile | About the Authors | List of Dos Manuals | List of Windows Manuals | Overview of Training Manuals | Order Information and Form |