Being able to analyze all the data in your worksheet can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. Excel can help you by recommending and then automatically creating PivotTables, which are a great way to summarize, analyze, explore, and present your data.
- Make sure your data has column headings or table headers, and that there are no blank rows.
- Click any cell in the range of cells or table.
- Click Insert > Recommended PivotTables.
- In the Recommended PivotTables dialog box, click any PivotTable layout to get a preview, and then pick the one that shows the data the way you want.
- Click OK.
Excel places the PivotTable on a new worksheet and shows the Field List so you can further rearrange the PivotTable data as needed.
- To zero in on the data and arrange it the way you want, you can filter and sort the PivotTable. See Filter data in a PivotTable and Sort data in a PivotTable.
In the example shown below, Row Labels is filtered to show only sales for the South and West regions.
More information about PivotTables