Advanced Excel Objectives

1. Identify the steps needed to create a PivotTable.

2. Use Row Labels to filter the data.

3. Use the Field Settings to Count Values.

4. Pivot the Table!

5. Format the PivotTable and Pivot Table Reports.

Download this lesson as a PDF file

PivotTables: What Happened? (eBook PDF)

Download the Sample Files as a zipped folder, below:
Customer Sales 2013.xlsx
Brown Bag Lunch Sales Team.xlsx