Creating a PivotTable in Excel

FUNctions with Fil Sept 12.xlsx

1. 1. Click and Drag to highlight the data you want to include in your pivot table.

   

2. 2. Click on Insert

   

3. 3. Click on PivotTable Show More Options

   

4. 4. Click on From Table/Range

   

5. 5. Click on Existing sheet or New Sheet if you'd like your pivot table to show on a new sheet.

   

6. 6. Click on Insert

   

7. 7. click to select which data you want to include in your pivot table.

   

8. 8. Select from the pulldown menu where you want to put your selected data. These are your choices.

   

9. 9. Continue selecting any more data you want to include.

   

10. 10. And indicating where you would like that data place in your pivot table.