Sharing the Wonder of Excel PivotTables!
The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and aggregate numeric data, summarize data by categories and subcategories, and create custom calculations and formulas. You can expand and collapse levels of data to focus your results, and drill down to details from the summary data for areas of interest to you. You can also move rows to columns or columns to rows (or “pivot”) to see different summaries of the source data.
You might be starting out with this . . .
And in the matter of a few seconds, have this . . .
Learn all about PivotTables in an Advanced Excel class at Full Circle Computing!