If you were to calculate the standard deviation on the worksheet, without the STDEV.P function, hereâs how you would do it. 1  Find the average of the numbers in the pivot table data. 2  From each number, subtract the average. 3  Square the calculated difference for each number. 4  Find the average of the squared difference. 5  Find the square root of the average.
A pivot table is a tool that you can use to summarize data when you have a lot of it in a worksheet. A pivot table can count totals, give an average of the data, or sort data â in addition to other things. In this article, we are going to go in-depth as we learn to create and work with pivot tables.
Building the Pivot Table. 1  1. Load the spreadsheet you want to create the Pivot Table from. A Pivot Table allows you to create visual reports of the data from a spreadsheet. 2  2. Ensure that your data meets the needs of a pivot table. A pivot table is not always the answer you are looking for. 3  3. Start the Pivot Table wizard. Click the Insert tab at the top of the Excel window. Click the PivotTable button on the left side of the Insert ribbon. If you are using Excel 2003 or earlier, click the Data menu and select PivotTable and PivotChart Report...