A Pivot Table is unique to Microsoft Excel. This type of table allows the end user to manipulate the rows and columns to enable different summaries with minimal effort. This is a great way to present data in a meaningful way. Before reviewing the resources below please check what version of Excel you have. You may also find further help and assistance by clicking the Help function in Excel.
An example data set and pivot table is attached for you to download and practice with.
Wang, W. Office 2007 for Dummies, available from the Knowledge Network. Part III, Chapter 9, pp192-202 - Organising Lists in Pivot Tables.
Grauer, R. T. Exploring Microsoft Office Excel 2010 - comprehensive, available online (Opens Athens login and password required) - this can be viewed online or downloaded as a PDF.
Here is an excellent 10 minute Youtube video detailing how to get started with Pivot tables:
ExcelFunctions.net Excel 2013 Pivot Table Tutorial
This Excel Pivot Table Tutorial provides a step-by-step guide on how to create pivot tables in Excel.