The PivotTable function in Microsoft Excel is an organization and analysis tool that displays fields and records. It's an interactive worksheet that allows you to summarize large amounts of information. Pivot tables allow you to transform a set of data into an easy-to-arrange and organized summary grid. The grid of information it produces helps you quickly find patterns, trends and outliers. In fact, when you hear the words "slice and dice," you should instantly think pivot tables. Most commonly used in spend analytics and response evaluations.