How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your data set already entered ... you would select the range of cells you want to use after the parentheses.