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.
Comments
0 comments
Please sign in to leave a comment.