← Text, Tables and Clean-up
Lesson 3 of 5
PivotTables: a summary in thirty seconds
What you will be able to do
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.
0 XP
Step 1 of 6 · 1 point
With a cell selected inside tblSales, insert a PivotTable on a new worksheet.