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.
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:
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