PivotTables

Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Create a PivotTable using the data in the workbook.
  3. Experiment by placing different fields in the rows and columns areas.
  4. Filter the report with a slicer.
  5. Create a PivotChart.
  6. If you are using the example, use the PivotTable to answer the question, Which salesperson sold the lowest amount in January? Hint: First decide which fields you need in order to answer the question.