Analyzing Data Visually

PivotTables: What Happened?

graphic2

 

graphic1

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

Watch the video.


Project

This lesson shows how to present data visually, format data as a PivotTable and display the Totals.

 

Downloads

Customer Sales 2013.xlsx

Brown Bag Lunch Sales Team.xlsx

 

2. Practice

Complete the Practice Activity on page 117.

 

3. Assessment

Review the Test questions on page 118.