Pivot Table Subtotal Videos

How to format the data in pivot table subtotals, add multiple subtotals, create custom subtotals, and links to other Excel videos

Date Format in Subtotals

Use slicers in Excel 2010 to filter one or more pivot tables. Quickly see the filtered items, and identify the dependent items in another slicer.

For detailed instructions and to download the sample file, see Pivot Table Subtotals.

Show Multiple Subtotals in Pivot Table

Excel pivot table subtotals are automatically created when you add more fields to Row and Column areas. This video shows how to change summary function, and create multiple subtotals

Custom Subtotals and Calculated Fields

In this short Excel video tutorial, you can see how to create custom subtotals for the inner and outer pivot table fields.


More Excel Videos

Excel Videos - Index

Mouse Shortcuts

Pivot Table Tips


Paste Special


Get weekly Excel tips from Debra


Last updated: July 10, 2021 8:06 PM
Contextures RSS Feed