ADVANCED MICROSOFT EXCEL Lesson 13 Creating PivotTables and PivotCharts

1
ADVANCED MICROSOFT EXCEL Lesson 13 Creating
PivotTables and PivotCharts
2
Objectives

• Create a PivotList and PivotTable report.
• Create interactive PivotTables for the Web.
• Create a PivotChart.

3
Terms Used in This Lesson

• Interactive
• PivotChart
• PivotTable

4
PivotList

• A PivotList is similar to a list. PivotLists are
  used to create PivotTable and PivotChart reports.

5
PivotTable
6
Interactive PivotTables
7
Interactive PivotTables (cont.)
Interactive PivotTable in a Web page
8
PivotChart Layout

• Simply drag the fields from the PivotTable Field
  List to the desired locations in the chart layout.

9
Completed PivotChart
10
Summary

• PivotTables let you quickly and easily rearrange
  and summarize data.
• PivotCharts are ideal for graphically
  illustrating the data in a PivotTable report.
• Excels interactive PivotTable feature lets you
  interact with PivotTable data in Microsofts
  browser program, Internet Explorer.