If you subscribe to these tips, you should already know that people can interpret visual information faster and more easily than text and numbers. Even if you’re dealing with a table of numbers there are ways to present them visually. Depending on your context, charts are often a great option. For those times when seeing all the data and actual numbers is important you might want to consider a heat map.
A heat map is a graphical representation of data where the individual values contained in a matrix are represented as colors.
Fortunately, Excel’s conditional formatting feature makes this super quick and easy. (We love that!)
Let’s take a look at how easy this is by starting with a typical table of Excel data:
To turn this into a heat map, select the range of data and go to the Conditional Formatting button on the Home Ribbon. From there, find the
View original post 127 more words