A Pivot Table in Excel is a summary table based on a list of data; it is distinct and separate from the original data, yet dependent on it. Changes you make to a Pivot Table have no impact on the original data. With a Pivot Table, you can find trends, analyze patterns, and complete multiple summaries based on your detailed (and sometimes voluminous) worksheet data.
In order to manage large data lists, there are many types of Excel tools available like sorting, filtering etc. However, if you need to analyse every data and do it fast, then PivotTable is your answer. PivotTable in Excel will assist you in creating compact summary reports without the requirement of writing complex formulas depending on long techniques. The PivotTable feature is probably one of the best analytical tool of Excel, which adds to its speed. You will be able to get good dynamism and flexibility which will help you quickly change the data interrelationships that you are viewing. Many of the users of PivotTable find the feature very easy to understand and learn; however, it is not so easy if you are just viewing the instructions from a printed page. The feature is visually-oriented and is based on displaying fields in different locations.
To get more powerful techniques of PivotTable like calculated fields, slicers, conditional formatting and timelines, attend this session by expert speaker Dennis Taylor. You will be able to make PivotTables from different input sources and use different options like conditional formatting, slicers etc. effectively.
You will learn the best and easiest ways to create PivotTables, 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