EXCEL 2002 (XP)
INTRODUCTION

Course Length: 1 day or two half-day sessions

Who should attend: Someone who is new to Excel

Suggested Background: Basic Windows skills, comfortable with the mouse

This course provides the skills that are necessary to use Excel to create worksheets. You will learn to enter information into a worksheet, developing formulas to calculate results. Learn to modify the worksheet and to enhance its appearance. Use functions to generate totals and statistical summaries.

Upon completion of this course, you will be able to:

Handle a Workbook

Identify Excel screen elements

Move around efficiently

Select areas of the worksheet

Create, open and close workbooks

Understand the difference between Save and Save As

Create a Basic Worksheet

Enter text, numbers, dates and times

Create formulas and use statistical functions

Edit and clear cell contents

Undo changes

Control Worksheet Appearance

Change the alignment of cell contents

Enhance text, changing the font, size, style, and color

Control the appearance of numbers with formatting

Change column widths

Add borders, background shading, and color

Work More Efficiently

Insert and delete rows and columns

Understand Excel’s automatic features

Fill cells with sequential information automatically

Copy and move cell contents using the Office Clipboard

Print Your Worksheet

Preview and print a worksheet

Control the page setup

Change page margins and orientation

Create headers and footers