Highlight cells using custom formula

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

Continue Reading

How to Get VLOOKUP to Return a 0 Instead of #NA

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

Continue Reading

How to surprise your boss with Sparklines

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 –

Continue Reading