There are a few ways to calculate variance in Excel. One way is to use the variance function, which is VAR. This function takes in an array of numbers and calculates the variance of those numbers. To use the function, type "=VAR(range)" into a cell, where "range" is the range of cells you want to calculate the variance for.

Another way to calculate variance is to use the standard deviation function, which is STDEV. This function takes in an array of numbers and calculates the standard deviation of those numbers. To use the function, type "=STDEV(range)" into a cell, where "range" is the range of cells you want to calculate the standard deviation for.