Microsoft Excel : Pivot Tables

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.

Resources:

Excel 2007

Wang, W. Office 2007 for Dummies, available from the Knowledge Network. Part III, Chapter 9, pp192-202 - Organising Lists in Pivot Tables.

Excel 2010

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: