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 –
Working Let’s understand with an example of Sales table. We have a report (Figure1: Sales by Sales Person for the year 2017 and 2018) As you can see some of the values are blanks in Column G which is the Sales amount. You have to create a summary of quarterly Sales made by Sales Peron
