Calculating correlation can be time-consuming but software like Excel makes it much easier. You can use several methods to calculate correlation in Excel.

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how.