To calculate beta in Excel, use the variance of the benchmark and covariance with the asset. A beta of 1 indicates an asset's sensitivity to returns is equal to the market. For assets without regular ...