Overview of PivotTables and PivotCharts - Microsoft Support
Learn what PivotTable and PivotCharts are, how you can use them to summarize and analyze your data in Excel, and become familiar with the PivotTable- and PivotChart-specific elements and terms.
Create a PivotChart - Microsoft Support
Create a PivotChart based on complex data that has text entries and values, or existing PivotTable data, and learn how Excel can recommend a PivotChart for your data.
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.
Pivot data in a PivotTable or PivotChart - Microsoft Support
In Excel, you can pivot data in a PivotTable or PivotChart by changing the field layout of the data. By using the PivotTable Field List, you can add, rearrange, or remove fields to show data in a PivotTable or PivotChart exactly the way that you want.
Drill into PivotTable data - Microsoft Support
Drill down in a PivotTable with an OLAP or Data Model data hierarchy to view details on lower levels and drill up to view summary data on upper levels by using the new Quick Explore feature.
Use PivotTables and other business intelligence tools to analyze …
Watch these videos to learn what Power View can do for you with Power Pivot in a supporting role. Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.
Consolidate multiple worksheets into one PivotTable
Consolidating data is a useful way to combine data from different sources into one report. For example, if you have a PivotTable of expense figures for each of your regional offices, you can use a data consolidation to roll up these figures into a corporate expense report.
Design the layout and format of a PivotTable - Microsoft Support
To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.
Use multiple tables to create a PivotTable - Microsoft Support
Create a PivotTable with multiple tables. Here are the three basic steps to get multiple tables into the PivotTable Field List: Import from a relational database, like Microsoft SQL Server, Oracle, or Access. You can import multiple tables at the same time: …
Change the source data for a PivotTable - Microsoft Support
You can change the data source of a PivotTable to a different Excel table or a cell range, or change to a different external data source.
Filter dates in a PivotTable or PivotChart - Microsoft Support
In the Power Pivot window, select a table that contains dates. In the Design tab, click Mark as Date Table. In the dialog box, select a column that contains unique values, with no blank values. Click OK. To use advanced date filters. Navigate to a …