ZogoTech UserGroup
Pivot Table Training
September 19, 2012
Resource 1:
http://www.dummies.com/how-to/content/the-essentials-of-excel-2010-pivot-tables-and-pivo.html
The Essentials of Excel 2010 Pivot Tables and Pivot Charts
How to Create a Pivot Table in Excel 2010
How to Format an Excel 2010 Pivot Table
Resource 2:
http://www.addictivetips.com/windows-tips/office-excel-2010-tutorial-pivot-tables/
What Is A Pivot Table?
The Pivot tables are used to summarize, analyze, explore and present your data. A Pivot table is a
way to extract data from a long list of information and present it in a more meaningful and user
friendly understandable format. For example, let’s say that we have the data of student scores in a
spreadsheet, you could turn this into a pivot table, and then view only the Math scores for each pupil.
How To Create A Pivot Table In Excel 2010
Here are the steps to create a Pivot table in Excel 2010.
Step 1: First of all, please make sure to select the data range for which you want to make the pivot
table.