Sorting and filtering are among a variety of tools that Excel equips itself with, to manage large lists of data. However, if your purpose is to analyze all that data and be quick at that, PivotTables are a unanimous choice. A compact summary report (based on tons of data) can be quickly created, and you don’t need to rely on either lengthy techniques or write complex formulas. Perhaps on the best analytical tool is PivotTable and it provides you amazing flexibility and dynamism other than speed, which lets you quickly change the data interrelationships you’re viewing.
Most users of the PivotTable discover that the feature is easily learned. However, it’s not that easy to only simply look at instructions on a printed page and operate – rather you have to use this visually-oriented feature on the basis of displaying fields in different locations. It is amazing to find how little time it takes to write complex formulas and rely on obscure technologies.
Join this session by expert speaker Dennis Taylor to learn PivotTable, Excel’s best analytical feature, better. Know how to compare two or more fields in various style layouts, sort and filter results, perform information ad-hoc grouping etc. The session will also help you use Slicers rather than filters if you want to find out which field elements are displayed. You will understand the process of drilling down to see details behind summary and know how to create a Pivot Chart which is in sync with a PivotTable.
The webinar will explain how to categorize date/time data in multiple levels and add calculated fields to perform additional analysis. You’ll learn to hide/reveal information with a single click, deal with dynamic source data, ‘refresh’ concepts and create PivotTables based on data from multiple worksheets.
You will learn the quickest and best ways to create PivotTables and Pivot Charts, including these capabilities:
Who Should Attend
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