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, use subtotals, sort your data on multiple levels, query your data a variety of ways, use Pivot Tables and more.
Participants must be proficient in Excel on at least an introductory level.
Topics include: • Defining an Excel list (database) • Using data forms and data validation • Working with Database functions • Sorting and filtering data • Designing Pivot tables and Pivot charts
PRE-REQUISITES:
Excel Level 1 (2000, 2002 or 2003)
or have comparable experience with Excel
Access 2003: Level 2