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

Important: PivotTable on iPad is available to customers running Excel on iPad version 2.82.205.0 and above. To access this feature, please ensure your app is updated to the latest version …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.

If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the …

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 …

The asterisk indicates that the visible values that are displayed and that are used when Excel calculates the total are not the only values that are used in the calculation. Note: This option is …

Power Pivot in Microsoft Excel is an add-in you can use to perform powerful data analysis in Excel. Here’s how you enable Power Pivot before you use it for the first time.

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.

In Power Pivot, a calculated field on the SalesAmount column in the FactResellerSales table, which gives the actual sales amount in dollars for each sales employee is created.

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Create a PivotTable to analyze worksheet data Create a PivotTable to analyze …