Excel 2013

Challenge!

1. Open an existing Excel workbook. If you want, you can use the Lesson 27 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.