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 »
Sometimes it needs to paste a list in reverse then a simple trick should keep in mind. A simple trick to paste in reverse order. Copy the list and paste it. Add an extra column beside this column. Add digits in …
Lesson#44: A Simple trick to paste in reverse order Read more »
Showing a random example worksheet where I have used conditional formatting and color formatting. Now I will make a switch that will trigger the Conditional Formatting ON or OFF. Besides the table, I have made a drop-down list of ON/OFF …
Lesson#43: Make an ON/OFF switch for Conditional Formatting in your excel sheet Read more »
Select the entire sheet by clicking on the most left upper corner of the sheet or by pressing Ctrl+A. Now for coloring alternate rows of the entire sheet at once click on Conditional Formatting>New Rule>Use a formula to determine which …
Lesson#42: Tricks to color alternate rows or columns of the entire sheet at once 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 »
The CHAR function returns the relevant character from the ASCII code. The syntax of the function is CHAR (number) where the number should be within 1 to 255. Example: Related video tutorials: