ANALYTICS TRAINING HUB

The Excel YEAR function returns a 4-digit integer representing the year corresponding to a specified date. A 4-digit year of the date is returned as an integer in the range 1900-9999. Read more..

The Excel DAY function returns the day of the month from a supplied date as an integer ranging from 1 to 31. In other words, using DAY function, you can find out the day of the month that corresponds to a given date. Read More...

OFFSET function This tutorial explains the uses of Excel OFFSET function with examples. You also learn how to use the OFFSET to create a dynamic range that helps other function to keep the calculation up to date. Read More...

Vlookup Function in Microsoft Excel If there is talk of most popular function in Microsoft Excel, VLOOKUP is going to be one of the function top in the list. Any Excel training course or job without the inclusion of the VLOOKUP function is always considered incomplete and in this tutorial you are going to learn about this awesome Excel Function. Read More...

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!