Create a PivotTable to analyze worksheet data - Microsoft Support
Select a table or range of data in your sheet and select Insert > PivotTable to open the Insert PivotTable pane. You can either manually create your own PivotTable or choose a recommended PivotTable to be created for you.
Insert a PivotTable - Microsoft Support
Under Choose the data that you want to analyze, select Select a table or range. In Table/Range , verify the cell range. Under Choose where you want the PivotTable report to be placed , select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.
Video: Create a PivotTable manually - Microsoft Support
For this PivotTable, we’ll use source data that is in a table. It doesn’t have to be in a table, a range of cells can be used as well. For information about using external data, see the article Create a PivotTable to analyze external data.
Video: Create a PivotTable and analyze your data - Microsoft …
Create a PivotTable to analyze data in multiple tables. Show different calculations in PivotTable value fields. Create a PivotChart. Available chart types
Overview of PivotTables and PivotCharts - Microsoft Support
You can also connect to external data sources such as SQL Server tables, SQL Server Analysis Services cubes, Azure Marketplace, Office Data Connection (.odc) files, XML files, Access databases, and text files to create PivotTables, or use existing PivotTables to create new tables.
Set PivotTable default layout options - Microsoft Support
Set PivotTable default options, so your PivotTables start the way you want every time
Get started with Power Pivot in Microsoft Excel
Get started using Power Pivot in Excel to perform powerful data analysis, create sophisticated data models, mash up large volumes of data from various sources, and perform information analysis rapidly.
Create a PivotTable with an external data source - Microsoft Support
Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.
Create a PivotChart - Microsoft Support
After you insert a column, line, pie, or radar chart, you can pivot it by changing or moving fields using the PivotTable Fields list. You can also filter data in a PivotTable, and use slicers. When you do that, the chart will also be filtered.
Create a named set in an OLAP PivotTable - Microsoft Support
On the Options tab, in the Calculations group, click Fields, Items, & Sets, and then click Create Set Based on Row Items or Create Set Based on Column Items. The New Set dialog box is displayed. If needed, you can resize this dialog box by dragging the sizing handle in the lower-right corner of the dialog box.