Pivot Table Tools

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.


Guide to Using Pivot Tables


Pivot Table Tutorial

Pivot Table Tutorial