The previous lesson described how to create a pivot table and arrange the data in it. This lesson will carry on from lesson 1.2, and explore other ways you can manipulate and present PivotTables, and their data.

In this lesson we will discuss how to modify PivotTable calculations, how to format a PivotTable, and how to refresh PivotTable data. You will also learn how to create a chart from a PivotTable, and how to create a PivotTable using External data. In the Practice exercise, you will add data to a PivotTable, format the PivotTable Data, change PivotTable calculations, and create a chart from the PivotTable.