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 …

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 …

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.

Subtotal row and column fields In a PivotTable, select an item of a row or column field. Make sure it is a field and not a value. To subtotal an outer row or column label using the default …

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 with Copilot Open Excel. Make sure to format your data in a table or supported range for Copilot. Select the Copilot button in the ribbon. Ask Copilot to create a …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Create a PivotTable Use the Field List to arrange fields in a PivotTable …

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 …

Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table and quickly see what's going on. PivotCharts are a great way to add data visualizations to your …

Excel has day-of-the-week and month-of-the year custom lists, but you can also create your own custom list for sorting. In Sort By, select Grand Total or Values in selected columns to sort by …