How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table (previously known as an Excel list).

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Come usare una tabella pivot in Excel per calcolare, riepilogare e analizzare i dati del foglio di lavoro per visualizzare tendenze e modelli nascosti.

The following links and information can get you going with Power Pivot, including how to enable Power Query in Excel, how to get started using Power Pivot, then tutorials, and community connections.

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.

If the pivot_table argument is not a range in which a PivotTable is found, GETPIVOTDATA returns #REF!. If the arguments do not describe a visible field, or if they include a report filter in which the …

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.

Within Excel, Data Models are used transparently, providing data used in PivotTables, PivotCharts, and Power View reports. You can view, manage, and extend the model using the Microsoft Office Power …

Build PivotTables by using related tables in the Field List. You can import related tables from databases, or set relationships in Power Pivot after you import.