Excel Database Tools

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Date(s): Friday, January 15, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Although Excel is not typically described as database software, many Excel users maintain large lists of data and they need the tools to manage that data efficiently. This session focuses Excel’s many powerful and easy-to-use database commands and methods critical to anyone who main-tains an Excel database. This session explores many of Excel’s techniques needed to modify, build, and manage an Excel database, including: validating data, using Excel’s Form feature, sorting, adding subtotals, filtering, and advanced filter.

Note: This session will use Excel 2007 as the primary platform for demonstrating these features, but will note the differences from Excel 2003 and will show some features in that version as well.

Topics include:

Data Validation - prevent bad data entry - keep out bad data before it ever gets into a data-base
* Restrict cell content by forcing users to pick entries from a pick list
* Restrict cell content by value, text, or data/time
* Restrict cell content by formula
* Use auditing tools to check the validity of existing data
Sorting
* Use multiple-key sorts from the menu or from button commands
* Sort based on re-arranging rows or re-arranging columns
* Sort based on cell colors or in random order
* Sort data based on customized lists
Creating automatic subtotals with the Subtotals command
* Set up single and multiple-level subtotals
* Expand and collapse displays quickly with grouping and outlining symbols
Data Form - Build and maintain a database with the Form feature
Using the powerful Filter command to view just the data you want to see
* Set up filtering to see and print a subset of data
* Create compound selection criteria for filtering data
* Use Excel 2007 greatly expanded special filtering tools for Text, Number, and Date fields
* Use the Advanced filter for extended filtering needs

About the Presenter: Dennis Taylor is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 12 years. Dennis has over 20 years of training and consulting experience. As a former employee of Amoco Oil, IBM, Lexmark, Texaco, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught over 3,000 seminars and classes attended by over 15,000 students.

To Register: Click Here.  Fee: $99.00