Audio

We've built the goldmine. Now we need to mine it — find what's hidden inside through sorting and aggregating. That's exactly what pivot tables are designed for. A pivot table creates a new calculation sheet inside this workbook. Since we're adding something new, go to the Insert tab. Click the PivotTable button — not the dropdown arrow below it, the button itself. The source data is the left table. You only need to click one cell inside it — Excel will recognize the entire table as the source