Conditional Formatting in Excel - Color Scale - Data Analysis  -  Office 365
Channel: Efficiency 365 by Dr Nitin
Date: 2020-07-23

Learn Color Scale - Conditional Formatting in Excel - understand how to find outliers and see clustering pattern in data analysis. Best used with large amount of data. Zoom out to see the patterns. Using it with small data can be confusing.

00:00 Intro
00:27 Colour Scale - Simple data
01:33 Identifying clusters
02:12 Highlighting outliers
02:33 Colour Scale without numbers



Learn from Dr Nitin Paranjape's Office 365 Blog - Efficiency 365 - 
Excel Conditional Formatting - Color Scale - http://efficiency365.com/2014/06/04/using-color-to-simplify-understanding-information/

How to use dark mode - https://efficiency365.com/2020/07/19/office-dark-mode-reduce-eyestrain-windows-teams-office/