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


Excel Pivot Tables: Your Key to Easy Data Analysis (IMEO08B)

Presented By : Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Audio Conference
60 minutes
  •  Fri, January 11, 2013
Event Description

Find out how to use Excel pivot tables to quickly and easily create summary cross-total information without altering your original data!

If you need to analyze rows and rows of data, we have the perfect solution! Excel pivot tables extract just the data you need from a long list of information, and present it in a readable form, quickly and easily! IF — that is — you know how to make Excel do the work for you. Our Excel guru Dennis Taylor is here to help you understand and utilize all of Pivot table's capabilities plus dozens of data display and manipulation features. Now you can effortlessly organize and analyze tons of data in a matter of minutes!

Objective:

To help you quickly organize and analyze huge amounts of data through Pivot tables.

At the end of the conference you'll be able to:

  • Compare multiple fields
  • Change row and column layouts
  • Sort and filter results
  • Perform ad-hoc grouping of information
  • Drill down to see the details behind the summary
  • Categorize date/time data in multiple levels
  • And more techniques to customize pivot tables!

Conference Outline:

  • The fastest way to create a Pivot Table – just 3 mouse clicks and a few mouse drags!
  • The drill-down concept — how to instantly see the detail records that comprise a summary total.
  • How to sort Pivot Table data based on field names or content without lengthy command sequences.
  • How to analyze date data by month, quarter or year.
  • How to spontaneously group data to reveal new summary information that isn't in the source 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: Excel Pivot Tables: Your Key to Easy Data Analysis
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status