ELM Computer Consulting


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

Module 1: Introduction
 	Elements of a Document Window
 	Menu Bar
 	Toolbar
 	Formula Bar
 	Dialog Boxes
 	Help
 	Exiting Excel 4.0

Module 2: Create a Worksheet
 	Cell Identification Number
 	Active Cell
 	Cell Movement Keys
 	Entering Different Types of Data
 	Text Entries
 	Numbers, Date/Time
 	AutoSum
 	Clearing the Screen

Module 3: Save and Print a Worksheet
 	Saving a Document
 	Print Preview/Print
 	Opening New Document Window
 	Displaying Open Windows
 	Switching Documents
 	Closing Document Window

Module 4: Edit a Worksheet
 	Opening a Document
 	Overwriting a Document
 	Go To
 	Erasing/Replacing/Editing Contents of a Cell
 	Inserting/Deleting Rows/Columns
 	Deleting a File
 	Selecting Cells/Rows/Worksheet
 	Erasing Selected Cells
 	Clearing Cell Contents
 	Undo
 	Changing Column Width
 	Best Fit

Module 5: Cell Formatting
 	Adding Attributes
 	Text Alignment
 	Rotating Data
 	Changing Font
 	Shading Cells
 	Adding Borders
 	Wrapping Text
 	Vertical Row Alignment
 	Justifying Text
 	AutoFormat
 	Copying Formatting
 	Clearing Formatting

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

Module 7: Page Setup
 	Changing Margins
 	Centering Pages Vertically/Horizontally
 	Changing Paper Orientation/Size
 	Inserting a Page Break
 	Adding Row and Column Headings
 	Adding Headers and Footers
 	Print to Fit

Module 8: Move/Copy
 	Moving Cell Contents
 	Copying Cell Contents
 	AutoFill
 	Data Series

Module 9: Formulas
 	Entering Formulas
 	Changing Precedence
 	Cell References
 	Displaying Formulas
 	AutoFill

Module 10: Charts
 	Creating Charts
 	Moving a Chart
 	Sizing a Chart
 	Revising a Chart
 	Removing/Adding Chart Legend
 	Rotating X-Axis Text
 	Changing X-Axis Font
 	Chart Toolbar
 	Deleting a 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]