Excel 2003: Getting Started

« back to previous page

Description:	Students will create, edit, and print basic worksheets in Excel. They will enter formulas for calculations and improve the appearance of worksheet data by using a variety of formatting techniques.
Prerequisites:	Windows or equivalent skills
Length:	One day

Getting Started with Excel
• An Overview of Excel
• Navigate in Excel
• Select Data
• Enter Data
• Save a Workbook
• Spell Check a Worksheet

Performing Calculations
• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create an Absolute Reference

Formatting a Worksheet
• Change Font Size and Type
• Add Borders and Color to Cells
• Change Column Width and Row Height
• Merge Cells
• Apply Number Formats
• Create a Custom Number Format
• Align Cell Contents
• Find and Replace Formats
• Apply an AutoFormat
• Apply Styles

Developing a Workbook
• Format Worksheet Tabs
• Reposition Worksheets in a Workbook
• Insert and Delete Worksheets
• Copy and Paste Worksheets
• Copy a Workbook

Printing Workbook Contents
• Set a Print Title
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Insert and Remove Page Breaks
• Print a Range

Customizing Layout
• Split a Worksheet
• Arrange Worksheets
• Freeze and Unfreeze Rows and Columns
• Hide and Unhide Worksheets