Help calculating correlations/relationships with several variables

Hey guys, I know there's a way to do this...want to see what your suggestions for the most efficient way to format this. Ultimately I need to understand relationships/correlations between each of the variables, updated each day when I input the data.

I've used the pearson's, but I'm not sure this is the best way since there are so many variables. Also, I know the pearsons shows the correlation, but can someone put it in terms that make sense to me...ie the first variable causes the second and is correlated 65%.

Thanks for you help Excel Gods!!!

Does anyone at least have decent free software to use to do this??

Did you ever get an answer to your question? I'm having the same problem.

@ SixSigmaGuy

Since this thread is over 3 years old and the OP hasn't posted anything for more than a year you would be better off starting a new thread of your own (and you wouldn't be breaking Rule #11 by doing that).