Tools such as Sorting and Filtering in Excel allow users to easily manage large lists of data. However, if you require analyzing every data quickly, PivotTable is the best available option. Based on the huge data, you can quickly create a compact summary report without the use of complex formulas or lengthy techniques.
The PivotTable feature is perhaps the best analytical tool in Excel. You get amazing dynamism and flexibility, in addition to its speed, which lets you to quickly change the data interrelationships that you are viewing. It has been noticed that most PivotTable users find the feature relatively easy to learn; however, not so easy if you are simply reading the instructions from a printed page. This is a visually-oriented feature which is based on displaying fields in various locations. You will be amazed to see how in very little time, you can create a complete summary reports with tons of data and you won’t even require to rely on obscure techniques or complex formulas.
In this session by expert speaker Dennis Taylor, you will learn the quickest and best ways to create PivotTables and Pivot Charts in Excel to analyze and represent data.
Who Should Attend?
Anyone familiar with many of Excel’s features, but who might have had little or no experience with using PivotTables is a good candidate for this course. Also, those users familiar with PivotTables but new to Excel 2013 or 2016 will benefit from this session as well. 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