PivotTable analysis
Answer a manager’s question with a PivotTable, the way analysts really do it.
1. Download your workbook
Each download has its own data, so your answers are yours alone.
2. Do the work in Excel
- Build a PivotTable. Create a PivotTable from the Data sheet, on a new sheet, with Region as the rows and Sales as the values, summed.
- Answer the question. On the Answer sheet, type the name of the region with the highest total sales into B2.
- Show the number. In B3, type or link to that region’s total sales.
Save the file as an Excel Workbook (.xlsx) when you’re done.