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 →
Tag: IF
Lesson#27: How to make a calendar in excel without VBA
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 →
Lesson#25: Function WEEKNUM has a good use for construction people
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 →
Lesson#22: How to find the exact middle character(s) of text using LEN
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 →
Lesson#19: How to convert digit into word in excel
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 →
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF
In our 8th lesson, I will discuss COUNT, COUNTIF, and the combination of IF and COUNTIF. …
Lesson#8: COUNT, COUNTIF, and combination of IF and COUNTIF Read more →
Lesson#7: How to make nested IF in Excel?
In this post we will discuss nested IF making. I have to show Grade on the …
Lesson#6: What is Function IF in Excel?
In this post, we will discuss function IF. IF is a logical function that checks whether …