Featured Post

Pi Network Application It's Now Available For Windows and Mac Computer

 Pi Network application is a cryptocurrency data mining using your mobile phone that you'll enable to earn income using the pi coins th...

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.

No comments:

Post a Comment

Note: We have Zero Tolerance to Spam. Avoid Promotions with 'Links' considered as spam will be deleted immediately upon our review.