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


Excel PivotTables: Using Excel's Best Analytical Feature (IME372J)

Presented by: Dennis Taylor
 
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Thu, April 13, 2017
Event Description
See the sneak peek before you buy!
 
1.0 CPE

Learn the Quickest and Best Ways to Create PivotTables and Pivot Charts.

Tools such as Sorting and Filtering in Excel allow users to easily manage large lists of data. However, if you require analyzing every data quickly, PivotTable is the best available option. Based on the huge data, you can quickly create a compact summary report without the use of complex formulas or lengthy techniques.

The PivotTable feature is perhaps the best analytical tool in Excel. You get amazing dynamism and flexibility, in addition to its speed, which lets you to quickly change the data interrelationships that you are viewing. It has been noticed that most PivotTable users find the feature relatively easy to learn; however, not so easy if you are simply reading the instructions from a printed page. This is a visually-oriented feature which is based on displaying fields in various locations. You will be amazed to see how in very little time, you can create a complete summary reports with tons of data and you won’t even require to rely on obscure techniques or complex formulas.

In this session by expert speaker Dennis Taylor, you will learn the quickest and best ways to create PivotTables and Pivot Charts in Excel to analyze and represent data.

Session Highlights:

  • Comparing two or more fields in a variety of layout styles
  • Sorting and filtering results
  • Performing ad-hoc grouping of information
  • Using Slicers instead of filters to identify which field elements are being displayed
  • Drilling down to see the details behind the summary
  • Categorizing date/time data in multiple levels
  • Ways 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
  • Dealing with dynamic source data and the “refresh” concept
  • How to create a PivotTable based on data from multiple worksheets

Key Takeaways:

  • Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
  • Creating a PivotTable with a minimum number of steps, including the new Recommended PivotTables option now available in Excel 2013 and 2016
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Using Slicers to accentuate fields currently being shown (and which ones are not)
  • Using the new (in Excel 2013) Timeline feature
  • Creating ad hoc and date-based groupings within a PivotTable
  • Exploring the best techniques for updating PivotTables

Who Should Attend?

Anyone familiar with many of Excel’s features, but who might have had little or no experience with using PivotTables is a good candidate for this course. Also, those users familiar with PivotTables but new to Excel 2013 or 2016 will benefit from this session as well. 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 SpeakerDennis 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 PivotTables: Using Excel's Best Analytical Feature
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status