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