Excel 2010

Challenge!

1. Open an existing Excel workbook. If you want, you can use this example.
2. Create a PivotTable using the data in the workbook.
3. Experiment with different Row Labels and Column Labels.
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.