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

To place the PivotTable in a new worksheet starting at cell A1, click New worksheet. To place the PivotTable in an existing worksheet, select Existing worksheet, and then type the first cell in …

Tip: If your PivotTable is on a separate sheet that has no other data you want to keep, deleting that sheet is a fast way to remove the PivotTable.

If you're working with data that's been added to an Excel data model, then sometimes, you may lose track of which tables and data sources were added to the data model. Note: Make sure …

To place the PivotTable in a new worksheet starting at cell A1, choose New Worksheet. To place the PivotTable in the active worksheet, choose Existing Worksheet, and then in the Location …

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.

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.

PivotTable on iPad is gradually rolling out to customers running Excel on iPad version 2.80.1203.0 and above. In a PivotTable, press and hold an item you want to Expand or Collapse.

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 …

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 …