Amy is an ACA and the CEO and founder of OnPoint Learning ... R-squared in Excel using several methods. The simplest way is to get two data sets and use the built-in R-squared formula.