|
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
HTML Editing by: James Lepard, ELM Computer Consulting (June/2002)