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.
Here are the steps to create a Pivot table in Excel 2010. Step 1: First of all, please make sure to select the data range for which you want to make the pivot table. Step 2: Insert the Pivot Table by going to the Insert tab and then clicking the Pivot Table icon.Step 3: Select the target cells where you want to place the pivot table.tep 2: Insert the Pivot Table by going to the Insert tab and then clicking the Pivot Table icon. Step 3: Select the target cells where you want to place the pivot table.