PivotTables: a summary in thirty seconds

Ce que vous saurez faire

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.

Étape 1 sur 6 · 1 point

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