This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more →
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
CODE is the opposite of the CHAR function. The syntax of this function is CODE(text). It will return the ASCII value of the first character of the text. I have shown in the above pictures how an ASCII table is …
This character “*” (Asterisk) is used to denote any text within a cell. 1. If you use the formula =COUNTIF(range, “*”) then it will count the numbers of cells having any text within range. 2. If you use =COUNTIF(range, “CEMENT*”) …
Lesson#46: Count cells that contain any text or part of that text Read more →
If you know the use of the character “&” then it can replace the function CONCATENATE. You can join one or more numbers or texts using “&” between them to convert them into a single text. Place “&” and other …
Lesson#45: “&” can replace the function CONCATENATE Read more →
The INDEX function returns a value or reference of the cell at the intersection of a particular row and column, in a given range. Syntax of this function is INDEX(array, row_num, [column_num]) The array is required, If the array contains only one …
OR function checks whether any of the arguments are TRUE then it returns TRUE or it will return FALSE.Syntax of that function is OR(logical1, logical2, ….)Example: Here I have shown an example where the values of the C column are going to …
Hi, friend today I will show you how to make an automatically updating Gantt chart without using an Excel chart. Here I am making a program schedule with this criteria Activity no, Description, Start Date, End Date, and Days (shown …
Lesson#39: Cool tricks to make automatically updating Gantt chart Read more →
AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE then it returns TRUE. Syntax of that function is AND(logical1, logical2, ….) Example: Here I have shown an example where the values of the …
What is WORKDAY? This function returns the serial number of the date before or after a specified number of workdays. Syntax of the function is =WORKDAY (start_date, days, [holidays]) where, start_date is the date from which to start. days is the working days …
Lesson#37: WORKDAY, WORKDAY.INTL is very essential for project scheduling Read more →