​

1. Open the Microsoft Excel Application by double clicking the green Microsoft Excel application icon.​​

     - The application will open up to the home screen.

2. Select the template option titled “Blank Worksheet”.

     -This will allow you to open a blank excel spreadsheet to input data.

3. Input your data into the spreadsheet cells that you would like to be made into a pivot table.

     - The data should be organized by tabs.

4. Once you have input all of your data into the cells, go to the tabs at the top of the screen in Excel and select “insert”.

5. Select the “Pivot Table” button located on the far left under the “Insert” tab.

6. A dialog box will appear titled “Create Pivot Table”

    - In this dialog box you will select the data you want to analyze as well as where you would like the Pivot Table to be placed within the sheet.

7. Select the range of data you would like to be formatted into a pivot table.

    - First, click the box with the red arrow located under “Select a table or range” in the dialog box, located on the right side of the box.

    - The dialog box will then minimize and your mouse will turn into a + symbol.

    - Using your mouse (which is now a + symbol) click and drag across the tabs you created and the cells below them you want to be inserted into the             Pivot Table.

    - When you release your mouse, you should now see a green dotted line around the cells you have selected rotating clock-wise.

8. Next, click the box with the red arrow located in the minimized dialog box. 

    - This will maximize the view of the dialog box again.

9. Now select where you would like the Pivot Table to be inserted on your spreadsheet, in the dialog box.

    - You can do this by clicking “New Sheet” in the dialog box, which will place the Pivot Table in a new sheet in Excel.

    - You can also add the PivotTable to the existing sheet by clicking the box with the red arrow again, but this time clicking the box with the red arrow located under the section within the dialog box titled “Existing worksheet”.  

    - Your mouse will then turn into a + symbol again.

    - Click a cell within the worksheet where you would like to place the Pivot Table.

    - A good spot typically, is to click a cell that is two rows under your original data.

10. After selecting the location you want to insert your Pivot Table, click the box with the red arrow again.

11. Click “okay” in the dialog box.

    - A Pivot Table Fields chart will now appear on the side of the screen.

12. Lastly, click and drag the tab names you created located under “field names” in the Pivot Table fields chart, into the section titled “rows” located in the Pivot Table Fields chart.

    - This will create the PivotTable. You can check and uncheck the field names to include them in the Pivot Table.

​

​

​