What's New in Microsoft Excel 2002?

You'll notice some changes as soon as you start Microsoft Excel 2002. The toolbars and menu bar have a new look, and a new Task Pane appears on the right side of your screen. But the features that are new or greatly improved in this version of Microsoft Excel go beyond just changes in appearance. Some changes won't be apparent to you until you start using the program.

Below are just a few of the new and improved features you'll find in Microsoft Excel 2002, and the lessons and topics where you can learn about these features.

New or Improved Feature

What This Feature Helps You Do

Lesson

Topic

Ask A Question box

Quickly access Help by typing a question.

Getting to Know Excel

Introducing Excel

Task Panes

Perform common actions, such as opening or creating new files, with a single mouse click.

Getting to Know Excel

Introducing Excel

Find Format

Locate and change stored entries of distinct text formatting.

Getting to Know Excel

Checking and Correcting Data

Insert Options

Format new rows, columns, or cells as you insert them.

Setting Up a Workbook

Making Workbooks Easier to Work With

Borders Toolbar

Create complex borders and change their characteristics.

Changing Document Appearance

Changing the Appearance of Data

Header and footer graphics

Add a graphic to a worksheet header or footer.

Changing Document Appearance

Making Printouts Easier to Follow

Color-coded worksheet tabs

Make a worksheet stand out by allowing you to change the tab's color.

Combining, Sorting, and Summarizing Data

Working with More Than One Set of Data

Suppress errors

Define how Excel will print errors in the worksheet.

Working with Charts and Printing

Printing Data Lists

Copy Paste Web Query

Create a Web query by copying data directly from a Web page into Excel and then creating a query to retrieve data from the HTML table copied.

Publishing Information on the Web

Retrieving Data from the Web

Smart Tags

Bring information from the Web that is related to the contents of a worksheet cell.

Publishing Information on the Web

Acquiring Web Data with Smart Tags