Lesson#18: What is MOD function?
MOD function returns the remainder after dividing a number with a divisor. Syntax of the function …
Lesson#17: How to use function IFERROR
Function IFERROR returns the value_if_error if the expression is an error and the value of the …
Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC
Lesson#16 will introduce you to some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC. Function TODAY returns …
Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC Read more →
Lesson#15: Know about functions DATE, DAY, MONTH, YEAR
In this post, we will talk about the functions DATE, DAY, MONTH, and YEAR. DATE function …
Lesson#15: Know about functions DATE, DAY, MONTH, YEAR Read more →
Lesson#14: What is CONCATENATE function
CONCATENATE function joins several text strings into one text line. In this post, I will show …
Lesson #13: Make a perfect SIP Planner in Excel
Hello friends! in this post I will give you an example of making a SIP planner …
Lesson#12: How to use function SUMIF
Function SUMIF adds cells specified by a given condition or criteria. Syntax of function SUMIF is …
Lesson#11: How to use the HLOOKUP function in Excel?
HLOOKUP is a function that looks for a value in the top rows of a table …
Lesson#11: How to use the HLOOKUP function in Excel? Read more →
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE
You are having a table full of data and you want to convert columns to rows …
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE Read more →
Lesson #9: VLOOKUP explained
In this post function, VLOOKUP is explained here once more with a very simple example. VLOOKUP …