Mix: Pivot Tables and Charts in Excel
A collection of tutorials, manuals and videos that take you from understanding what a Pivot Table is for through to being able to create and optimise your Pivot Tables and Pivot Charts.
What is a Pivot Table?
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one - A step by step guide on how to create a PivotTable in Excel 2007. It includes video clips of how to create a PivotTable and allows downloading of a demo file to practice the steps and create the PivotTable.
What is a Pivot Table? -A text-heavy but clear explanation of the purpose of Pivot Tables in Excel. Useful for anyone who wants to understand why they might want to use the feature and what kinds of analysis it could enable them to do.
Music Video! Pivot Tables Make Everything Just Right - A very silly song created by some students. Useful for people who are drowning in data and need something to laugh at....as well as a little bit of an explanation of why a Pivot Table is a marvellous thing.
If you use Excel 2000 - 2003
Excel 2003, Pivot Table Tutorial Part 1 - A clear step-by-step guide, with downloadable example to work along with. Explains why you might want to create a Pivot Table and goes on to detail the steps to achieve this. Useful for anyone who would like to group and find trends in a large Excel database.
Excel 2003 - Pivot Tables Part 2 - Creating Balance Summary - Part 2 of the video tutorial. Taking a specific example. A clear explanation of the kind of results you can achieve with a Pivot Table and a step-by-step explanation of how you achieve this. Useful for anyone who has a Pivot Table and would like to alter the way it summarises data.
Excel 2003 - Pivot Tables Part 3 - Formatting - A video tutorial on formatting Pivot Tables and using calculated fields. Useful for anyone who has created their Pivot Table and would like to enhance both its look and functionallity.
Excel 2003 - Pivot Charts - A clear, step-by-step manual explaining how to create and edit Pivot Charts in Excel. Useful for experienced users of Excel.
If you use Excel 2007 - 2010
Excel 2007/2010: Create A Pivot Table - A lighthearted (and cheesy) video to show how to create a Pivot Table in Excel 2007 or 2010. Useful for the details on how to lay out your data before you create the table. But probably needs to be used alongside a more detailed step-by-step guide.
How to create a PivotTable in Excel 2007 - A step-by-step guide to creating a PivotTable in Excel 2007. A good place for people to start who are new to creating PivotTables.
Working with PivotTables in Excel 2010 - A step-by-step guide to creating PivotTables in Excel 2010 and manipulating them. Clear screenshots showing each step. A good guide for someone new to PivotTables or someone looking for more depth on how to Group, change Formats etc.
Excel 2007 - Creating Pivot Tables - A very clear, eLearning module with video and a downloadable example to try. Takes you through the process of creating a Pivot Table from scratch. Useful for people who want to interpret trends and analyse large sets of data.
Excel 2010: Creating Pivot Tables - A very clear, eLearning module guide to creating Pivot Tables and Pivot Charts in Excel. Contains links to videos and a downloadable example to practice on. Useful for anyone who would like to learn how to analyse their data this way.
Optimising your Pivot Tables
Excel Pivot Table tricks to make you a star - 5 great tips on how to maximise your use of Pivot Tables in Excel with text and animated screenshots to show you how each tip works. Great for people who already create Pivot Tables but would like to extend their knowledge.