A PivotTable report is a collaborative way to condense large amounts of data. We use it to examine, analyze and display the numerical data in detail and to get answers for unforeseen questions about the data.
1. Select a cell in a range of cells, Make sure that the range of cells has column headings.
2. on the [Insert] tab, in the [Tables] group, click [PivotTable]. The [Create PivotTable] dialog box appears as shown below:
3. Select a data source by doing one of the following:
- Choose the data that you want to analyze
- Type the range of cells or table name reference in the [Table/Range] box.
Note. Excel may have displayed the range of cells or table name reference in the [Table/Range] box for you.
- Use external data
- Click [Choose Connection]. Excel displays the [Existing Connections] dialog box.
- In the [Show] drop-down list box at the top of the dialog box, select the category of connections for which you want to choose a connection or select [All Existing Connections] (which is the default).
- Select a connection from the [Select a Connection] list box, and then click [Open].
4. Choose the location where you want the PivotTable to be placed.
5. Click OK.