A pivot table is a quick and easy way to summarize a large table of data. Here’s a short video in which I show you the steps for creating a simple pivot table in Excel 2007. ______________ For more pivot table and Excel tips visit the Contextures website.

With a running total in a pivot table, you can see how amounts accumulate over a period of time, or through a range of products, as shown in the short video below. In the video, the pivot table contains monthly sales figures for several products, and we’ll create a running total by month. In the [...]