Analysis
A practical PivotTable workflow for faster summaries
Turn a clean transaction table into a useful summary while avoiding the refresh, range, and grouping mistakes that cause confusion.
Begin with one row per record
PivotTables work best when each row represents one transaction or record, each column has a single clear meaning, and every column has a heading. Remove blank separator rows and merged cells from the source area.
Convert the source to an Excel Table so new rows are easier to include when the data grows.
Build from the question, not the field list
State the question first: sales by region, average order value by month, or count of cases by status. Put categories in Rows or Columns and numeric measures in Values. Use Filters only when the audience needs a controlled subset.
- Confirm whether Values should use Sum, Count, or Average.
- Format numbers inside the value field settings.
- Group real dates into months or quarters when useful.
- Keep the layout focused on one decision or comparison.
Refresh and reconcile
A PivotTable does not always update simply because the source changed. Refresh it, confirm the source range, and compare the grand total with the underlying table.
If the totals differ, check for filters, text values in numeric columns, blank headings, and records outside the source range.