A heat map (or heatmap) is a graphical representation of data where values are depicted by colour. Take the example below which displays the number of people who visited a fictitious store, broken down by hour and day during a particular month.

It’s a lot easier to understand the data and spot patterns and trends by looking at the second screenshot compared to the first one.

In this video you’ll learn how to use Conditional Formatting to create a simple heat map in Excel.