Pivot tables are one of several Excel tools for extracting meaning out of large groups of numeric data. They can be applied whenever raw data in a spreadsheet or database has to be summarized.

Here, we show you how to create a pivot table in Excel to take advantage of one of the application’s most powerful tools. Before we start, just what exactly are pivot tables good for?