PivotTables: a summary in thirty seconds

Lo que podrás hacer

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.

Paso 1 de 6 · 1 punto

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