My Shopping Cart
There are no items in your shopping cart.

Tips & Techniques to Transform Excel into a Database Powerhouse

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Audio Conference
60 minutes
  •  Tue, October 6, 2009
Event Description

Don't waste time and money on a complex database program -- Excel can tackle most database tasks with ease!

Microsoft Excel spreadsheets do more than calculate data -- they let you tackle powerful database duties with ease too! With just a bit of know-how, you can take advantage of the power of Excel to validate data, create data entry forms, sort, add subtotals, auto-filter and even utilize advanced filtering.

Join Excel expert Dennis Taylor for this exciting webinar and explore all of the techniques needed to create, modify, build and manage an Excel database.

In this 60-minute session, you'll learn how to:

  • Build and maintain a database with the Data Form command for easy setup and data manipulation
  • Use Data Validation to prevent out-of-range data, block duplicate entries, and restrict other bad data from being typed into your worksheets
  • Sort, filter and review existing data in new and revealing ways with advanced sorting and Data Filter commands
  • Use the powerful and flexible Text To Columns feature to restructure data the way you need it
  • Avoid poor database design and find out how to correct improperly stored data
  • And more!

You're sure to learn all the tricks you need to take Excel from a simple spreadsheet program to a powerful and easy-to-use database that handles flat file data collections with ease.

This is a pre-recorded event

About Our Speaker(s)

Dennis Taylor, Microsoft Excel Training ExpertDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Tips & Techniques to Transform Excel into a Database Powerhouse
    Presenter(s): Dennis Taylor Protection Status