Lesson#22: How to find the exact middle character(s) of text using LEN
LEN is a function that is used for finding out the number of characters in a …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more →
Excel Funtions
Lesson#21: Extracting data with LEFT, RIGHT and MID function
Three functions LEFT, RIGHT, and MID is very useful for extracting characters from a text string. …
Lesson#21: Extracting data with LEFT, RIGHT and MID function Read more →
Lesson#20: Making an age calculator in excel with DATEDIF function
In this post, we will talk about the formula DATEDIF(). This the formula is used to …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more →
Lesson#19: How to convert digit into word in excel
In this lesson, we will learn a method to convert digits into words. I will use …
Lesson#19: How to convert digit into word in excel Read more →
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 …