Lesson#101: Hyperlink all files and folders in the worksheet within a minute
Here in this post, I will show you how to hyperlink all files and folders in …
Lesson#101: Hyperlink all files and folders in the worksheet within a minute Read more →
Excel Funtions
Lesson#100: Making a master formula to separate words from the sentence
Hello. Now we will learn how to make a master formula to separate words from sentences. …
Lesson#100: Making a master formula to separate words from the sentence Read more →
Lesson#99: Formula to separate words from a full name
OK. I am back again with some crazy formula. Here in this post, I will show …
Lesson#99: Formula to separate words from a full name Read more →
Lesson#88: How to make a Salary slip format from Employee Database
So, my friend, I will here discuss an important lesson which is really required for office …
Lesson#88: How to make a Salary slip format from Employee Database Read more →
Lesson#86: Logic Gates in Excel
So I show you here how the logic gates can be configured in Excel. AND gate …
Lesson#76: Difference between EDATE and EOMONTH
What is the function EDATE? UPDATE returns the serial number format date with the same day …
Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest
When you want to get the smallest or the largest number from an array then it’s …
Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest Read more →
Lesson#68: COUNTIFS and SUMIFS function in Excel
COUNTIFS is a function to count those cells within a range which meets multiple criteria.Syntax of …
Lesson#68: COUNTIFS and SUMIFS function in Excel Read more →
Lesson#67: Count cells in Excel having values between two dates
Here I am having a list of dates. Now I will show how to count cells …
Lesson#67: Count cells in Excel having values between two dates Read more →
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination
Here I will discuss three functions COUNT, COUNTA, and COUNTBLANK, and show their similarity or difference. …
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination Read more →