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


Mastering Excel 2013 PivotTables (IME550H)

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

Master the use of PivotTable to Manage Large Amounts of Data from Multiple Sources.

MS Excel has the capability to sort and filter large lists of data through various tools-but the best tool that wins hands down when it comes to handling large amounts of data is the PivotTable. With PivotTables you can quickly create a compact summary report based on large amount of data without needing to write complex formulas or rely on lengthy techniques.

The PivotTable feature is Excel's best analytical tool. Not only is it fast, you also get the flexibility and dynamism to quickly change the data interrelationships. This session will make you realize how easy it is to learn using a PivotTable. But pivot tables are not all about simply seeing the instructions on the printed page-it is a visually oriented feature based on displaying fields in different locations.

This webinar with expert speaker Dennis Taylor will teach you some powerful PivotTable techniques to make your work easier and more efficient. You will learn to use Slicers, Timelines, Calculated Fields, and Conditional Formatting. You will learn the quickest and best ways to create PivotTables and become a Superhero in your workplace. Well, we just over-exaggerated the last one!

Training Objective

  • Creating PivotTables from multiple input sources (different worksheets and workbooks)
  • Accentuate, currently being shown (and which ones are not), field elements using Slicers
  • Using the new Timeline feature
  • Create ad hoc and date-based groupings within a PivotTable
  • Explore and learn the best techniques for updating PivotTables
  • Using Conditional Formatting with PivotTable data

This webinar will help you:

  • Compare two or more fields in a variety of layout styles
  • Sort and filter results
  • Perform ad-hoc grouping of information
  • Use Slicers instead of filters to identify which field elements are being displayed
  • Make dynamic time-based displays using a Timeline
  • Drill down to see the details behind the summary
  • Categorize date/time data in multiple levels
  • Create a Pivot Chart that is in sync with a PivotTable
  • Add calculated fields to perform additional analysis
  • Hide/reveal detail/summary information with a simple click
  • Learn to deal with dynamic source data and the "refresh" concept
  • Create a PivotTable based on data from multiple worksheets
  • Apply Conditional Formatting to 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 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 2013 PivotTables
    Presenter(s): Dennis Taylor

 
DMCA.com Protection Status