EX2002-1

Working with Cells and Cell Data

EX2002-1-1

Insert, delete, and move cells.

Getting to Know Excel

Zeroing In on Data in a List

EX2002-1-2

Enter and edit cell data including text, numbers, and formulas.

Getting to Know Excel

Saving Changes to an Existing Data List

Checking and Correcting Data

EX2002-1-3

Check spelling.

Getting to Know Excel

Checking and Correcting Data

EX2002-1-4

Find and replace cell data and formats.

Getting to Know Excel

Checking and Correcting Data

EX2002-1-5

Work with a subset of data by filtering lists.

Combining, Sorting, and Summarizing Data

Limiting the Data That Appears on the Screen

EX2002-2

Managing Workbooks

EX2002-2-1

Manage workbook files and folders.

Publishing Information on the Web

Publishing Worksheets to the Web

EX2002-2-2

Create workbooks using templates.

Getting to Know Excel

Creating a Workbook and Entering a Series

Combining, Sorting, and Summarizing Data

Creating a Template from an Existing Workbook

EX2002-2-3

Save workbooks using different names and file formats.

Getting to Know Excel

Zeroing In on Data in a List

EX2002-3

Formatting and Printing Worksheets

EX2002-3-1

Apply and modify cell formats.

Performing Calculations on Data

Naming Groups of Data

Changing Document Appearance

Changing the Appearance of Data

EX2002-3-2

Modify row and column settings.

Setting Up a Workbook

Making Data Easier to Read

EX2002-3-3

Modify row and column formats.

Setting Up a Workbook

Making Data Easier to Read

EX2002-3-4

Apply styles.

Changing Document Appearance

Applying an Existing Format to Data

EX2002-3-5

Use automated tools to format worksheets.

Changing Document Appearance

Applying an Existing Format to Data

EX2002-3-6

Modify Page Setup options for worksheets.

Changing Document Appearance

Making Printouts Easier to Follow

Positioning Data on a Printout

Working with Charts and Printing

Printing Data Lists

Printing Part of a Data List

EX2002-3-7

Preview and print worksheets and workbooks.

Working with Charts and Printing

Printing Data Lists

Printing Part of a Data List

EX2002-4

Modifying Workbooks

EX2002-4-1

Insert and delete worksheets.

Getting to Know Excel

Introducing Excel

Combining, Sorting, and Summarizing Data

Creating a Template from an Existing Workbook

Working with Other Microsoft Office Programs

Including an Office Document in an Excel Worksheet

Storing an Excel Document as Part of Another Office Document

Pasting a Chart into Another Document

EX2002-4-2

Modify worksheet names and positions.

Setting Up a Workbook

Making Workbooks Easier to Work With

Combining, Sorting, and Summarizing Data

Working with More Than One Set of Data

EX2002-4-3

Use 3-D references.

Combining, Sorting, and Summarizing Data

Linking Data to other Workbooks

EX2002-5

Creating and Revising Formulas

EX2002-5-1

Create and revise formulas.

Performing Calculations on Data

Creating Formulas to Calculate Values

Performing Calculations on Filtered Data

EX2002-5-2

Use statistical, date and time, financial, and logical functions in formulas.

Performing Calculations on Data

Creating Formulas to Calculate Values

Performing Calculations on Filtered Data

EX2002-6

Creating and Modifying Graphics

EX2002-6-1

Create, modify, position, and print charts.

Working with Charts and Printing

Creating a Chart

Customizing Chart Labels and Numbers

Printing a Chart

EX2002-6-2

Create, modify, and position graphics.

Setting Up a Workbook

Adding a Graphic to a Document

EX2002-7

Workgroup Collaboration

EX2002-7-1

Convert worksheets into Web pages.

Publishing Information on the Web

Saving a Workbook for the Web

Publishing Worksheets to the Web

Retrieving Data from the Web

Acquiring Web Data with Smart Tags

EX2002-7-2

Create hyperlinks.

Working with Other Microsoft Office Programs

Creating a Hyperlink

EX2002-7-3

View and edit comments.

Setting Up a Workbook

Managing Comments