Data Entry and Formatting Techniques

Restricting Cell Entries to Numbers, Dates or Times

Restricting Cell Entries to Specific Entries in a List

Applying Number Formats to Cell Entries

Creating a Custom Number Format

Applying Conditional Formatting to a Worksheet

Naming Ranges

Defining a Range Name

Using a Range Name in a Formula

Moving the Cell Pointer to a Named Range

Using Lookup Functions

Using the VLOOKUP and HLOOKUP Function

Using the HLOOKUP Function

Working with a Template

Creating a Template

Modifying the Default Template Style

Basing a New Workbook on a Custom Template

Auditing a Worksheet

Tracing Precedents and Dependents in a Worksheet

Tracing Errors in a Worksheet

Linking Multiple Workbooks

Entering a Formula to Link Multiple Workbooks

Creating a Workspace

Working with a Database

What is a Database?

Sorting Database Records

Sorting Records by the Entries in One Field

Sorting Records by the Entries in Multiple Fields

Totaling Database Entries

Filtering Database Records

Specifying a Criteria Range in a Filter Operation

Using a Data Form to Enter Database Records

Querying an External Database

Analyzing Data (Part 1)

Creating a PivotTable Report

Resetting the Summary Function in a PivotTable

Report

Creating a PivotChart Report

Creating a PivotTable Report for the World Wide

Web

Analyzing Data(Part 2)

Using the Solver

Outlining a Worksheet

Additional Data Analysis Topics

Importing and Exporting Data

Importing Data from Other Applications into Excel

Importing Data in a Text File into Excel

Importing a Table in an HTML File into Excel

Exporting Excel Data into Other Applications

Using Excel Workgroup Features

Tracking Changes in a Workbook

Inserting Comments into a Worksheet

Accepting and Rejecting Proposed Changes /

Reviewing Comments

Protecting a Shared Workbook

Protecting an Unshared Workbook

Additional Workgroup Topics

Conclusion