Excel 2000 Day 3

Working with Databases

Using a Database

Creating a Database

Modifying a Database

Sorting Records by Multiple Fields

Using Data Validation

Validating Data using a List

Creating a Custom Error Message

Removing Data Validation

Creating Subtotals in a List

Removing Subtotals from a List

Working with Databases

Working with the Data Form

Viewing the Data Form

Viewing Data Form Records

Editing Data Form Records

Adding Data Form Records

Defining Criteria

Clearing Data Form Criteria

Deleting Data Form Records

Working with the Data Form

Using AutoFilter

Enabling AutoFilter

Using AutoFilter to Filter a List

Clearing AutoFilter Criteria

Creating a Custom AutoFilter

Disabling AutoFilter

Using AutoFilter

Working with Advanced Filters

Creating a Criteria Range

Using a Criteria Range

Showing All Records

Using Comparison Criteria

Using an Advanced And Condition

Using an Advanced Or Condition

Extracting Filtered Records

Using Database Functions

Working with Advanced Filters

Importing and Exporting Data

Importing Data

Importing Data from Text Files

Changing External Data Range Properties

Importing Data from Other Applications

Removing the Query Definition

Importing a Table from a Web Page

Exporting Data to Other Applications

Importing and Exporting Data

Using Multiple Workbooks

Opening Multiple Workbook Windows

Cascading Open Workbook Windows

Activating Cascaded Workbook Windows

Viewing Multiple Workbook Windows

Activating Tiled Workbook Windows

Copying Data between Workbooks

Saving a Workspace

Closing All Open Workbooks

Opening a Workspace

Linking Workbooks

Opening Linked Workbooks

Using Multiple Workbooks

Using Conditional and Custom Formats

Applying Conditional Formats

Changing a Conditional Format

Adding a Conditional Format

Deleting a Conditional Format

Creating a Custom Format

Using Conditional and Custom Formats

Using Templates

Working with Templates

Saving a Workbook as a Template

Using a Template

Editing a Template

Inserting a New Worksheet

Deleting a Template

Creating Default Templates

Using Templates

Working with Comments

Creating Comments

Viewing a Comment

Using the Reviewing Toolbar

Printing Comments

Working with Comments

Using Worksheet Protection

Unlocking Cells in a Worksheet

Protecting a Worksheet

Unprotecting a Worksheet

Protecting Workbook Windows

Unprotecting Workbook Windows

Assigning a Password

Opening a Protected File

Removing a Password

Setting Manual Calculation

Setting Automatic Calculation

Using Worksheet Protection

Sharing Workbooks

Using Shared Workbooks

Saving a Shared Workbook

Viewing Users Sharing a Workbook

Viewing Shared Workbook Changes

Displaying Comment Boxes

Changing the Update Frequency

Highlighting Changes

Managing Conflicting Changes

Resolving Conflicting Changes

Setting Change History Options

Creating the History Worksheet

Reviewing Tracked Changes

Merging Shared Workbook Files

Sharing Workbooks

Managing Files

Changing Workbook Properties

Selecting File Views

Finding Files based on Criteria

Clearing Search Criteria

Searching by File Name

Sorting Excel Files

Copying Excel Files to a Floppy Diskette

Managing Files