Excel Video Tips
|   Home    |    Excel    |    Access   |   Word   |   Outlook   |  VBA   |   Downloads   |   Index   |
Excel Video Tips...
 
Download the Sample File

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.

Salaries.zip [95KB]

 

Excel Pivot Tables #1

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.

 

^ top