My Shopping Cart
There are no items in your shopping cart.

Analyze Data with Excel's Most Dynamic and Powerful Analytical Tool - PivotTables (IME5309)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, May 2, 2013
Event Description

Deriving maximum value from Excels PivotTables

Microsoft Excel offers a variety of tools and techniques to sort and filter data. But among them, PivotTable is the best enabled feature allowing you to analyze data. There is no need to create complex excel formulas as you can easily view compact summary report generated through PivotTable.

Join Dennis Taylor, for a sizzling 60 minutes afternoon session Analyze Data with Excel′s Most Dynamic and Powerful Analytical Tool - PivotTables to understand and grasp PivotTable dynamics. He will walk you through on ways to rapidly change displays, data interrelationships and analyze loads of data.


  • How to compare two or more fields in a variety of layout styles
  • How to sort and filter results
  • How to perform ad-hoc grouping of information
  • How to use Slicers instead of filters to identify which field elements are being displayed
  • How to drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a Pivot Chart that is in sync with a PivotTable
  • How to add calculated fields to perform additional analysis
  • How to hide/reveal detail/summary information with a simple click
  • How to deal with dynamic source data and the “refresh” concept

Here is a quick peep into the engaging and informative session:

  • Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
  • Creating a PivotTable with a minimum number of steps
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Using Slicers to accentuate field elements currently being shown (and which ones are not)
  • Creating ad hoc and date-based groupings within a PivotTable

Register now to learn the best feature available in Microsoft Excel- PivotTable. After attending this webinar, you will be able to effortlessly sort and analyze volumes of data.

About Our Speaker(s)

Dennis Taylor, Microsoft Excel Training ExpertDennis Taylor
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

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Analyze Data with Excel's Most Dynamic and Powerful Analytical Tool - PivotTables
    Presenter(s): Dennis Taylor Protection Status