This post will teach you the basic concept of Name Manager. Here I will show how to name a range in excel. You can also create names for the range, reference, or formula to work in the spreadsheet easily. Above …
So, my friend, I will here discuss an important lesson which is really required for office people. That is how to make a salary slip from an employee database. This is not about salary slips only, we can make many …
Lesson#88: How to make a Salary slip format from Employee Database Read more »
This sheet can calculate the value of your name or any word by summing every letter in alphabetical order. Here I have created a box to input a word. I have put this formula =LEN(B2) to calculate the length of the …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more »
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
In this lesson, we will learn a method to convert digits into words. I will use functions like CONCATENATE, VLOOKUP, SUM, IF, and MOD, which were discussed in my previous posts. 1st Step I have made a list of relevant …
Lesson#19: How to convert digit into word in excel Read more »
Function IFERROR returns the value_if_error if the expression is an error and the value of the expression or reference. Syntax of the function =IFERROR(value, value_if_error). Here I will give you a small example. Here in the picture, you can see …
Hello friends! in this post I will give you an example of making a SIP planner in Excel. As you know there are so many apps in the market to calculate SIP (Systematic Investment Plan) but it would be nice …
In this post function, VLOOKUP is explained here once more with a very simple example. VLOOKUP looks for the value in the leftmost column of a table. It means the lookup_value column should be placed on the right side of …
