To calculate beta in Excel, use the variance of the benchmark ... It looks like this as a formula: If something has a beta of 1, then it’s often assumed that asset will go up or down exactly as much ...