How to Make a Pivot Table in Excel | Scribe

    How to Make a Pivot Table in Excel

    • |
    • 5 steps |
    • 21 seconds
      1
      To begin, open your workbook in Excel.
      2
      Highlight to select the range of data.\ Click "Insert"
      Highlight to select the range of data.\ Click "Insert"
      3
      Click "PivotTable"
      4
      Ensure that the correct table or range is selected.\ Click "New worksheet" to create the Pivot Table in a separate worksheet.\ Click "OK" to create a Pivot Table.
      Ensure that the correct table or range is selected.\ Click "New worksheet" to create the Pivot Table in a separate worksheet.\ Click "OK" to create a Pivot Table.
      5
      Select the categories you want displayed on the Pivot Table.
      Select the categories you want displayed on the Pivot Table.