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 …
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Design the layout and format of a PivotTable - Microsoft Support
In Excel, you can change the layout and format of the PivotTable data to make it easier to read and scan.
Use PivotTables and other business intelligence tools to analyze …
Solve data analysis and modeling problems in Power Pivot by using calculations such as AutoSum, calculated column and calculated field formulas, or custom Data Analysis …
Use the Field List to arrange fields in a PivotTable
Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.
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 …
Use slicers to filter data - Microsoft Support
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what …
Power Pivot - Overview and Learning - Microsoft Support
Power Pivot is one of three data analysis tools available in Excel: Power Pivot. Power Query. Power View. Power Pivot Resources. The following links and information can get you going …
Power Pivot: Powerful data analysis and data modeling in Excel
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from …
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.