Pivot Tables

Pivot tables make it easy to look at your data in a variety of ways. Google Sheets makes it easy to use pivot tables if you understand how they function. There are 4 main parts to pivot tables:

• • Rows: Displays what you want to see in the rows of your pivot table

  • Columns: Displays what you want to see in the columns of your pivot table

  • Values: Displays the intersection of the rows and columns

  • Filter: Filters items in the pivot table

Before you begin:

• It's very important for your data to be clean. If you have any extra spaces, it may cause problems with your pivot table. If you see duplicate entries, you probably have extra spaces.

• Be sure your columns have headers.

Select your Data:

• • Select the actual data. Do not click on the square box in the upper left-hand corner.

  • Be sure to include the headers in your data selection.

  • Go to Data>Pivot Table

  • A new tab will be opened call Pivot Table and a blank Pivot Table will appear.

    • You can create multiple Pivot tables in a workbook by going back to Data>Pivot Table. Each time it will create a new tab with a new Pivot Table.

  • Click inside the table to make the sidebar appear. If you click outside the table, the sidebar will disappear. Click back inside again to make it reappear.

  • Many people like to center their data in a Pivot Table. At any time you can select the data you want centered and select alignment>center from the main toolbar.

Resource Videos:

• https://www.youtube.com/watch?v=0bojnxjNMTM

• https://www.youtube.com/watch?v=2sjLQDQYF3U&list=PLegswaN4RfQ7t_7Zly9dRVqHKM_JXO1Dw&index=3