PivotTable Tools->Design


1. Readings
Read Lesson 3 in the Advanced Excel guide, page 83-116.



A spreadsheet that works with PivotTables in Excel. This lesson shows how to present data visually, format data as a PivotTable and display the Totals.



Sales Data 2010.xls

Brown Bag Lunch Sales Team.xlsx


2. Practice

Complete the Practice Activity on page 117.


3. Assessment

Review the Test questions on page 118.


Lesson 3: Pivot Tables: What Happened?


PivotTable Tools->Options