Pivot Tables In Excel. Highlight your cells to. A pivottable is especially designed for.
Highlight your cells to. Under choose the data that you want to analyze select select a table or range. A pivot table is a summary of a large dataset that usually includes the total figures average minimum maximum etc.
Building the pivot table 1.
Querying large amounts of data in many user friendly ways. Select insert pivottable. You can use a pivottable to analyze numerical data in detail and answer unanticipated questions about your data. Ensure that your data meets the needs of a pivot table.
