We have added the Sales Representative to the Filters area and in the worksheet we have used it to filter on Sara Snyder‘s sales data.You can have multiple filters and select multiple values within a filter. The Filters section will allow you to filter out data from your pivot table results so that only data pertaining to the values you select will display.In the PivotTable Fields window, you will notice the larger scroll box in the top area contains a list of all your Column Headings from the Sales Data.Fields from the Column Heading area can be dragged and dropped into any of the Filter, Columns, Rows or Values sections of the PivotTable Fields window to create your desired Pivot Table, but we will go through this creation process in detail during the next tutorial. I have created a pivot table for the purpose of explaining the different areas in the PivotTable Field window and how they relate to the pivot table in the worksheet. If you don’t see the PivotTable Fields you can find it under the Tools section of the Analyze tab > Show > Field List.You should also see the PivotTable Fields window pane appear to the right.You will notice two new tabs appear in the ribbon, an Analyze and Design tab.Place the active cell cursor anywhere in the Blank Pivot Table.You will now have a new blank Pivot Table. You can select where you want to create the new pivot table, either in a New Worksheet or you can choose the location in an Existing Worksheet.Your data should be pre-selected and display the name of our table that we named SalesData.Press the Pivot Table button from under the Tables section.Now we can create a Pivot Table based on our data. Under the Properties section type in your new Table Name and press Enter.A new Table Tools tab called Design will appear in the ribbon.The default name of your new table will be Table1, so it’s a good idea to rename it to something more descriptive. Make sure your entire range of your data is selected and ensure the My table has headers option is checked since our data has column headings.Īlternatively, you can avoid using the ribbon commands and use the Ctrl + T keyboard shortcut to create a table.You can read more about the benefits of Excel Tables here.
#HOW TO USE MICROSOFT EXCEL PIVOT TABLES UPDATE#
This will make it easier to add data at a later time and update your pivot table in addition to the many other benefits of tables.
It’s generally a good idea to turn the data for your pivot table into a Table first. In this tutorial, we’ll take you through the steps to create a new Pivot Table.
0 kommentar(er)
