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-844-384-4744
Pre Recorded Webinar
60 minutes
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 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: Get Quick and Powerful Results from Your Data in Excel
    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