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

HTML Editing by: James Lepard, ELM Computer Consulting (June/2002)