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 »
CONDITIONAL FORMATTING highlights the cells with a certain color, depending on the cell’s value. It allows you to distinguish those cells of the given criteria in the spreadsheet. This is a very essential feature of excel. In this post, I …
Lesson#29: Explaining CONDITIONAL FORMATTING very simply Read more »
What is NETWORKDAYS function? This function calculates the networking days between two dates. This function is useful for project scheduling, employee benefits calculation, business days calculation, etc. Syntax of this function is NETWORKDAYS(start_date, end_date, [holidays]) Where, start_date is a date …
Lesson#28: NETWORKDAYS and NETWORKDAYS.INTL is very essential for project scheduling Read more »
In this post, we will learn to make a calendar which will take input of month from 1 (JAN) to 12 (DEC) and year in numeric format and show the whole month calendar. 1st Step: Make a 2×2 table like …
Lesson#27: How to make a calendar in excel without VBA Read more »
WEEKDAY is a function that returns the day of the week corresponding to a date. from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. Syntax of the function is WEEKDAY(serial_number,[return_type]) serial_number is a sequential number …