Free skill reference · Business & operations

Excel pivot tables — summarize without formulas

Pivot tables turn long tables into answers — for sales, tourism bookings, school grades, or inventory.

  1. Put one header row with unique column names.
  2. Insert → PivotTable on a new sheet.
  3. Rows = category, Values = count or sum.
  4. Filter to the period or location you care about.

Practice in Lab

Open the Lab workspace in the Business & operations domain — free to start. Tourism, engineering, business, language, and more — not only coding.

Open LabSign in to save progress

More free guides