Excel Windows 2000: Introduction

Course Code: EXCW00-1 Time: 7 hours

Prerequisites: Windows: 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 Creating a New Workbook Range Pre-selecting Data Entry Range Saving, Closing, Opening Files 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 The Window Adding and Deleting Rows, Columns, or 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 Printing Print Preview Page Setup Page Settings Page Break Preview Header/Footer Tab Sheet Settings The Collapse Dialog Button Manual Page Breaks Margin Tab Printing a Specific Page Dates and Time Working with Dates and Time Dates and the Year 2000 Order of Operation Ending the Excel Session

Return to Course Listing | Home Page