Standard deviation is a measure of how spread out a set of data is. To calculate standard deviation in Excel, you first need to calculate the variance. To do this, subtract the mean from each data point and then square the result. Add up all of these squared differences and divide by the number of data points minus 1. This is the variance. To calculate the standard deviation, take the square root of the variance.