Slicers are a great tool for filtering a data set or PivotTable. Learn how to use one slicer to manipulate more than one PivotTable or PivotChart.

Refresh or change the data source of your pivot table If you have updated the original database with new details, you need to refresh the generated pivot tables.

A couple of easy changes can greatly enhance the visual impact of a slicer. This walk-through shows you how.

If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.