What is NETWORKDAYS function? This function calculates the networking days between two dates. This function is …
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 …
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 …
Lesson 25 is a discussion about the function WEEKNUM. This function returns the week number in …
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 …
This post has tips for those who need to work in excel regularly in office work, …
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 …
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. …
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 …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more →
In this lesson, we will learn a method to convert digits into words. I will use …
Lesson#19: How to convert digit into word in excel Read more →