Microsoft Excel 2003/07 - Beginner

Introduction to Excel

• Overview of Toolbars and Formula Bars
• Display and Hide Toolbars
• Overview of the Task Pane

Creating a Worksheet

• Entering data
• Insert and delete rows and columns
• Using AutoSum
• Resizing rows and columns
• Basic formulae

Formatting Cells

• Date formats
• Text formats and alignment
• Borders and shading
• AutoFormat
• Numeric Formats
• Copy, cut and paste
• Drag and drop
• AutoFill

File Management

• Renaming worksheets
• Saving and closing workbooks

Tools

• Find and Replace
• Spell Check

Printing and Previewing

• Page break preview
• Page set up
• Setting margins
• AutoFormat
• Setting Headers and Footers
• Setting Print Area
• Repeat column and row titles.