Lesson 3: What Happened? (PivotTables)
Before You Begin: Download the sample spreadsheet:
Brown Bag Lunch Sales Team.xlsx.
Try This: Do the following steps
1. Open the
spreadsheet: Brown Bag Lunch Sales Team.xlsx.
2. Go to Sheet 1. Select Row 1 and remove the Filters.
3. Select Sheet 1 and Insert a PivotTable on a New
Worksheet.
4. Use the PivotTable Tools to Show the Field List
5. Edit the PivotTable Field list as follows:
Select the Field: Market (It should be placed in the Rows, by default).
6. Drag the Field Sales to the Values (It should be placed in the Values as Count of Sales)
Change Count of Sales to Sum of Sales
7. Select the Field: Sales Agent (It should be placed in the Rows, by default).
8. Move the Field: Sales Agent from the Rows to the Columns
9. Format Column B:G for Accounting.
10. Save this as YOUR NAME What Happened Practice.