Pivot Table:
Pivot Table is one of the most powerful tools of excel. Infact, justice to pivot tables cannot be done by using more words however, it is one of "the more you sink yourself, the more you challenge yourself" kind of a tool.
It is a tool which helps a user in analyzing and summarizing data and presenting it in a customized way. The USP (Unique Selling Point) of Pivot tables is that one can select a considerable data from huge data sets in performing various activities like (business) analytics, business intelligence, reporting etc.
To give an overview, once data has been selected, one needs to choose the option of Insert (in the ribbon) and then Pivot table (given at top left). Once we set up the Pivot table, we can simply drag and drop fields in various options given at the right which otherwise would have been by use of different formulae.
Therefore, Pivot table not only gives a deep consideration to aesthetics but also saves a millenia by avoiding to type the formulae in analyzing data sets.
Pivot Table is one of the most powerful tools of excel. Infact, justice to pivot tables cannot be done by using more words however, it is one of "the more you sink yourself, the more you challenge yourself" kind of a tool.
It is a tool which helps a user in analyzing and summarizing data and presenting it in a customized way. The USP (Unique Selling Point) of Pivot tables is that one can select a considerable data from huge data sets in performing various activities like (business) analytics, business intelligence, reporting etc.
To give an overview, once data has been selected, one needs to choose the option of Insert (in the ribbon) and then Pivot table (given at top left). Once we set up the Pivot table, we can simply drag and drop fields in various options given at the right which otherwise would have been by use of different formulae.
Therefore, Pivot table not only gives a deep consideration to aesthetics but also saves a millenia by avoiding to type the formulae in analyzing data sets.
0 comments:
Post a Comment