Calculating the Pearson correlation coefficient can be complicated but software makes it much easier. You can use several methods to calculate correlation in Excel.

Investopedia.com. If you want to create a correlation matrix across a range of data sets, Excel has a data analysis plugin. To use it, you must first enable the data analysis ToolPak.