How to use Pivot Table to simplify our data in Microsoft Excel

  • Published date: October 23, 2017
    • Pakistan

Pivot Table to simplify our data in Microsoft Excel


In this video tutorial I try to teach how to use Pivot Table option in Microsoft Excel to simplify our data. Friends Pivot Table is very great feature of Excel that help us to simplify our big data sheets.



Pivot Tables in Excel


Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.


How to Insert a Pivot Table


To insert a pivot table, execute the following steps.


1. Click any single cell inside the data set.


2. On the Insert tab, in the Tables group, click PivotTable.


If you have any question you can ask me in comments.

Share by email Share on Facebook Share on Twitter Share on Google+ Share on LinkedIn Pin on Pinterest

Useful information

  • Avoid scams by acting locally or paying with PayPal
  • Never pay with Western Union, Moneygram or other anonymous payment services
  • Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
  • This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"

Leave your comment (spam and offensive messages will be removed)

Related listings

  • How to freeze a row and column or both in Microsoft Excel

    How to freeze a row and column or both in Microsoft Excel

    Microsoft Excel December 4, 2017

    Freeze a row and column or both in Microsoft Excel Freeze Pane in Microsoft Excel To lock one row only, choose the View tab, and then click Freeze Top Row. To lock one column only, choose the View tab, and then click Freeze First Column. To lock more...

  • How to use Countblank Function or Formula in Microsoft Excel

    How to use Countblank Function or Formula in Microsoft Excel

    Microsoft Excel December 4, 2017

    Use of Countblank Function or Formula in Microsoft Excel In this video tutorial I try to teach how we can use Countblank formula or Countblank function in Microsoft Excel in Urdu or Hindi Language. With the help of Countblank formula we can count all...

  • How to Use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS Functions or Formula in Excel

    How to Use COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS Functions or Formula in Excel

    Microsoft Excel December 1, 2017

    Use of COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS Functions/Formula in Excel In this video I try to teach how to use Count functions (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS) in Microsoft Excel in urdu or hindi language. With the help of Count...