Training Packages

Excel Pivot Tables: Harness the Power of Your Data

Many Excel users, even those at the intermediate level, tend to not use one of Excel's most powerful tools out of the belief that they are more complicated than they really are.  Pivot Tables are one of the most powerful tools available to you today for harnessing large data sets for analysis and for display.  Join Excel expert David Ringstrom as he takes you step-by-step through how to create pivot tables and removes and apprehension you may have previously had.  Once you start using pivot tables you will wonder how you ever lived without them.

In part 1 of this 3 part package David will teach you how to format your data quickly and easily so it is in the required format for pivot tables.  You can avoid a great deal of frustration as he walks you through the nuances of pivot table formatting that will set you up for success from the start.  You will also easily be able to add and remove fields from your pivot table and customize it to meet your needs.  After part 1 you will feel completely comfortable creating your own pivot tables and making them function as you need.

In part 2 of this pivot tables package David will go beyond the basics and provide information on the Power Pivot and Recommended PivotTables features, among others.  By the end of this program you will be able to create self-updating titles for charts, expand and collapse pivot table elements and drill down into numbers with a simple double-click.  You will walk away with a firm grasp on pivot tables and all of the nuances that come with them.

The third party in the series is presented by Excel expert, Mike Thomas, and focuses exclusively on the Power Pivot Excel Add-In.  As your knowledge of pivot tables grows you may find that their are certain limitations and the Power Pivot add-in can remove some of those limitations and frustrations.  You will learn how to use the Data Model to create and manage relationships and how to create a pivot table from related Excel tables.

Webinars

Package Details$399

  • Webinars: 3 in this package
  • Available Credits: CPE (4)
  • Industry: Software
  • Purchase Package


"This information was extremely helpful and the presenter really was an expert in Excel. I will definitely be able to use this webinar in my work."

- Aurora Attendee


Preview Videos


Guest Speakers

David Ringstrom

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on&nbsp... View Full Profile

Mike Thomas

Mike Thomas

Mike Thomas has worked in the IT training business for 26 years. His expertise and experience covers designing and delivering training courses, creating written training materials (Quick Reference Guides and step-by-step tutorials), recording and editing video-based tutorials and providing support to users. He is a subject matter expert in a range of Microsoft technologies including Microsoft Office, Lync/Skype for Business and SharePoint. He has extensive experience of working with Cloud-based ... View Full Profile