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:
DEC2OCT converts the Decimal number system to the Octal number system. Syntax of this function is DEC2OCT( number, [places] ) where number is the number in decimal format. [places] is optional, which specifies the number of characters that you want the returned octal number to have. If omitted …
DEC2HEX converts the Decimal number system to the Hexadecimal number system. Syntax of this function is DEC2HEX( number, [places] ) where number is the number in decimal format. [places] is optional, which specifies the number of characters that you want the returned hexadecimal …
Lesson#34: Decimal to Hexadecimal by DEC2HEX function Read more »
DEC2BIN converts the Decimal number system to the Binary number system. The syntax is DEC2BIN(Number, [places]) where Number is the decimal number and [places] is optional. The number of characters to use. If places are omitted, DEC2BIN uses the minimum …
Lesson#33: Decimal to Binary by DEC2BIN function Read more »
The UPPER function converts a text string to all uppercase letters. The syntax of this function is UPPER(text). An example of the UPPER function is shown in the pictures above. The LOWER function converts a text string to all lowercase letters. The …
Lesson#32: UPPER, LOWER, PROPER, TRIM Text functions in Excel Read more »
This post is a continuation of one of my previous posts Lesson#27: How to make a calendar in excel without VBA. I will show how to modify this calendar a little more and make it a current dynamic calendar for …
Lesson#31: Current dynamic calendar for whole Year Read more »
In my previous post Lesson#29: Explaining CONDITIONAL FORMATTING very simply I explained CONDITIONAL FORMATTING. In this post, I will show how to modify CONDITIONAL FORMATTING by using a formula. 1st you have to select the area where you want to apply CONDITIONAL …
Lesson#30: Modify CONDITIONAL FORMATTING by using formula Read more »