They are the same as the column headings in the source data.Īt the bottom are the four areas of a PivotTable the fields can be added to: ROWS, COLUMNS, VALUES, and FILTERS. In the PivotTable Fields List, at the top, are the fields we’ll use to create the PivotTable. In our example, a new worksheet with an empty PivotTable is created. If you want, you can create it on an existing worksheet instead, by clicking Existing Worksheet and providing the Location. We recommend using a table because, if the table grows, the PivotTable will automatically include the new data when you refresh the PivotTable.įor information about creating a table, see the link Create or delete an Excel table in a worksheet in the course summary.īy default, the PivotTable will be created on a New Worksheet. In this example, the entire SourceData table. All of the source data is automatically selected. There’s a link to both articles in the course summary at the end of the course.Ĭlick any cell in the data.
It doesn’t have to be in a table, a range of cells can be used as well.įor information about using external data, see the article Create a PivotTable to analyze external data.įor information about using multiple database tables, see Create a PivotTable to analyze data in multiple tables. The headings are used to name the fields in the PivotTable.Įach column contains the same type of data, for example, text in one column and currency in another, and there should be no blank rows or columns.įor this PivotTable, we’ll use source data that is in a table. It has a column for the Genre of the books, the Date they were sold, the Sales Amount, and the Store where they were sold.īefore you create a PivotTable, the data you are going to use (referred to as Source Data) should be arranged correctly.Īll the columns should have headings. This table contains data about book sales.
0 kommentar(er)
