If you would like to perform this
exercise with the same data you can download the sample file (Salaries.zip)
using the link below. The ZIP file contains two copies of the
Salaries workbook, one in .xls format for Excel 2003 and
earlier and one in .xlsx format for Excel 2007 and later.
The first of a three-part tutorial introducing Pivot Tables in
Excel 2007/2010. It demonstrates how to select data and summarize it
by using a Pivot Table, how to rearrange and filter the table and
how to "drill down" to display the source data underlying any value
in the table.