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

Microsoft Excel: Managing and Analyzing Data (Sorting, Filtering, Subtotals) (IME561H)

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

Do More With Excel Than Just Calculating Data—Sort, Validate, Analyze, Filter, Subtotal & More

According to a survey, Microsoft claims that around 70% of users use Excel to maintain a large lists or database. In order to be truly apt in Excel, you need to be familiar with the tools to manage data efficiently. It has become all the more essential as you are getting burdened with huge amount of data with data collection becoming more automated. However, what do you do with all the data?

You should know how to sort the data, create quick subtotals, filter what you want to see, erase bad or redundant records and restructure fields with too much data. You should know the powerful validation tools that keep out bad data from the start and learn how to drastically reduce data entry with drop-down clickable lists while setting up new lists.

You can do a lot more with Microsoft Excel worksheets besides just calculating data – you can handle powerful data management needs easily. With just a little knowledge, you can utilize the power of Excel to sort data (based on color, content, or icon), validate data, use powerful expanded features to examine the data in any list, regardless of size.

Attend this session by our expert speaker Dennis Taylor and learn the most efficient and quickest ways to sort, validate, analyze, reorganize and filter data regardless of size. Also learn to reorganize columnar data that has not been grouped properly, insert automatic subtotals and filter the data to view just what you need to.

Session Highlights:

  • Re-organize columnar data that has been grouped improperly with the Text to columns feature or Flash Fill
  • Excel the myriad ways of filtering data to show just the data you require
  • Erase duplicate records from a big database
  • Add a row of subtotals in a sorted list without tirelessly creating new formulas and rows
  • Form drop-down lists to increase data entry with improved consistency and accuracy
  • Convert lists into tables – gain easier data-handling and enhanced visual features
  • Learn essential functions that will help you in understanding your data – COUNTIF, SUMIF, and more

Who should attend?
Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar

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: Microsoft Excel: Managing and Analyzing Data (Sorting, Filtering, Subtotals)
    Presenter(s): Dennis Taylor Protection Status