V LOOKUP and H LOOKUP are important functions in Excel that can be used for finding values in an Excel sheet. This article will explain about the various provisions provided by both. V LOOKUP in Excel V LOOKUP or Vertical Lookup is a worksheet function that helps a user search for a given piece of …
V LOOKUP and H LOOKUP: Important MS Excel Functions Read More »
Compatibility functions are those functions that were replaced by new functions later on in Excel. These can still be used by going to this option. Here we will discuss about two functions – FLOOR and MODE. Compatibility Functions – FLOOR This function can be used if the user wants to round the number to a …
FLOOR and MODE: Important Compatibility Functions in Excel Read More »
Microsoft Excel has a few web functions that can be used while dealing with links. In this article we will look at two such functions – WEBSERVICE and ENCODEURL. These functions help one in dealing with data that are related to programming and coding. These functions were available from the Excel 2013 version. Web Functions …
WEBSERVICE and ENCODEURL: Important Web Functions in MS Excel Read More »
Time Functions can be used along with the date functions to show various points of time of the day. In this article we will look at the TIME and TIMEVALUE functions. Time Functions – TIME Sunil is making an Excel sheet for making a schedule in which he needs to enter the time for each …
TIME and TIMEVALUE: Important Time Functions in MS Excel Read More »
Information Functions can be used when one deals with important data. Two important functions in this category are CELL and ERROR.TYPE. We will look at these in detail in this article. Information Functions – CELL This function can be used to return the information of the cell one is entering in. For example, Sreya has …
ERROR.TYPE and CELL: Important Information Functions in Excel Read More »