Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder ... which is vital for accurate analysis. To calculate beta in Excel, use the variance of the benchmark and covariance with the ...