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

Mastering Excel 2013 PivotTables (IMED50X)

Presented by: Dennis Taylor
Request Replay Date:
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
60 minutes
  •  Wed, December 9, 2015
Event Description
See the sneak peek before you buy!
1.0 CPE

Learn Powerful PivotTable Techniques, Like Slicers, Timelines, Calculated Fields, And Conditional Formatting!

Excel consists of a wide range of tools like filtering and sorting that are used in managing big data; however, if you need to go through all the data and analyze it quickly, PivotTable is the best feature for it. You can create a very compact summary report (based on tons of data) within no time without having to write complicated formulas or relying on lengthy time consuming techniques. Besides the speed of the PivotTable, that is perhaps Excel’s best analytical tool, you get amazing dynamism and flexibility that allows you to change the data interrelationships viewed by you very quickly. This feature is very easy to learn, as observed by most PivotTable users; however, it is not that easy if you are plainly following the instructions provided on a printed page. It is a visually-oriented feature that is based on displaying fields on different locations.

In this webinar, our expert speaker Dennis Taylor will show you more powerful PivotTable techniques, like Timelines, Slicers, Conditional Formatting, and Calculated Fields.

Session Highlights:

You will learn the quickest and best methods to create PivotTables, including these capabilities:

  • Compare multiple fields across various layout styles.
  • How to sort and filter results
  • Ways to execute ad-hoc grouping of information
  • Identify which field elements are being displayed by using slicers instead of filters
  • How to use a Timeline for dynamic time-based displays
  • How to adopt an in-depth approach to get more the summary
  • Methods to classify the timing information at multiple hierarchies
  • Making Pivot Charts and syncing them to Pivot Tables
  • Performing added analysis through using calculated fields
  • How to conceal or display the summary information with one click
  • Using ‘Refresh’ and dealing with dynamic source data
  • Using data from many worksheets to make a PivotTable
  • Conditionally formatting the data of a PivotTable
  • Accentuating field elements - whether visible or not - using Slicers
  • Getting to know the new Timeline feature
  • Constructing date-dependent and ad hoc collections of data inside PivotTables
  • Exploring the best techniques for updating PivotTables
  • Using Conditional Formatting with PivotTable data

Who should attend?

Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data. Anyone needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this course.

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

We Also Recommend
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Mastering Excel 2013 PivotTables
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status