How do you calculate Beta by using Variance and Covariance?

You can use the slope function on Excel which takes a cell range representing the Y-Variable and another cell range representing the X-Variables. For instance the Y-Variable may be a column of excess returns for a stock and the X-Variable maybe the column of risk premia.