What is the best way to measure correlation in a large set of data?

[peteratsal]

I have been tracking about 10 variables on a daily basis (cups of coffee consumed, hours of sleep, etc.) for months now, only to realize now that I can't quite figure out how to look at the relationships among different variables.

I would be ecstatic if I could just create a scatter plot that visually shows me the relationship between Row A in my spreadsheet against each of my 25+ other variables.

So if you look at the attached, Row A in the doc is labeled "Motivation." I'm curious to see how other factors (tracked in all the other rows to the right) have contributed to Row A.

Ideally, I'd like to look at all 25 of these unique two-variable relationships one at a time--i.e. I don't want one incomprehensible scatter plot with 25 different colors of dots everywhere. I'd also rather not go through the process of learning how to create a scatter plot and making 25 of them...there has to be a more efficient way of looking at variables in Excel...right?

Can you point me in the right direction to research further? Your reference to the video above was tremendously helpful...here's to hoping I can push through to the end and maybe even gain some new insights.

Cheers,
Zach