Pivot Data

Advertisements

  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Pivot Data

With the Pivot data you can see the same information in different layouts with a few clicks
http://www.mstipsandtricks.com/tips-and-tricks/ms-office-tips-and-tricks/ms-excel/pivot-da...
  • Total Hits: 10644

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating

  •  

  • Total Votes: 139 votes

  • Category: MS Excel/Functions

  • Submitted on: 2008-04-27 00:49:02

  • Submitted By: Devesh Khanna

  • Set as Favorite

Description:

Creating a Pivot table

1) When you create a dynamic table, each column of its source data becomes a field that can be used in the pivot table. The fields summarize rows of information of the data source.

2) The name of the fields for the pivot table comes from the titles of the columns of their data source. Verify that you have names for each column of the first row of the spreadsheet of the data source.

3) The remaining rows that appear under the headers would have to contain similar elements of the same column in the data source.

4) it must not have empty columns in the data that are using for the report of the dynamic table.

5) Open the Table Usage.xlsx Sample.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.85%  54
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.07%  14
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.51%  16
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 10.79%  15
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.78%  40

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.





Advertisements
Advertisements