It is quite easy to manage large database-like lists in Excel as it has a variety of tools such as sorting and filtering to manage those lists. However, if you’re in a hurry and need to analyze all data quickly, a PivotTable is unbeatable. You’ll be amazed to see how in very less time, you can create a complete summary report with tons of data and you won’t even require to write complex formulas and rely on obscure techniques. Perhaps the Excel’s best analytical tool, it has amazing speed, provides perfect flexibility and dynamism which lets you quickly change the data interrelationships you’re viewing. PivotTable 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 dragging fields to different locations - this webinar by expert speaker Dennis Taylor shows you a wealth of display variations that can readily be displayed on the printed page. Now you can effortlessly organize and analyze tons of data in a matter of minutes. In this webinar you’ll learn:
This presentation will be made using Excel 2010; if you use either version 2007 or 2013, this session will still be valuable, because there are only a few differences between these different versions.
Who Should Attend
Any Excel user who wants to needs techniques to analyze lists of data. Although widely used with financial data, you can create PivotTables 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