A Pivot Table is an interactive table that automatically extracts, organizes, and summarizes your data. You can use a Pivot Table to analyze the data, make comparisons, detect patterns and relationships, and discover trends.

This short video is taken from a recording of a webinar that I delivered in 2012 where I demonstrated how to create and use Pivot Tables in Excel 2011 for Mac.