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:
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.