How to Effectively Use Excel as a Database

Duration: 90 minutes


WHY ATTEND

Salespeople managing lead lists, HR professionals managing employee data, managers dealing with budgets and project plans can all tap into the power of Excel’s database features, without getting bogged down in techie-speak in this webinar.   (more details below)

According to Microsoft, about 70% of Excel users keep large lists or databases in Excel. Unfortunately a vast majority haven’t mastered some of the most powerful data management tools that Excel offers. Anyone who deals with large lists in Excel needs these tools and techniques to effectively manage data and become more productive.

In this webinar, you’ll learn advanced sorting and filtering techniques; how to move, splice and combine data; ways to avoid bad data with validation tools and more.

LEARNING OBJECTIVES

Participants will learn how to:

  • Quickly and easily convert data to tables
  • Eliminate bad data before it even gets into your database
  • Restrict cell content by value, formula or date
  • Get rid of extra spaces that prevent matching and sorting
  • Use multi-key sorts from the toolbar
  • Sort by re-arranging the left-right order of columns; sort in random order
  • Use grouping to better analyze your data
  • Insert automatic subtotals for quick displays of summary totals
  • Use filtering to view just the data you need to see
  • Simplify data entry and improve accuracy 
  • Eliminate duplicate records from your database in no time at all
  • Split grouped data into multiple columns using the Text to Columns command or the new Flash Fill feature

    This session will be presented in Excel 2013. Comparison info will be covered for other versions of Excel.

    ABOUT THE SPEAKER

    Dennis Taylor is an author and highly respected computer trainer and facilitator, specializing in Excel. His focus is on those spreadsheet and database techniques that improve business efficiency and productivity. Dennis has over 20 years of training and consulting experience. A former employee of Amoco Oil, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught nearly 4,000 seminars and classes for over 100 companies, organizations, and government agencies.

    Dennis is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. He has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to many clients over the past 20 years. In addition, Mr. Taylor has authored and presented over 50 different training courses on Excel topics (available on DVD/CD/VHS formats) and has presented numerous webinars to thousands of attendees.

    What You Get With Each Option

    Live Recording

    Live Only

    Participation in the live upcoming webinar

    Recording

    Recording Only

    Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

    Live and Recording

    Live + Recording

    Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

    Event Package

    Event Value Pack

    Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

    What You Get With Each Option close

    Live Recording

    Live Only

    Participation in the live upcoming webinar

    Recording

    Recording Only

    Full MP4 recording of webinar, including Q&A. Choose digital download or CD-ROM by mail.

    Live and Recording

    Live + Recording

    Participation in the live webinar + Full MP4 Recording. For recording, choose digital download or CD-ROM by mail.

    Event Package

    Event Value Pack

    Participation in the live webinar + Full MP4 Recording + Audio-only MP3 recording. For recordings, choose digital download or CD-ROM by mail.

    About Webinar Connections close

    Each purchase is for ONE computer to access the session.
    A group may participate in a room together as long as only 1 computer is logged in.
    If you need more than one computer to access the webinar, please call customer service at 888-479-2777.
    A charge will apply for each connection.