Analyze data dynamically in PivotTables

Open the CreatePivotTables workbook in Excel, and then perform the following tasks:

Select a cell in the Excel table on Sheet$1$ and create a PivotTable

based on that data.

In the PivotTable Fields pane, add the Year field to the Columns area, the

Center field to the Rows area, and the Volume field to the Values area.

Pivot the PivotTable so the Year field is above the Center field in the Rows area.

Filter, show, and hide PivotTable data

Open the FilterPivotTables workbook in Excel, and then perform the following tasks:

Using the Month field, create a selection filter that displays data for

January, April, and July.

Remove the filter.

Add the Weekday field to the Filters area and limit the data shown to Tuesday.

Change the Weekday field's filter to include multiple values, and then

set it to display values for Tuesday and Wednesday.

Create a slicer for the Month field, and then display values for

the month of December.

Change the slicer filter to allow multiple selections, and then display values for

January and December.

Clear the slicer filter, and then delete the slicer.