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 online, Athens username and password required (NHSGGC staff only).  Part III, Chapter 9, pp192-202 - Organising Lists in Pivot Tables - this can be viewed online or downloaded as a PDF

Excel 2010

Wang, W. Microsoft Office 2010 for Dummies, available online , Athens username and password required. Part III Chapter 10, pp213-226 - Organising Lists in Pivot Tables - 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:

Excel 2013

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.