How to create pivot table in Excel 2013

When you process your data in Excel 2013, you can use pivot table feature to analyze your data. So you can review your data easily. Such as, you can analyze sold item in your shop. How to insert pivot table is easy. Check the steps below!

create pivot table

How to create pivot table in Excel 2013
  1. Select all data
    2. insert Pivot table
  2. Click “INSERT”
  3. Click “Pivot Table”
    4. insert Pivot table
  4. Check that you have select correct tables or ranges and choose where you want to place the pivot table.
    5. insert Pivot table
  5. Click “OK” and the pivot table will place in new worksheet.
  6. Drag the dragging fields to values, rows or column areas.
    7. insert Pivot table
  7. And done. 
19:55
Labels: Excel 2013