Pivot Table Tools
Dr. Tina Manos is a professor at Cal Poly Humboldt. She took an economics class on campus (professors get to do that) and she liked it so much that she decided to get a second degree in economics! She is very passionate about teaching, and put together this excellend tutorial on Pivot tables.
Pivot tables in Excel are an important tool used by many businesses. They are used to summarize, sort, reorganize, group, count, total or average data stored in a database. Users can transform columns into rows and rows into columns (hence the term “pivot table”). Users can query large amounts of data in user-friendly ways, subtotal and aggregate numerical data, and summarize data by categories and subcategories. (Users can also filter, sort, group and conditionally format useful and interesting subsets of data.) So, with Pivot Table, you are able to “slice and dice data” to present it in a meaningful way.
Developing proficiency with Pivot tables can give you a leg up on the job market! The video Tutorial and the Guide to Using Pivot Tables document walk you through a workshop that allows you to apply what you learn using the Data Set below.