This is a recording of the October 2019 monthly webinar in the Excel MVP Webinar series. In this free 59-minute webinar, Bill Jelen covers many pivot table techniques:<\/p>\n

Table of Contents
\n(1:36) Traditional Pivot Cache Pivot Tables
\n(2:45) Setting up data for a successful pivot table
\n(3:40) Using Alt+Enter for headings
\n(4:00) Avoiding tiny blank columns between columns
\n(4:15) Accounting Style Underlines
\n(5:35) Pivot Table 101 \u2013 Your First Pivot Table
\n(7:55) Changing Number Format in Pivot Tables
\n(8:35) Moving fields around in a pivot table
\n(9:40) Drill-down on any pivot table number
\n(10:45) Refreshing pivot table if the underlying data changes
\n(11:25) Year-over-Year Pivot Tables \u2013 Grouping Dates
\n(14:05) Adding a formula outside the pivot table and problems with GetPivotData
\n(16:15) Variance percentage with % Change From Previous
\n(18:00) Top 10 Pivot Table – Introduction
\n(18:15) Changing heading from Sum of Revenue
\n(18:45) Changing the calculation in a pivot table
\n(19:10) Double-click a field heading to open Field Settings dialog
\n(19:20) Percentage of Column Total
\n(19:40) Rank column in a pivot table
\n(20:00) Running Total in a pivot table
\n(20:35) Filtering to Top 10
\n(21:45) Grand Total seems to be wrong after filtering
\n(22:10) Include Filtered Items in Totals is greyed out
\n(22:55) Dan in Philadelphia has a solution
\n(23:25) AutoFiltering a Pivot Table using a Hack
\n(25:30) Filtering using the Filter drop-zone
\n(25:45) The pain of (Multiple Items) header and Shrink to Fit
\n(26:25) Replacing Filter area with Slicers
\n(26:45) Resizing slicers
\n(27:30) Replicate a pivot table for each customer (Szilvia)
\n(28:50) Tabular form instead of Compact Form
\n(29:55) Suggesting changes to the Excel team with Excel.UserVoice.Com
\n(30:20) Defaults for all future pivot tables
\n(31:30) Data Model Pivot Tables – Introduction to Part 2 of Webinar
\n(32:30) Mash up data from multiple sheets into one pivot tables using the Data Model
\n(35:55) Count Distinct in a pivot table
\n(37:35) True Top 10 Report With Correct Total without any hacks
\n(39:30) Median in a Pivot Table using DAX formula
\n(41:35) Showing Text in the values area of a Pivot Table
\n(45:25) One set of Slicers for two different data sets
\n(48:25) Create a Pivot Table on a Map using 3D Map in Excel
\n(52:10) Is there a use for GetPivotData?
\n(57:20) Recap
\n(58:49) Pitch for next month’s Liam Bastick webinar<\/p>\n