Microsoft Office Tutorials and References
In Depth Information
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.
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.