ANALYTICS TRAINING HUB

MOD function is named after "Modulo" which is a computer term and the diviser used in division equation is called as "modulus". The function returns the leftover / remainder of one number divided by another divisor number. Watch Video !

The Excel  FIND  function returns the position of a character or sub-string within a supplied text string. Function returns output only in number form as the starting position of a character. Read More....

INT function returns a number after ignoring the fractional part of a number or in other words, it returns the whole value of a number. But this function returns to next lower integer value so when negative value is supplied, it becomes more negative. Also you will learn how we can convert timestamp in Microsoft Excel. Watch Here!

In this video tutorial, I have shared one of my friend's recent Interview experience with one of the Top MNC (Cognizant - Gurgaon). He was asked some of the tricky questions and he got stuck with few of them. I decided to make a series of some Hot Interview Questions and this is the first video in this series. In this tutorial, I have used VLOOKUP with MATCH and INDEX with MATCH functions to build a customize formula to "Perform Two 2 Way Lookup". The video teaches Beginning to Advanced Level of knowledge of both formulas. Watch Here!

Excel SUBSTITUTE Function can be used to replace one or more instances of any specific character or sub string in a give text string. The function is case-sensitive and does not support wild-card characters as well. Watch Here!

We have created Youtube Channel for Excel users. Through this channel we are trying to provide Excel tutorial and Excel tricks for those who has interest into learning Microsoft Excel from scratch and those who wants to upgrade their Excel knowledge. Please subscribe us to get the notification for all upcoming videos. https://www.youtube.com/channel/UCT0uGNH5koT5UpjZAgsjouA

Microsoft Excel FIND Function or Formula helps in searching the position of specific character or sub-string in a text string. In this short video, you can learn the use of FIND function to find the the first instance of any character. But you have to be careful as this function is Case-Sensitive and does not support wildcard characters as well. Watch here!