Format your data as an Excel table (select anywhere in your data, and then select Insert > Table from the ribbon). If you have complicated or nested data, use Power Query to transform it (for …

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.

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 …

You can create multiple page fields and assign your own item names for each source range. This lets you create partial or full consolidations; for example, one page field that consolidates …

In the Excel window, click Power Pivot> Calculations> Measures> New Measure. In the Measure dialog box, for Table name, click the down arrow, and then select the table you want the …

Group by date and time Name a group Ungroup grouped data Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Create a …

To summarize values in a PivotTable in Excel for iPad, you can use summary functions like Sum, Count, and Average. The Sum function is used by default for numeric values in value fields. …

Choose the fields you want to create slicers for, and select OK. Excel will place one slicer for each selection you made onto the worksheet, but it's up to you to arrange and size them however is …

Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.

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 …