Subject Line Colourful Comparative View of Data Overview Sometimes you may want to compare data by using colours. Heat map is a visual display that quickly shows you a comparative view of the data with the use of colors. To create a heat map you have to use conditional formatting. Conditional formatting includes the below
Overview Sometimes you may want to make specific data stand out in your spreadsheet and capture the viewer’s attention. You can do that using conditional formatting. Conditional formatting helps you identify important cells in a table based on the conditions you specify. Conditional formatting includes the below options: Highlight cell rules Top and bottom rules
Subject Line Customizing the (hash) #N/A error Overview Sometimes when you don’t find the lookup value using VLOOKUP () function you will get the (hash) #N/A error. #N/A means “not available” or “no value available”). You may want to replace the #N/A message with a customised value then VLOOKUP () function should be nested inside
Overview Sometimes you may need to lookup values on matching patterns or search on part of the value eg: In case of Name you may want to search on the First Name or sometimes in case of any alphanumeric or numeric value you may want to search based on some particular way. You can replace
Click here Subject Line How to surprise your boss with Sparklines Overview Sparklines is a fast and very convenient tool for analysis the dynamics of any data ranges. If you need to quickly analyze a large number ranges of different indicators and surprise your boss with how little you spent your time on it –
