Excel 2002 Introduction

1 day

Overview

Students will create, edit, format and print basic worksheets and charts in Excel.

Prerequisites

Windows Introduction, or equivalent knowledge.

Benefits

Students will learn how to use an electronic spreadsheet to create basic worksheets and charts.

Target student

A user who has worked with personal computers and used Windows to manage information, run programs, and access the Web.

What's next

Excel 2002 Introduction is the first course in this series. Excel 2002 Intermediate, the next course in this series, teaches students how to use charting and formula construction capabilities in Excel. Students who want to learn advanced features can then take Excel 2002 Advanced.

Getting Started

Enter Data in a Worksheet
Edit Data
Change Text Appearance
Save a Workbook
Obtain Help
Editing Your Worksheet

Editing Your Worksheet

Move Data to Other Cells
Copy Data to Other Cells
Fill Cells with a Series of Data
Insert and Delete Rows and Columns
Undo and Redo an Entry
Find and Replace Numbers
Enter Data in a Range
Verify Data in a Range

Performing Calculations

Sum a Range of Data
Use a Built-in Function
Copy a Formula
Create an Absolute Reference

Formatting

Specify Numeric Format
Create a Custom Numeric Format
Change Font Size and Type
Create and Apply Styles
Add Borders to Cells
Find and Replace Formats
Change Column Width and Row Height
Shrink Text to Fit
Align Cell Contents
Merge and Split Cells
Apply an AutoFormat

Working with Multiple Worksheets

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Copy Worksheets
Change the Number of Worksheets

Setting Page Display and Printing Options

Freeze and Unfreeze Rows and Columns
Set Print Titles
Set Page Margins
Create a Header and Footer
Change Page Orientation
Insert and Remove a Page Break
Print a Range