Pivot table fundamentals -- Creating a basic pivot table -- Customizing a pivot table -- Grouping, sorting and filtering pivot data -- Performing calculations in pivot tables -- Using pivot charts and other visualizations -- Analyzing disparate data sources with pivot tables -- Sharing pivot tables with others -- Working with and analyzing OLAP data -- Mashing up data with power pivot -- Dashboarding with Power view and 3D map -- Enhancing pivot tables with macros -- Using VBA to create pivot tables -- Advanced pivot table tips and techniques -- Dr. Jekyll and Mr. GetPivotData.