Excel has a variety of tools like sorting and filtering to manage large lists of data, but if you need to analyze all that data and do it quickly, there's no better feature than a Pivot Table. You can quickly create a compact summary report (based on tons of data) without needing to write complex formulas or rely on lengthy techniques. The Pivot Table feature is perhaps Excel's best analytical tool and in addition to its speed, it lets you quickly change the data interrelationships you're viewing. Most Pivot Table users discover that the feature is relatively easy to learn, but not so easy if you are simply seeing the instructions on the printed page; this is a visually-oriented feature based on displaying fields in different locations.
In this webinar, Dennis Taylor will show you how to rapidly change displays, via the Slicer tool, so that you can effortlessly organize and analyze a lot of data in a matter of minutes.
Here's a look at what Dennis will cover:
The program will help you:
Who should attend?Any Excel user who needs techniques to analyze lists of data. Although widely used with financial data, you can create Pivot Tables based on a variety of source data – the feature is potentially valuable to nearly all Excel users.
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