After working with several PivotTables, you will now have an opportunity to practice and reinforce your skills by creating a PivotTable based on the data in the BudgetData worksheet. You will group all four of the campuses and then summarize the three different types of expenditures for each quarter.
Your completed PivotTable should look similar to this:
Use the following guidelines to create your own PivotTable.
Step1. Create the PivotTable from the BudgetData worksheet. Place the PivotTable in a new worksheet and name the sheet Challenge Exercise.
Step2. Format the values as currency.
Step3. Apply a style.
Step4. Change the heading names to: Salary Expenditures, Travel Expenditures, and Supply Expenditures.
Step5. To view the solution worksheet,
Click the BudgetTotal worksheet tab
NOTE: For additional practice, return to Challenge Exercise 1: Adding Max and Min Fields to the PivotTable and display the salary expenditures for each campus for Quarters 1 and 2 only. Then create a pivot column chart comparing salary expenditures for both quarters for all four campuses.