Lesson#59: If A=1, Z=26 then calculate the value of your name
This sheet can calculate the value of your name or any word by summing every letter …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more →
Excel Funtions
Lesson#52: Let’s check your lifeline with Excel
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by …
Lesson#51: What is the CODE function in Excel?
CODE is the opposite of the CHAR function. The syntax of this function is CODE(text). It …
Lesson#46: Count cells that contain any text or part of that text
This character “*” (Asterisk) is used to denote any text within a cell. 1. If you …
Lesson#46: Count cells that contain any text or part of that text Read more →
Lesson#45: “&” can replace the function CONCATENATE
If you know the use of the character “&” then it can replace the function CONCATENATE. …
Lesson#45: “&” can replace the function CONCATENATE Read more →
Lesson#41: Combination of INDEX and MATCH function is better than any other lookup function
The INDEX function returns a value or reference of the cell at the intersection of a …
Lesson#40: OR function in Excel
OR function checks whether any of the arguments are TRUE then it returns TRUE or it will …
Lesson#39: Cool tricks to make automatically updating Gantt chart
Hi, friend today I will show you how to make an automatically updating Gantt chart without …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more →
Lesson#38: AND function in Excel
AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE …
Lesson#37: WORKDAY, WORKDAY.INTL is very essential for project scheduling
What is WORKDAY? This function returns the serial number of the date before or after a …
Lesson#37: WORKDAY, WORKDAY.INTL is very essential for project scheduling Read more →