Excel 2003 - Level 1

You Will Learn To

Manage, edit, and print data using Microsoft Excel 2003.

Who Should Attend

New Excel users and experienced but self-taught Excel users will both benefit from this course.  Basic Windows skills are required.

Course Content

Getting Started with Excel

• An Overview of Excel

• Navigate in Excel

• Select Data

• Enter Data

• Save a Workbook

• Obtain Help

Modifying a Worksheet

• Move and Copy Data Between Cells

• Fill Cells with Series of Data

• Edit Cell Data

• Insert and Delete Cells, Columns, and Rows

• Find, Replace, and Go To Cell Data

• 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