How to Calculate Variance in Excel . To calculate variance in Excel, you will need to have your data set already entered into the software. Once you have your data, ...