After you create a PivotTable, you'll see the Field List. You can change the design of the PivotTable by adding and arranging its fields. If you want to sort or filter the columns of data shown in the …

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 PivotTable for you. …

With Get & Transform and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Use these resources to find out what's possible, and how to get started.

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 example, to …

After you create a PivotTable by selecting its data source, arranging fields in the PivotTable Field List, and choosing an initial layout, you can perform the following tasks as you work with a PivotTable:

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.

After creating a PivotTable and adding the fields that you want to analyze, you may want to enhance the report layout and format to make the data easier to read and scan for details.

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 best …

If the column widths and cell formatting of your data adjust when you refresh the PivotTable data, and you don't want that to happen, make sure the following options are checked:

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 PivotTable to …