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


PivotTables: Beginners to Intermediate (IME840H)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, August 20, 2014
Event Description
See the sneak peek before you buy!
 

Learn in Detail about PivotTable: The Ace Analytical Tool of Excel

It is quite easy to manage large database-like lists in Excel as it has a variety of tools such as sorting and filtering to manage those lists. However, if you’re in a hurry and need to analyze all data quickly, a PivotTable is unbeatable. You’ll be amazed to see how in very less time, you can create a complete summary report with tons of data and you won’t even require to write complex formulas and rely on obscure techniques. Perhaps the Excel’s best analytical tool, it has amazing speed, provides perfect flexibility and dynamism which lets you quickly change the data interrelationships you’re viewing. PivotTable users discover that the feature is relatively easy to learn, but not so easy if you are simply seeing the instructions on the printed page; this is a visually-oriented feature based on dragging fields to different locations - this webinar by expert speaker Dennis Taylor shows you a wealth of display variations that can readily be displayed on the printed page. Now you can effortlessly organize and analyze tons of data in a matter of minutes. In this webinar you’ll learn:

  • 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 drill down to see the details behind the summary
  • How to categorize date/time data in multiple levels
  • How to create a PivotChart 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
  • How to use the new (in Excel 2010) Slicer feature to filter results more efficiently

This presentation will be made using Excel 2010; if you use either version 2007 or 2013, this session will still be valuable, because there are only a few differences between these different versions.

Training Objective:

  • 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
  • Creating ad hoc and date-based groupings within a PivotTable
  • Exploring the best techniques for updating PivotTables
  • Filter PivotTable layouts with the new Slicer capability

Who Should Attend

Any Excel user who wants to needs techniques to analyze lists of data. 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.

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: PivotTables: Beginners to Intermediate
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status