Refreshing a Pivot Table and Pivot Chart

Refreshing a Pivot Table and Pivot Chart This quick video explains how you Refresh the Data in your Pivot Table and Pivot Chart. Pivot Tables do not refresh automatically if the underlying data is changed. Producing a new Pivot Table is a memory and time consuming...

Drill down lists

Drill Down Lists This quick video explains Drill Downs on a Pivot Table in Excel. Once we have a Pivot Table we can view the summary data. As we view the summary data we may wish to drill-down and view more information underlying the pivot table. We can drill down on...

Slicer tool

Slicer Tool This quick video explains how to use the Slicer Tool to view Data in Excel. The Slicer Tool provides powerful ways of looking at Data in a Pivot Table in different ways. Its new since Excel 2010 but very popular with Pivot Table users. [et_social_follow...

Multiple headings in table

Multiple Headings in a Pivot Table This quick video explains how to have Multiple Headings in a Pivot Table. We can add additional fields to create additional columns and rows to our Pivot Table. This creates different levels of grouping within our pivot table....