I would caution against using Excel and a correlation coefficent.
The correlation coeffecient (often referred to as r^2)
is relatively insensitive to variations in the data. A better
measure of goodness of fit is chi squared, which you can
calculate when you do a least squares fit. Check out
Numerical Recipes
chapter 15 for details on doing the calculations.
Scott