PivotTables are powerful tools that can help you analyze your data in a variety of ways and from a variety of perspectives. You specify to Excel 2013 how you want to display the data in the PivotTable and then—here’s the pivot part—you can easily change the data to display the information in different ways within the same table.
Click a cell within the range that you want to summarize.
Click the Insert tab.
Click Recommended PivotTables.
In the Recommended PivotTables dialog box that opens, click the PivotTable that you want to create.
The great thing about adding a ...