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.