Create a Pivot Table on a new worksheet that shows the average cost by Year and Month. Make it possible to filter it by the different types.

Open the Pivots.xlsx Excel table.

1) Create a Pivot Table on the Data worksheet to show the number of different items.

2) Create a Pivot Table on a new worksheet that shows the total cost by the Type
and then by the Item Name.

3) Create a Pivot Table on a new worksheet that shows the average cost by Year
and Month. Make it possible to filter it by the different types.

4) Add a random attribute for all the items. The cloth could be either black, white, or
colored, the food could be normal, dietary, or budget, and the drink could be small,
medium, or large.

5) Create a Pivot Chart on a new worksheet that shows the maximum cost by the
Item Name. Make it possible to filter it by the different attributes.

6*) Use Power Pivot to create a Pivot Table on a new worksheet that shows the total
cost by each Part, Region and County

Last Completed Projects