Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.

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 Excel, you can pivot data in a PivotTable or PivotChart by changing the field layout of the data. By using the PivotTable Field List, you can add, rearrange, or remove fields to show data in a …

Sometimes it's hard to see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table and quickly …

Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table. Then you can create Power View sheets …

Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.

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 …

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is …

Try creating PivotTables with prompts like: Show PivotTables. Create a PivotTable. Summarize with PivotTable. Can you make a PivotTable from this data and show a summary by Report Date? …

Select a blank cell (that is not part of a PivotTable) in the workbook. Select on the PivotTable Table and PivotChard wizard icon on the Quick Access Toolbar. On the Step 3 page of the wizard, select …