Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.