![\"\"](\"\/wp-content\/uploads\/Image-1.png\")
<\/p>\nMicrosoft Excel is a really useful tool for organizing data. Using something called a heat map strategy can help you get more out of the solution. If you actively use spreadsheets in your business to contextualize data, you will find this easy-to-use tip for using heat maps really useful.<\/p>\n
<\/p>\n
The heat map is simply a way to represent the data in a spreadsheet that portrays a more in-depth context than the base data can provide.<\/p>\n
For example, say you have a dataset and you wanted to give a summary of what the whole thing represents. One of the best ways to do this is with a heat map. Let\u2019s look at an example:<\/p>\n
Say you want to be sure your team is using their sick time. Healthy and happy workers work better and studies have shown that workers that use their available time off are happier and healthier. If you have a 15-person team, it\u2019s a fair amount of data to sift through to get answers. Here\u2019s how heat mapping works.<\/p>\n
Here is the dataset that we want to use:<\/p>\n
<\/p>\n
You just need to highlight the names and the numbers of days taken sick, select Format<\/strong> from the menu, and click on Conditional formatting<\/strong>.<\/p>\n Once the Conditional format<\/strong> rules<\/strong> window opens, select + Add another rule<\/strong> and then select Color scale<\/strong>.<\/p>\n You\u2019ll then see your selected range defined in the Apply to range<\/strong> box. You will see an additional field with Format rules<\/strong> available. Under Minpoint<\/strong>, make sure Min value<\/strong> is selected, and then you can select the color that you want to use to represent that value. For this example, we\u2019re trying to determine which employees have used the least number of their available days, so we\u2019ll go with red, as it\u2019s a bit of a red flag. Under Maxpoint<\/strong>, do the same, but select Max value<\/strong> and select a different color. Since these employees are the ones who are using enough of their vacation days, we\u2019ll use green.<\/p>\n For Midpoint<\/strong>, use the number between the highest and the lowest. For our example, we\u2019ll estimate that this value is 7.<\/p>\n Click Done, and your spreadsheet will light up with different colors, with green representing the highest amount of days off and red representing the fewest. You will see below that as the number of days off escalates, colors change.<\/p>\n This is just one example of the use case for heat mapping. You can use it on any data set to quickly get a visual representation of the underlying data much faster than trying to sort it all.<\/p>\n For more great tips and tricks, give the IT professionals at Nexela a call at (215) 525-3223 and return to our blog regularly.<\/p>\n","protected":false},"excerpt":{"rendered":" Microsoft Excel is a really useful tool for organizing data. Using something called a heat map strategy can help you get more out of the solution. If you actively use spreadsheets in your business to contextualize data, you will find this easy-to-use tip for using heat maps really useful.<\/p>\n","protected":false},"author":4,"featured_media":6218,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50,63],"tags":[82,92,85],"class_list":["post-6227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-tip-of-the-week","tag-data","tag-user-tips","tag-workplace-tips"],"yoast_head":"\n![\"\"](\"\/wp-content\/uploads\/Image-2.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/Image-3.png\")
<\/p>\n![\"\"](\"\/wp-content\/uploads\/Image-4.png\")
<\/p>\n