Pivot Table Excel 2007. An excel table makes it easy for you to sort filter and review your data whether it s a few rows and columns or thousands. Create a pivot table.
Under choose the data that you want to analyze select select a table or range. A pivot table is an interactive table that lets you group and summarize data in a concise tabular format. Then under the insert tab click on the pivottable button.
You can also use an excel table as the source for a pivot table and new data will automatically be included in the pivot table.
Pivot tables also let you play around with the arrangement of the summarized data. An excel table is a new feature in excel 2007 similar to the list feature in excel 2003. You can enter your data range manually or quickly select it by dragging the mouse cursor across all cells in the range including the labeled column headers. In table range verify the cell range.
