What's New in Microsoft Excel 2002?

You'll notice some changes as soon as you start Microsoft Excel 2002. 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.

The following table lists some of the new and improved features for Microsoft Excel 2002 along with the names of the lessons and topics where you can learn how to use those features.

New or Improved Feature

What This Feature Helps You Do

Lesson

Topic

Import data

Import data from a wide range of sources, including Microsoft SQL Server, ODBC, and OLAP.

Combining and Organizing Data

Retrieving Data from a Database

PivotTable toolbar

Perform PivotTable functions more easily.

Creating Charts and PivotTables

Creating Dynamic Lists with PivotTables

PivotTable linking

Link workbook cells to PivotTable cells.

Creating Charts and PivotTables

Editing PivotTables

Error button

Easily repair errors in calculations.

Performing Calculations and Formatting Data

Finding and Correcting Errors in Calculations

AutoRepublish

Republish linked Web pages whenever you save the originating workbook.

Publishing Data to the Web

Publishing Worksheets as Web Pages

Import/Export XML data

Add metadata to Excel Web documents.

Publishing Data to the Web

Working with Structured Data