How To Create a Pivot Table in Excel 2007


How To Create a Pivot Table in Excel 2007

Using pivotal table you can calculate a large bunch of data in your worksheets. Most especially if your data in a single worksheet compose of mix product. Actually you categorize it according to its data set, example location, Order ID #, Product name, prices, product category, and date purchased. This arrangement of your set of data, I’m sure it is scrambled or unsorted and not easy to calculate.


To solve this problem we can use the pivotal application of the Microsoft Office Excel 2007 version or Office excel 2010 or higher of this versions. And create your worksheets like for example, an order worksheets or any of your related worksheets you save in your computer.
Then follow the instruction below:
  1. Open your worksheets of data.
  2. Click any cell of your worksheets.
  3. Click Insert menu tab
  4. Then click Pivot table button left side position of the ribbon menu.
  5. Then click pivot table under in the list.
  6. It will open a dialogue box and it will select automatically the entire worskheet data.  
  7. Then click Ok button.
  8. Then it will display a drag fields, you need to select and click a worksheet fields. Position top right side of your screen.
  9. It will automatically arrange and calculate the entire worksheet data with the sum of all prices display in the right side.
  10. Now you’re ready to sort the entire data.
  11. Click any cell in the total column.
  12. Click options menu tab and click sort button.
  13. It will display a small window, now select either smallest to largest or largest to smallest.
  14. Now click ok button.
  15. Now its sorted together with the auto calculation of the grand total.
  16. Now you’re done.
Other task you need if you wanted to apply filter, change summary calculation, and apply two dimensional pivotal table in your worksheets. see you next post for this.
How To Create a Pivot Table in Excel 2007 Arnel Cartoneros 5 of 5
Using pivotal table you can calculate a large bunch of data in your worksheets. Most especially if your data in a single worksheet comp...
Share on Google Plus

About Arnel Cartoneros

Arnel is a Blog creator and writer, A founder and publisher of www.combinebasic.com and www.nuggetro.info. Part time Computer Instructor, Computer And Electronic Technician, And performing job as Biomedical Machine Specialist. I'm an avid fan of social media and very interested in Technical information and innovation.

    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

If you have questions and comments pls. leave it here! You can post comments if you have google accounts. Thank you...