ELM Computer Consulting


Title: Excel 2000 - Level 1
Code: EX2-1.W
Number of Pages: 180
Cost: $24.95 Canadian Funds (Shipping and Handling not included)
Estimated Time to Complete:15-18 hours
Practice Exercises: Yes
Review Exercises: Yes
Summary of Features: Yes
Exercise Disk: Yes
Review/Exam: No
Module 1:  Introduction
	Introduction
	The Keyboard
	  - Typewriter Keyboard
	  - Function Keys
	  - Cell Movement Keys/Numeric Key Pad
	Using the Mouse
	Load Excel 2000
	Excel 2000 Screen
	Elements of a Document Window
	Menu Bar
	Dialog Boxes
	Standard and Formatting Toolbars
	  - Hide/Display Standard and Formatting Toolbar
	  - Display Standard and Formatting Toolbars on Separate Rows
	Formula Bar
	  - Hide/Display Formula Bar
	Help
	  - Office Assistant
	  - Index
	  - Help Toolbar
	  - Dialog Box Help
	  - TipWizard
	Close Document Window
	Reset Menus and Toolbars
	Exit Excel 2000
	Exit Windows 95
	Exercises

Module 2:  Create a Workbook
	Workbooks (Filename)
	Cell Identification Number
	Active Cell
	Cell Movement Keys
	  - Using the Mouse
	Go To
	  - Name Box
	  - Go to Previous Location
	Enter Data
	  - Edit Entry Before Accepting
	Types Of Data
	Text Entries
	  - Numeric Text
	Numbers
	  - General Format
	  - Large Numbers
	  - Negative Numbers
	  - Fractions
	  - Currency
	  - Percent
	Date
	Time
	Autosum
	  - Automatic Recalculation
	  - Autocalculate
	Save a Workbook
	  - Filenames
	Change System Default Drive
	Automatic Backup
	  - Autosave Add-In
	Exercises

Module 3:  Access/Print Multiple Workbooks
	Create New Workbook/File
	  - Advance To New Worksheet
	Display Open Workbooks
	  - Cascade/Tile Open Workbooks
	Switch Worksheets
	Workspace
	Close a Workbook
	  - Close Multiple Workbooks
	Print Preview
	Print
	  - Standard Toolbar
	  - Print Multiple Worksheets
	Exercises

Module 4:  Edit a Workbook
	Open a Workbook
	  - View Options
	  - File List
	  - History Folder
	  - Favorites Folder
	  - Open Multiple Workbooks
	Erase Contents of a Cell
	Replace Contents of a Cell
	Edit Contents of a Cell
	  - Insertion Movement Keys
	Edit Part of a Cell
	Select Cells
	  - Select Row(s)
	  - Select Column(s)
	  - Select to End of Document
	  - Select Entire Worksheet
	Erase Selected Cells
	Clear Cell Contents
	Undo
	Insert Blank Row(s)
	Insert Blank Column(s)
	Insert Blank Worksheet
	Rename Worksheet
	Delete Row(s) or Column(s)
	Delete Worksheet(s)
	Delete Workbook(s)
	Hide Row(s) or Column(s)
	Freeze Row(s) or Column(s)
	Column Width
	  - Change Column Width
	  - Autofit
	  - Default Standard Width
	Spelling
	Save (Replace)
	Exercises

Module 5:  Cell Formatting
	Attributes
	  - Bold, Italic, Underline
	  - Double And Accounting Underline
	  - Strikethrough
	  - Superscript/Subscript
	Font
	  - Font Box
	Selecting Characters in a Cell
	Alignment
	  - Align Left, Center and Align Right in a Cell
	  - Center Across Selection
	  - Fill
	Copy Formatting
	Clear Formatting
	Exercises

Module 6:  Special Effects
	Rotate Data
	Wrap Text/Shrink to Fit
	Merge Cells
	Vertical Row Alignment
	Justify Text
	Shade/Color/Patterns
	  - Formatting Toolbar
	Color Text
	  - Formatting Toolbar
	Border
	Autoformat
	Exercises

Module 7:  Number/Date/Time Formatting
	Numbers
	  - Comma Style
	  - Decimal Places
	Scientific Notation
	Fractions
	Currency
	  - Currency Style
	Percent
	  - Percent Style
	Date
	Time
	Exercises

Module 8:  Page Setup
	Introduction
	Margins
	Center Pages Vertically/Horizontally
	Paper Orientation
	Paper Size
	Page Break
	  - Page Break Preview
	  - Remove Manual Page Break
	Print Row and Column Headings
	Print Row and Column Titles
	Print Area
	Headers and Footers
	  - Customized Headers and Footers
	  - Change Header/Footer Margins
	Turn Off Grid Lines
	Force Print
	  - Change Print Percentage
	  - Fit to Specified Number of Pages
	Exercises

Module 9:  Move/Copy
	Move Data
	  - Drag and Drop
	Move Worksheet
	  - Drag and Drop
	Copy Data
	  - Drag and Drop
	Office Clipboard
	Copy Entire Worksheet
	  - Drag and Drop
	  - Copy Worksheet to a Different Workbook
	Copy Formatting
	Enter Data/Formatting into Multiple Worksheets
	Autofill
	  - Fill Cells
	  - Fill Patterns
	  - Preset Fill Patterns
	  - Create Custom List
	Fill Series
	  - Linear
	  - Growth
	  - Date
	Exercises

Module 10:  Formulas
	Operators
	Enter a Formula
	  - Manual Recalculation
	Precedence
	  - Addition and Subtraction
	  - Multiplication and Division
	  - Exponentiation
	  - Changing Precedence
	Cell References
	  - Relative Cell Reference
	  - Absolute Cell Reference
	Display Sum, Average or Count
	Autofill
	Error Messages
	Display Formulas
	Functions
	  - Function Wizard
	Exercises

Module 11:  Charts
	Introduction
	Chart Data
	Chart Labels
	Chartwizard
	Chart Toolbar
	Move a Chart
	Size a Chart
	Change Chart Type
	Delete a Chart
	Exercises
	
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 (August/99)