Microsoft Excel 2003 Introduction Training Course

GETTING STARTED

• What is Excel?
• Starting Excel
• The Excel Application Window
• Using the Excel Menu System
• Using Excel Toolbars
• Using Excel Task Panes
• Displaying Help Information
• Exiting from Excel

MODIFYING AN EXISTING WORKSHEET

• Resetting the Working Folder
• Moving the Cell Pointer
• Changing Data in a Worksheet
• Reversing an Edit Operation
• Saving a Workbook
• Adding Data to a Worksheet
• Entering a Formula into a Worksheet
• Adjusting Column Width in a Worksheet
• Adjusting Row Height in a Worksheet
• Printing a Worksheet

BUILDING A NEW WORKSHEET

• Opening a New Workbook
• Using the Spelling Checker

EDITING A WORKSHEET

• Working in Edit Mode
• Selecting Ranges in a Worksheet
• Using AutoFill
• Copying Cells
• Moving Cells
• Clearing Cells
• Using AutoSum
• Inserting and Deleting Rows and Columns
• Inserting and Deleting a Range of Cells

FORMATTING A WORKSHEET

• Resetting the Alignment of Cell Entrie
• Resetting Font Options for Cell Entries
• Resetting the Number Format of Cell Entries
• Adding Borders and Shading to a Worksheet
• Using AutoFormat

ENHANCING A WORKSHEET PRINTOUT

• Changing the Page Setup for a Worksheet
• Previewing a Worksheet
• Inserting a Manual Page Break into a Worksheet / Including Print Titles in a Printout
• Printing Selected Worksheet Entries

USING EXCEL FUNCTIONS

• What is a Function?
• Using the SUM Function
• Using the AVERAGE Function
• Using the MAX and MIN Functions
• Using the COUNT Function
• Using the Insert Function Button