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

Get Quick and Powerful Results from Your Data in Excel (IME350G)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, March 18, 2015
Event Description
See the sneak peek before you buy!

Learn to Master Excel’s Data Management Tools – Data Validation, Converting to Tables, Conditional Formatting, Pivot Tables, Sorting, Adding Automatic Subtotals, Filtering & More!

When you work with lists of data in Excel, you need to know how to manage these lists to extract meaningful results.  You need to know how to optimize the structure of your data, possibly reorganizing and restructuring the layout of data, converting data into a table, and emphasizing important data with Conditional Formatting. With your data in shape, you can manage it with the many sorting and filtering capabilities of Excel, as well as creating quick summary reports with the Subtotal feature. Ultimately you will need to learn the rudiments of Excel’s most dramatic, dynamic, and powerful analytic feature – Pivot Tables.

To be proficient in Excel, you must be familiar with data management tools because increasingly, data collection has become more automated and you’re getting swamped with tons of data.

This webinar by Excel expert Dennis Taylor presents a number of real-world examples that show you how data can be handled to extract significant information. It will explore the effectiveness of converting data to tables and re-arranging data by sorting. It will explore the convenience of using Filter and Advanced Filter to see only the data you want to see. Learn to create quick summaries with Subtotal, accentuate the most significant data with Conditional Formatting and provide in-depth summaries with PivotTables. See how to insure data integrity and reduce lengthy typing with Data Validation tips.

Dennis will help you master Excel’s data management tools – Data Validation, Converting to tables, Conditional Formatting, Sorting, adding automatic Subtotals, and Filtering, as well as other techniques that provide clarity and quick answers so that you can understand your data better.

Training Objective

  • Accelerate data entry(improving accuracy and consistency) with drop-down lists
  • Convert lists into tables – gain easier data-handling and enhanced visual features
  • Learn the 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
  • Master the myriad ways of filtering data to display just the data you need
  • Insert a row of subtotals in a sorted list without tediously creating new rows and formulas
  • Learn the basics of PivotTables to analyze your data with a minimum effort

Who should attend?

Any Excel user who needs to manage lists needs these tools and techniques to become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar, including the following:

  • HR professionals
  • Payroll Executives
  • Administrative Assistants
  • Legal Secretaries
  • Medical professionals
  • Education professionals
  • Accountants
  • Business Intelligence Analysts
  • Marketers
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: Get Quick and Powerful Results from Your Data in Excel
    Presenter(s): Dennis Taylor Protection Status