how to work with pivot tables n.
Skip this Video
Loading SlideShow in 5 Seconds..
How to work with Pivot Tables PowerPoint Presentation
Download Presentation
How to work with Pivot Tables

How to work with Pivot Tables

72 Views Download Presentation
Download Presentation

How to work with Pivot Tables

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. How to work with Pivot Tables Step by step instruction

  2. Click the first cell in the first row and column of data.

  3. Now click insert

  4. Click on PivotTable

  5. Once you click on PivotTable this box will pop up. You want to make sure “Select a table or range” is selected. Also that “New Worksheet” is selected. Take a look at your spreadsheet you will see a moving dashes around all of your data. Then Click OK

  6. This is the screen that will pop up. Now you want to select a unique identifier out of your fields for example the Student ID is different for each student so you can drag and drop Student ID to the Value box.

  7. As you can see this is not correct. Click on “Sum of Student ID”

  8. Click on “Value Field Settings”

  9. Select count then click OK.

  10. Now you have a count of everyone on the spreadsheet

  11. Now drag and drop “Home location” to the “Row labels” This will give you a list of home locations and the number of students at each

  12. Now drag “Home location” to “Report filter” This will change the look of your information now you have a drop down menu that is labeled home location and the total count under count of Student ID

  13. Now you have the group divided up by race. Now drag and drop “Ethnicity” into the Row Label box

  14. Now take “Gender” and put it in the Column labels

  15. Click on the arrow to open the drop down menu now you see all of the Campuses listed in your spreadsheet.

  16. Click “Select Multiple items” This is will give you the option to choice one site or all

  17. Select MCP so that the data will show you only student at the Atlanta campus

  18. Think about what you want to know • Report Filter • Makes drop down menus • Row labels • Information is put in rows, each row is populated with information. • Column labels • Information is put in column, each column is populated with information. • Value • Give you counts, averages, min., max.