What is a Pivot Table in Excel?

A pivot table is a report found within the data menu of Microsoft Excel which allows you to extract, summarize, analyze and create reports using underlying data within excel spreadsheets.