The Create PivotTable dialog opens, as shown below. Select Pivot Chart & Pivot Table from the dropdown: To do this, select the table, then go to the Insert tab and click the arrow associated with the Pivot Chart button. We want a pivot table showing us how many phone numbers are on file for each employee. We've created the table shown below. In tables, columns are fields and rows are records. The best way to learn about a pivot table is to see how to create one. Remember, tables were called lists in previous versions of Excel. A table may be too large to allow you to analyze certain parts. A pivot table allows you to basically extract those parts (while leaving them in the table) to come up with figures, view the data, etc. Before you can create a pivot table, you must create a data list with labeled columns. Otherwise, you will see this message:Ī pivot table is a data summarization tool used in Excel. You can use a pivot table to summarize data that you've added to a table.