Microsoft Office Tutorials and References

In Depth Information

**Using formulas**

Figure 103-3:
This pivot table calculates the averages without using formulas.

Unlike a formula-based solution, a pivot table doesn’t update itself automatically if the

data changes. If the data changes, you must refresh the pivot table. Just right-click

any cell in the pivot table and choose Refresh from the shortcut menu.

The pivot table in this example is extremely simple, but it’s also very easy to create. Pivot tables

can be much more complex, and they can summarize massive amounts of data in just about any

way you can think of — without using any formulas.