Turn column and row field headers on or off, or display or hide blank lines.ĭisplay subtotals above or below their rows. Sort, filter, and group fields and items.Ĭhange summary functions, and add custom calculations and formulas.Ĭhange the form layout and field arrangement by doing the following:Ĭhange the PivotTable form: Compact, Outline, or Tabular.Ĭhange the layout of columns, rows, and subtotals by doing the following: Presenting concise, attractive, and annotated online or printed reports.įor example, here's a simple list of household expenses on the left, and a PivotTable based on the list to the right:įor more information, see Create a PivotTable to analyze worksheet data.Īfter you create a PivotTable by selecting its data source, arranging fields in the PivotTable Field List, and choosing an initial layout, you can perform the following tasks as you work with a PivotTable:Įxpand and collapse data, and show the underlying details that pertain to the values. Moving rows to columns or columns to rows (or 'pivoting') to see different summaries of the source data.įiltering, sorting, grouping, and conditionally formatting the most useful and interesting subset of data enabling you to focus on just the information you want. Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.Įxpanding and collapsing levels of data to focus your results, and drilling down to details from the summary data for areas of interest to you. Querying large amounts of data in many user-friendly ways. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is an interactive way to quickly summarize large amounts of data.

Excel pivot table training pdf