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 →
Lesson#36: Convert ASCII code to its relevant character with the function CHAR
The CHAR function returns the relevant character from the ASCII code. The syntax of the function …
Lesson#36: Convert ASCII code to its relevant character with the function CHAR Read more →
Lesson#35: Decimal to Octal by DEC2OCT function
DEC2OCT converts the Decimal number system to the Octal number system. Syntax of this function is DEC2OCT( …
Lesson#34: Decimal to Hexadecimal by DEC2HEX function
DEC2HEX converts the Decimal number system to the Hexadecimal number system. Syntax of this function is DEC2HEX( …
Lesson#34: Decimal to Hexadecimal by DEC2HEX function Read more →
Lesson#33: Decimal to Binary by DEC2BIN function
DEC2BIN converts the Decimal number system to the Binary number system. The syntax is DEC2BIN(Number, [places]) …
Lesson#33: Decimal to Binary by DEC2BIN function Read more →
Lesson#32: UPPER, LOWER, PROPER, TRIM Text functions in Excel
The UPPER function converts a text string to all uppercase letters. The syntax of this function is …
Lesson#32: UPPER, LOWER, PROPER, TRIM Text functions in Excel Read more →
Lesson#31: Current dynamic calendar for whole Year
This post is a continuation of one of my previous posts Lesson#27: How to make a …
Lesson#31: Current dynamic calendar for whole Year Read more →
Lesson#30: Modify CONDITIONAL FORMATTING by using formula
In my previous post Lesson#29: Explaining CONDITIONAL FORMATTING very simply I explained CONDITIONAL FORMATTING. In this post, I …
Lesson#30: Modify CONDITIONAL FORMATTING by using formula Read more →
Lesson#29: Explaining CONDITIONAL FORMATTING very simply
CONDITIONAL FORMATTING highlights the cells with a certain color, depending on the cell’s value. It allows …
Lesson#29: Explaining CONDITIONAL FORMATTING very simply Read more →