ELM Computer Consulting


Title: Excel 7.0
Code: EX70.W
Number of Pages: 170
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 7.0
	Excel 7.0 Screen
	Elements of a Document Window
	Menu Bar
	Standard Toolbar
	Formatting Toolbar
	Formula Bar
	Dialog Boxes
	Help Menu
	  - Print Help Information Box
	  - Context-Sensitive Help
	Tipwizard
	Close Document Window
	Reset Menu Bar
	Exit Excel 7.0
	Exit Windows 95

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
	  - Save in New Folder
	Change System Default Drive
	Automatic Backup
	  - Autosave Add-In

Module 3:  Access/Print Multiple Workbooks
	Create New Workbook
	  - Create New Worksheet
	Display Open Workbooks
	  - Cascade/Tile Open Workbooks
	Switch Worksheets
	Close a Workbook
	  - Close Multiple Workbooks
	Print Preview
	Print
	  - Standard Toolbar
	  - Print Range of Pages
	  - Print Multiple Worksheets

Module 4:  Edit a Workbook
	Open a Workbook
	  - File List
	  - Favorites
	  - 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
	Select Column
	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
	Delete Workbook(s)
	Hide Row(s) or Column(s)
	Freeze Row(s) or Column(s)
	Column Width
	  - Change Column Width
	  - Autofit
	  - Reset Standard Width
	Spelling
	Save (Replace)

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

Module 6:  Special Effects
	Rotate Data
	Wrap Text
	Vertical Row Alignment
	Justify Text
	Shade/Color/Patterns
	  - Formatting Toolbar
	Color Text
	  - Formatting Toolbar
	Border
	  - Remove Borders
	AutoFormat
	  - Remove AutoFormat

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

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

Module 9:  Move/Copy
	Move Data
	  - Cut and Insert Paste
	  - Drag and Drop
	Move Worksheet
	  - Drag and Drop
	  - Move Worksheet to a Different Workbook
	Copy Data
	  - Copy and Insert Paste
	  - Drag and Drop
	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

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
	Autofill
	Error Messages
	Display Formulas
	Functions
	  - Function Wizard

Module 11:  Charts
	Introduction
	Chart Data
	Chart Labels
	ChartWizard
	Move a Chart
	Size a Chart
	Edit Chart Design
	Chart/Axes Titles
	  - Add Titles
	  - Change Font or Font Size
	  - Move Titles
	  - Delete Titles
	Data Values/Labels
	  - Data and Label Font
	Remove/Add a Chart Legend
	  - Move/Resize Legend in a Chart
	Rotate Axis Text
	Add/Remove Grid Lines
	Change Item Colors
	Change Data Range
	Change Chart Type
	Delete 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: James Lepard, ELM Computer Consulting (March/98)