filmov
tv
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
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:
--------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts
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:
0:00:35
0:05:40
0:02:14
0:07:33
0:05:22
0:12:57
0:01:54
0:09:52
0:00:58
0:02:19
0:04:48
0:01:56
0:05:17
0:09:26
0:07:50
0:01:11
0:02:52
0:04:31
0:06:11
0:04:29
0:05:16
0:02:07
0:06:12
0:01:12