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 G. 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 G. Cartoneros

I'm a husband, a blogger and Biomedical Machines Specialist, also a computer instructor and technician and a crazy writer, I like to write and build blogs and avid fan of social media. I have built this blog just to help others through information. Follow us on Facebook and Twitter.

    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...