Articles → EXCEL → Pivot Table In Excel 2010

Pivot Table In Excel 2010






Software Requirement





Technical Knowledge





What Is Pivot Table?





Sample Data




Picture showing the sample excel file

Click to Enlarge


How To Create Pivot Table




  1. Click on the arrow on the top left side of the excel (see the figure below) and select data
  2. Picture showing selecting the records in excel for creating the pivot table

    Click to Enlarge

  3. Go to ‘Insert’ tab and click on ‘Pivot Table’
  4. Picture showing the Pivot Table option in excel

    Click to Enlarge

  5. A pop up window appears as shown in figure below
  6. Picture showing a popup window to select the range for creating the pivot table

    Click to Enlarge



  7. Click ‘Ok’.
  8. You can see that pivot table gets added (see the figure below)
  9. Picture showing the Pivot table added in the excel

    Click to Enlarge



Different Parts In Pivot Table




  1. Pivot table layout on the left hand side
  2. Picture showing the left side layout of the pivot table

    Click to Enlarge

  3. Pivot tables field list. In this section all the columns of table array will be listed.
  4. Picture showing the pivot table field list

    Click to Enlarge

  5. Drag fields between area
  6. Picture showing different areas where you can drag different columns

    Click to Enlarge



How To Summarize Data?






Picture showing the name column dragged onto the pivot table

Click to Enlarge



Picture showing the gender column dragged onto the pivot table

Click to Enlarge



Picture showing the different columns dragged on the areas section

Click to Enlarge



Picture showing the impact on layout when different columns are dragged on the areas section

Click to Enlarge



Picture showing the impact on layout when different columns are dragged on the areas section

Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Saturday, November 22, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250