ELM Computer Consulting


Title: Excel 5.0
Code:EX50.W
Number of Pages:168
Cost:$24.95 Canadian Funds (Shipping and Handling not included)
Estimated Time to Complete:12 hours
Practice Exercises:Yes
Review Exercises:Yes
Summary of Features:Yes
Exercise Disk:Yes
Review/Exam: No

Module 1: Introduction
 	Elements of a Document Window
 	Menu Bar, Standard Toolbar
 	Formatting Toolbar
 	Formula Bar
 	Dialog Boxes
 	Help
 	TipWizard
 	Closing Document Window
 	Exiting Excel 5.0/Windows

Module 2: Create a Worksheet
 	Cell Identification Number
 	Active Cell
 	Cell Movement Keys
 	Go To
 	Types of Data
 	AutoSum
 	Saving a Workbook

Module 3: Access/Print Multiple Worksheets
 	Opening New Workbook
 	Displaying Open Windows
 	Switching Workbooks
 	Closing a Workbook
 	Print Preview, Printing a Worksheet

Module 4: Edit a Workbook
 	Opening a Workbook
 	Erasing/Replacing/Editing a Cell
 	Selecting Cell(s)/Row(s)/Column(s)
 	Undo
 	Inserting Row(s)/Column(s)/Worksheet
 	Renaming a Worksheet
 	Deleting Row(s)/Column(s)/File(s)
 	Deleting a Worksheet
 	Hiding Row(s)/Column(s)
 	Freezing Row(s)/Column(s)
 	Setting Column Width, AutoFit
 	Spelling

Module 5: Cell Formatting
 	Bold, Italic, Underline
 	Font
 	Superscript, Subscript
 	Text Alignment
 	Copying Formatting
 	Clearing Formatting

Module 6: Special Effects
 	Rotating Data
 	Wrapping Text
 	Vertical Row Alignment
 	Justifying Text
 	Shade/Color/Patterns
 	Color Text
 	Adding Borders
 	AutoFormat

Module 7: Number/Date/Time Formatting
 	Number Formats
 	Scientific Notation
 	Fractions
 	Currency
	Percent
 	Date, Time

Module 8: Page Setup
 	Changing Margins
 	Centering Pages Vertically/Horizontally
 	Changing Paper Orientation, Size
 	Inserting a Page Break
 	Adding Row and Column Headings/Titles
 	Adding Headers and Footers
 	Printing Grid Lines
 	Force Print

Module 9: Move/Copy
 	Moving Data
 	Copying Data
 	Moving Worksheets
 	Copying Worksheets
 	Copying Formatting
 	Grouping Worksheets
 	AutoFill
 	Fill Patterns
 	Creating Custom Lists
 	Fill Series:  Linear, Growth, Date

Module 10: Formulas
 	Operators
 	Entering formulas
 	Changing Precedence
 	Cell References
 	Error Messages
 	Displaying Formulas
 	Functions, Function Wizard
 	AutoFill to Copy Formula

Module 11: Charts
 	Charting Data, Labels
 	Moving Charts
 	Sizing Charts
 	Editing Charts
 	Adding Chart/Axes Titles
 	Adding Data Values/Labels
 	Removing/Adding Chart Legend
 	Rotating Axis Text
 	Adding/Removing Grid Lines
 	Changing Item Colors
 	Changing Data Range
 	Changing Chart Type
 	Deleting Chart

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: [Coastal WebWorks]