Lesson#116: How to name a range in excel
This post will teach you the basic concept of Name Manager. Here I will show how …
Tag: VLOOKUP
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#59: If A=1, Z=26 then calculate the value of your name
This sheet can calculate the value of your name or any word by summing every letter …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more →
Lesson#52: Let’s check your lifeline with Excel
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by …
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#17: How to use function IFERROR
Function IFERROR returns the value_if_error if the expression is an error and the value of the …
Lesson #13: Make a perfect SIP Planner in Excel
Hello friends! in this post I will give you an example of making a SIP planner …
Lesson #9: VLOOKUP explained
In this post function, VLOOKUP is explained here once more with a very simple example. VLOOKUP …