Ex2002e-1

Importing and Exporting Data

Ex2002e-1-1

Import data into Excel.

Combining and Organizing Data

Retrieving Data from a Database

Ex2002e-1-2

Export data from Excel.

Publishing Data to the Web

Publishing a PivotTable as a Web Page

Ex2002e-1-3

Publish worksheets and workbooks on the Web.

Publishing Data to the Web

Saving a Workbook as a Web Page

Publishing Data to the Web

Publishing Worksheets as Web Pages

Ex2002e-2

Managing Workbooks

Ex2002e-2-1

Create, edit, and apply templates.

Performing Calculations and Formatting Data

Creating a Template from an Existing Workbook

Ex2002e-2-2

Create a workspace.

Combining and Organizing Data

Grouping Multiple Data Lists

Ex2002e-2-3

Use data consolidation.

Combining and Organizing Data

Summarizing Multiple Sets of Data

Ex2002e-3

Formatting Numbers

Ex2002e-3-1

Create and apply custom number formats.

Performing Calculations and Formatting Data

Making Numbers Easier to Read

Ex2002e-3-2

Use conditional formats.

Performing Calculations and Formatting Data

Formatting Data Based on Its Value

Ex2002e-4

Working with Ranges

Ex2002e-4-1

Use named ranges in formulas.

Performing Calculations and Formatting Data

Creating Formulas to Calculate Values

Ex2002e-4-2

Use look-up and reference functions.

Combining and Organizing Data

Looking Up Information in a Data List

Ex2002e-5

Customizing Excel

Ex2002e-5-1

Customize toolbars and menus.

Performing Calculations and Formatting Data

Creating Formulas to Calculate Values

Ex2002e-5-2

Create, edit, and run macros.

Automating Repetitive Tasks with Macros

Introducing Macros

Automating Repetitive Tasks with Macros

Creating and Modifying Macros

Ex2002e-6

Auditing Worksheets

Ex2002e-6-1

Audit formulas.

Performing Calculations and Formatting Data

Finding and Correcting Errors in Calculations

Ex2002e-6-2

Locate and resolve errors.

Performing Calculations and Formatting Data

Finding and Correcting Errors in Calculations

Ex2002e-6-3

Identify dependencies in formulas.

Performing Calculations and Formatting Data

Finding and Correcting Errors in Calculations

Ex2002e-7

Summarizing Data

Ex2002e-7-1

Use subtotals with lists and ranges.

Combining and Organizing Data

Organizing Data into Levels

Publishing Data to the Web

Saving a Workbook as a Web Page

Ex2002e-7-2

Define and apply filters.

Performing Calculations and Formatting Data

Limiting the Data that Appears on the Screen

Ex2002e-7-3

Add group and outline criterion to ranges.

Combining and Organizing Data

Organizing Data into Levels

Ex2002e-7-4

Use data validation.

Performing Calculations and Formatting Data

Creating Rules to Validate Data

Ex2002e-7-5

Retrieve external data and create queries.

Publishing Data to the Web

Working with Structured Data

Combining and Organizing Data

Retrieving Data from a Database

Ex2002e-7-6

Create Extensible Markup Language (XML) Web queries.

Publishing Data to the Web

Working with Structured Data

Ex2002e-8

Analyzing Data

Ex2002e-8-1

Create PivotTables, PivotCharts, and PivotTable/PivotChart reports.

Creating Charts and PivotTables

Creating Dynamic Lists with PivotTables

Creating Charts and PivotTables

Editing PivotTables

Creating Charts and PivotTables

Creating PivotTables from External Data

Creating Charts and PivotTables

Creating a Dynamic Chart Using PivotCharts

Ex2002e-8-2

Forecast values with what-if analysis.

Creating Charts and PivotTables

Finding Trends in Charts

Ex2002e-8-3

Create and display scenarios.

Analyzing Alternative Sets of Data

Defining and Editing Alternative Data Sets

Analyzing Alternative Sets of Data

Defining Multiple Alternative Data Sets

Analyzing Alternative Sets of Data

Varying Your Data to Get a Desired Result

Ex2002e-9

Workgroup Collaboration

Ex2002e-9-1

Modify passwords, protections, and properties.

Collaborating with Others

Protecting Workbooks and Worksheets

Ex2002e-9-2

Create a shared workbook.

Collaborating with Others

Sharing a Data List

Ex2002e-9-3

Track, accept, and reject changes to workbooks.

Collaborating with Others

Tracking and Managing Changes in a Workbook

Ex2002e-9-4

Merge workbooks.

Collaborating with Others

Identifying Which Revisions to Keep