Excel 2007 Intermediate - Database Features

Do you have lists of information in Excel and need to find data within those lists quickly? Excel 2007’s database features will help you. You will learn how to find specific records quickly, make data entry easier, validate data entry, use subtotals, sort your data on multiple levels, query your data in a variety of ways, and more.

Participants must be proficient in Excel on at least an introductory level. Windows Basics, Excel Basics and Formula Building or comparable experience is required.

Module 1: Excel Database Basics

• Defining an Excel list (database)
• Components of an Excel database (list)

Module 2: Data Entry

• Using the Data Form
• Using data validation

Module 3: Sorting Data

• New Sort tools in 2007
• Simple - single level - sorting
• Multiple level sorts
• Subtotals

Module 4: Extracting Data

• New AutoFilter tools in 2007
• Filtering a list
• Custom Filters
• Setting multiple criteria

Module 5: Database Functions

• DSUM
• DAVERAGE
• DCOUNTA
• DGET