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

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 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.

Here's how you build a new PivotTable or PivotChart using the Data Model in your workbook. Click Open, and then click OK to show a Field List containing all the tables in the Data Model.

Work with stocks and geography data Turn your data into insights List of all Excel functions available VLOOKUP function IF function Create a drop-down list Combine text from two or more cells Freeze …

Analyze your data in a PivotTable or PivotChart, build a Data Model, or use other business intelligence tools like Power Pivot and Power View.

Hier erfahren Sie, wie Sie eine PivotTable in Excel verwenden, um Ihre Arbeitsblattdaten zu berechnen, zusammenzufassen und zu analysieren, um ausgeblendete Muster und Trends zu sehen.

Instead of adjusting filters to show dates, you can use a PivotTable Timeline—a dynamic filter option that lets you easily filter by date/time, and zoom in on the period you want with a slider control.

Next, create a PivotTable, or create a Pivot Chart. If you've already created relationships between the tables, you can use any of their fields in the PivotTable.

Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months