Excel and Pivot Tables
WICshop handout December 2009
Presenter: Anu Vedantham
Description: We will explore Pivot Tables in Excel - a powerful way to analyze large datasets. We will use Adobe Connect Pro for the online session. This is our first online workshop. We recommend a headset with microphone for participation but you can also participate using a computer that has speakers.
Available online at http://wic.library.upenn.edu/multimedia/tutorials/excelpivot.html
Acrobat Room: https://pennlps.na4.acrobat.com/pennwic (Login as Guest with your full name)
Questions? Email firstname.lastname@example.org or stop by the Weigle Information Commons. The Library ITA can help with Excel questions.
*Data is from a training spreadsheet from the Microsoft website's Office 2003 training materials.
Online Resources - WIC has Lynda.com licenses for patron use in the Weigle Information Commons, and Lynda has an extensive online course on pivot tables. We have online tutorials on Excel Basics, Excel and Data Analysis, Excel Charts and Excel and Stats.