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-844-384-4744
Pre Recorded Audio Conference
60 minutes
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 SpeakerDennis 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:
    Event Title: Tips & Techniques to Transform Excel into a Database Powerhouse
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team