Category: Uncategorized

How to make a pivot table in excel!

I would to teach you how to make a pivot table in excel. It is something that many may not know how to do or even know what it is so they do not use it. However, a piot table can be very useful to read data in many different ways. Follow the steps below and you will be on your way to reviewing data in the way which you see fit.

  1.  Go to the start menu and hit all programs.
  2. Hit microsoft office.
  3. Launch excel.
  4. Insert data into the spreadsheet.
  5. Highlight the data.
  6. Go to the insert tab on the toolbar
  7. Under tables hit pivot table
  8. This will bring up the create pivot table option
  9. You have the option of creating the table in the existing spreadsheet or new one.
  10. Click where you want the table to be and select
  11. This will give you the pivot table field list
  12. Select which fields you want to be displayed in your list.
  13. If you want to sort the pivot by a particular field select the field and drop it into the report filter.
  14. You have successfully created a pivot table!