PivotTables: a summary in thirty seconds

Was du danach kannst

Build a PivotTable from a Table, arrange rows, columns and values, group dates, and know when a refresh is required.

Three hundred and fourteen order lines. Your manager wants sales by branch and category, by month. Writing that with formulas takes twenty minutes. Dragging four fields takes thirty seconds.

Schritt 1 von 6 · 1 Punkt

With a cell selected inside tblSales, insert a PivotTable on a new worksheet.