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.
Part two of three tutorials introducing Pivot Tables in Excel
2007/2010. It demonstrates how to format numbers and text in a pivot
table, add or remove grand totals and use the Design tools to select
a color scheme.