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 …
Lesson 25 is a discussion about the function WEEKNUM. This function returns the week number in a year. Syntax of this function is WEEKNUM(serial_number,[return_type]) where serial_number is a date and [return_type] is optional. A number that determines on which day the …
Lesson#25: Function WEEKNUM has a good use for construction people Read more »
In this post, we will discuss two formula which converts the Roman number system to Arabic and Arabic to Roman. Function ROMAN converts the Arabic number system to Roman. Syntax of this function is ROMAN( number, [type] ). Here the …
This post has tips for those who need to work in excel regularly in office work, study, and other areas. We should keep in mind that working by not using a mouse, just using a keyboard increase our working speed. …
Lesson#23: Work fast in Excel using keyboard shortcuts Read more »
LEN is a function that is used for finding out the number of characters in a text string. Its syntax is LEN(text). THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG has 43 characters including <space> between words. Now I will …
Lesson#22: How to find the exact middle character(s) of text using LEN Read more »
Three functions LEFT, RIGHT, and MID is very useful for extracting characters from a text string. In this post, we will discuss these three functions.LEFT is a function that returns the specified number of characters from the start of a …
Lesson#21: Extracting data with LEFT, RIGHT and MID function Read more »
In this post, we will talk about the formula DATEDIF(). This the formula is used to get the difference in days, months, or years between two dates. In excel we are unable to find any help with the formula but …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more »