Microsoft Office Tutorials and References

In Depth Information

**Using formulas**

Figure 78-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.

Note

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.