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.
Overview of PivotTables and PivotCharts - Microsoft Support
You can use a PivotTable to summarize, analyze, explore, and present summary data. PivotCharts complement PivotTables by adding visualizations to the summary data in a PivotTable, and allow you to easily see comparisons, patterns, and trends.
Change the summary function or custom calculation for a field …
Select a field in the Values area for which you want to change the summary function of the PivotTable report. On the Analyze tab, in the Active Field group, click Active Field , and then click Field Settings .
Consolidate multiple worksheets into one PivotTable
To summarize and report results from separate worksheet ranges, you can consolidate data from each separate worksheet range into a PivotTable on a master worksheet. The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook.
Consolidate data in multiple worksheets - Microsoft Support
To summarize and report results from separate worksheets, you can consolidate data from each separate worksheet into a master worksheet.
Create and share a Dashboard with Excel and Microsoft Groups
A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. Dashboards not only provide consolidated data views, but a self-service business intelligence opportunity, where users are able to filter the data to display just what’s important to them.
Outline (group) data in a worksheet - Microsoft Support
If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.
Group or ungroup data in a PivotTable - Microsoft Support
Create a PivotTable to analyze worksheet data. In Excel, show items or values in logical groups like months or quarters for ease of summarizing and performing data analysis.
Aggregations in Power Pivot - Microsoft Support
With Power Pivot, you can import the product category table to your data model, create a relationship between the table with the number data and the product category list, and then use the categories to group data.
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.
Guidelines for organizing and formatting data on a worksheet
Data that is defined by the table can be manipulated independently of data outside of the table, and you can use specific table features to quickly sort, filter, total, or calculate the data in the table.