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

Working with Excel Tables and Database Tools (Sorting, Filtering, Subtotals) (IMEN40M)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, November 12, 2014
Event Description

Handle Powerful Data Like a Pro With These Powerful Excel Tools

You can do more with Microsoft Excel spreadsheets than just calculate data -- you can tackle powerful database needs with ease too! With just a bit of know-how, you can take advantage of the power of Excel to validate data, sort data (based on content, color, or icon), insert automatic subtotals, filter the data to see just what you need to see, restructure columnar data that has been improperly grouped, eliminate duplicate records in a flash, and use powerful expanded functions to analyze the data in any list, regardless of size.

Microsoft says that up to 70% of users surveyed use Excel to maintain a database or large lists. To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. It’s all the more important as data collection has become more automated and you’re getting swamped with tons of data. But what can you do with all that data? You need to know how to structure (perhaps converting your data to a table), re-arrange the data (sort), see just what you want to see (filter), create quick summaries (subtotals), restructure fields containing too much data (text to columns) and eliminate redundant records. If you are setting up new lists, you need to know the powerful validation tools that keep out bad data from the start and how to drastically reduce data entry with drop-down clickable lists.

Join expert speaker Dennis Taylor as he reveals to you some of Excel’s most powerful tools that will help take your Database Management work to a whole new level. In this 60-minute webinar you will learn to master the tools that professional data managers and analyzers have been using with great success in their everyday work.

In this program, you will learn to:

  • Convert lists into tables - gain easier data-handling and enhanced visual features
  • Use the fastest, most efficient ways to sort data; sort by content, by color, or based on the order of data in a custom list; sort in random order or by re-arranging columns left-to-right
  • Re-structure improperly grouped columnar data
  • Master the myriad ways of filtering data to display just the data you need
  • Eliminate duplicate records from a large database
  • Insert a row of subtotals in a sorted list without tediously creating new rows and formulas
  • Create drop-down lists to accelerate data entry, with improved accuracy and consistency
  • Work with valuable functions that help you understand your data - COUNTIF, SUMIF, and more…

Master the tools of Database Management - Sorting, Automatic Subtotals, and Filtering, as well as other techniques that provide clarity and quick answers so that you can understand your data better.

Who should attend

Any Excel user who deals with database-like lists needs these tools and techniques to effectively manage the lists and become more productive. This webinar is ideal for all Excel users, except beginners.

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: Working with Excel Tables and Database Tools (Sorting, Filtering, Subtotals)
    Presenter(s): Dennis Taylor Protection Status