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


Mastering Excel Pivot Tables & Pivot Charts: Number Crunching Made Easy (IMEN30N)

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

Microsoft Excel's Magic Wand: Pivot Tables

Excel has a variety of tools like sorting and filtering to manage large lists of data, but if you need to analyze all that data and do it quickly, there's no better feature than a Pivot Table. You can quickly create a compact summary report (based on tons of data) without needing to write complex formulas or rely on lengthy techniques. The Pivot Table feature is perhaps Excel's best analytical tool and in addition to its speed, it lets you quickly change the data interrelationships you're viewing. Most Pivot Table 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 displaying fields in different locations.

In this webinar, Dennis Taylor will show you how to rapidly change displays, via the Slicer tool, so that you can effortlessly organize and analyze a lot of data in a matter of minutes.

Here's a look at what Dennis will cover:

  • Data preparation, so it is easily analyzed by Pivot Tables
  • Pivot Table creation with limited number of steps  
  • Changing the appearance of a Pivot Table by using dragging and command techniques
  • Usage of Slicers to enhance the field elements that are shown currently (also the ones which are not visible )
  • Creation of ad hoc and date-based groupings inside a Pivot Table
  • Identifying the top techniques for modifying Pivot Tables

The program will help you:

  • In comparing fields in numerous layout styles.  
  • In sorting out and filtering results
  • To perform the ad-hoc grouping of information
  • Understand the benefits of Slicers instead of filters to trace the fields that are being currently displayed.  
  • Drill down and identify the important details behind the summary
  • In categorizing date/time data in multiple levels
  • To develop and manage a Pivot Chart, compatible with a Pivot Table
  • In calculation of fields to help you do additional analysis
  • Guide you in hiding/revealing detail/summary information with the click of the mouse
  • In dealing with a dynamic source data and the “refresh concept”
  • Create a Pivot Table that is based on the data from several worksheets  

Who should attend?

Any Excel user who needs techniques to analyze lists of data. Although widely used with financial data, you can create Pivot Tables 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: Mastering Excel Pivot Tables & Pivot Charts: Number Crunching Made Easy
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status