Excel consists of a wide range of tools like filtering and sorting that are used in managing big data; however, if you need to go through all the data and analyze it quickly, PivotTable is the best feature for it. You can create a very compact summary report (based on tons of data) within no time without having to write complicated formulas or relying on lengthy time consuming techniques. Besides the speed of the PivotTable, that is perhaps Excel’s best analytical tool, you get amazing dynamism and flexibility that allows you to change the data interrelationships viewed by you very quickly. This feature is very easy to learn, as observed by most PivotTable users; however, it is not that easy if you are plainly following the instructions provided on a printed page. It is a visually-oriented feature that is based on displaying fields on different locations.
In this webinar, our expert speaker Dennis Taylor will show you more powerful PivotTable techniques, like Timelines, Slicers, Conditional Formatting, and Calculated Fields.
You will learn the quickest and best methods to create PivotTables, including these capabilities:
Who should attend?
Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data. Anyone needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this course.
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