Excel Intermediate - Database Features

Do you have lists of information in Excel and need to find data within those lists quickly? Excel’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

• Simple - single level - sorting
• Multiple level sorts
• Subtotals

Module 4: Extracting Data

• The AutoFilter
• Filtering a list
• Custom Filters
• Setting multiple criteria

Module 5: Database Functions

• DSUM
• DAVERAGE
• DCOUNTA
• DGET