How to make a correlation matrix in excel using conditional formatting

Change the column and row size to make the cells into squares. Add conditional formatting to have coloured cells showing how good the correlations are. Then use powerpoint to combine a circle and a square shape to change all the coloured cells into circles.

--------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 1906

These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
How to make a correlation matrix in excel using sparklines    • How to make a correlation matrix in e...  
How to make a correlation matrix in excel using a bubble chart    • How to make a correlation matrix in e...  
This video is part of a playlist: Correlations in excel    • Correlations in Excel