Excel Windows 97: Introduction

Course Code: EXCW97-1 Time: 7 hours

Prerequisites: Windows 95: Introduction

The Basics The Worksheet Concept The Electronic Worksheet Starting Excel Windows Screen Elements Excel Screen Elements The Mouse and the Keyboard Worksheet Structure Renaming Workbook Sheets Cells Moving the Selector Entering Worksheet Data Data Types Math Operators Shortcut Menus & the Toolbar Help, I Need an Assistant! Creating a Worksheet Menu Bar Creating a New Workbook Range Pre-selecting Data Entry Range Saving, Closing, Opening Files Summary Information Saving File With a New Name Closing the File Opening a File Deleting Data Undo & Redo Formulas Creating Excel Formulas Formulas - Basics Reviewed Formulas - Beyond the Basics Functions Using Functions SUM() Function Pointing with Functions Other Functions The AutoSum Button Controlling AutoSum Multiple AutoSums Worksheet Mechanics Editing and Cell Entries Editing Formulas - Range Finder

Moving and Copying Data Absolute Addresses Working With Large Worksheets Zooming, Freezing Panes, Splitting Window Adding/Deleting Rows, Columns, & Sheets Worksheet Tools Spell Check AutoCorrect AutoCalculate AutoComplete Cell Comments Controlling Worksheet Appearance Formatting the Worksheet Number Formats Overflow Markers ######### The Formatting Toolbar Alignment, Merge and Center, Fonts Borders Patterns Tear Off Menus Removing Formats Column Width AutoFit Selection Working with Dates and Time Using Functions Changing Dates Display Order of Operation Printing Print Preview Page Setup Page Settings Page Break Preview Header/Footer Tab Sheet Tab The Collapse Dialog Button Manual Page Breaks Margin Tab Printing a Specific Page Ending the Excel Session

Return to Course Listing | Home Page