Comma Training Page 155

Analyze: Refresh

Say business is good and a lot of new customers were added today. The beauty of working with PivotTables and PivotCharts is how easy it is to update them.

Before You Begin: Remove All Filters:
Go to the Slicers spreadsheet.
Select the PivotChart.
Remove the Filters on the Slicers and the Timeline.

1. Try it: Add More Data

Go to the Original Data spreadsheet.

Select the last two Rows: Row 68 and 69.

Go to Home->Clipboard->Copy.

Select Cell A70.

Go to Home->Clipboard->Paste.

The data in this example has been updated. There are now two more Breakfast Buffets in the records.

Did the PivotTable update?
Let's find out.

Keep going...