Office Dễ Hiểu

How to create a PivotTable in Excel

Summarize project costs and refresh the result when the source data changes.

Select a cell in a clean data table, choose Insert → PivotTable and drag fields into Rows, Columns and Values.

Visual walkthrough

InsertPivotTableRows and Values

Before

The source contains individual project costs.

After

The PivotTable groups and totals the costs.

Check the result

Change one source amount, refresh and compare the total.

Step-by-step instructions

  1. Use a source table with one header row, no merged cells and numeric cost values. Convert it to an Excel Table with Ctrl+T if suitable.
  2. Choose Insert → PivotTable, check the source and select New Worksheet.
  3. Drag Project into Rows, Cost category into Columns and Cost into Values. If Excel shows Count, open Value Field Settings and select Sum after checking the source numbers.
  4. When source data changes, right-click the PivotTable and choose Refresh. If new rows fall outside a fixed source range, expand the source first.

Frequently asked questions

Can I filter by status?

Yes. Drag Status into Filters, then choose the required status above the PivotTable.

Reference: Microsoft Support