- 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 dataas 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.
- Using a recommended PivotTable is a quick way to get started on the right path. However, you can still create an empty PivotTable to add your own fields and layout. Just click PivotTable on the Insert tab, instead of Recommended PivotTables.
- You can also create a PivotTable from external data like an Online Analytical Processing (OLAP) data source, or base a PivotTable on the Data Model so you can analyze data in multiple tables.
- Instead of the PivotTable and PivotChart Wizard you could use in earlier versions of Excel, you’ll be using the PivotTable or Recommended PivotTables commands on the ribbon to create PivotTables. However, if you miss the wizard, it’s still available. You can add it to the Quick Access Toolbar, or press ALT, D, P to start it.
Make Pivot table in Excel
Pivot table is one of Excel’s most powerful feature as it allows you to summarize data in multiple ways like with Total, Average, Count,etc. Pivot tables in excel also allow you to rearrange the results with just drag and drop options.
If you are finding yourself writing lots of formulas to summarize data in Excel then Pivot Tables can save you a lot of time and work and give you insights into your data that are otherwise too hard to discover. Not only that, but they also allow you to quickly change how your data is summarized with very little effort .
Pivot tables are great time savers if you know how to use them . This is a comprehensive video wherein I have tried to introduce you to Pivot tables in the easiest manner possible . Have fun 🙂 To watch more videos and download the files visit http://www.myelesson.org
The Video above explains how to use Pivot Table MS Excel. The Text below is from a Microsoft Excel Support Blog