Please re-create the pivot table below, using the following data set: Excel data.

If you get stuck, you should probably work through the Pivot table and charts activity in the DSC Excel workshop. If still stuck please ask the instructor for help.

Next Pivot Table tasks:

1. Sort the pivot table by the “Total” column.
2. Look at the categories in the pivot table and identify fields that should be combined or collapsed. Go to sheet #1 and search and replace the misspelled fields in the “data cat” field.
3. Create a chart based on the cleaned data now in the pivot table.

Questions to reflect on and discuss after completing the pivot table:

1. Why are there so many similar categories in the “data cat” field?
2. Could some categories be collapsed together to make the table (and any charts made from it) easier to read without losing any important information?
3. What are two or more other fields that it would be interesting to create pivot tables on?