Creating custom functions in Microsoft Excel can help automate your work.
Today morning it was raining cats and dogs. My good old walking friend called me up and insisted that we must not miss our walk. But I reminded him that it was raining and how! He just would not give up and I gave in. I hate to say 'no' to my friends. Also, I thought: let's have some fun in the rain because everybody at home was sleeping anyway. I reached the forest at around 5:45 a. m. And surprise of surprises! All the friends were there. They were all grinning like jackals. I became alert. Now what? What were these guys planning? Now one of them says: You know that guy claims that you can't create your own functions to calculate in Excel. So that's it! Well, that's what good friends are for, isn't it? I explained in detail that you can create a custom function using macros in Microsoft Excel. They almost fainted. Macros! No, they were not interested in programming. So, I promised to send them a 'steamy' video. My friend called up to say that it was a dry steamy video. Nonetheless, he enjoyed it and that he owed me a coffee with the sinful brownie at Cafe Coffee Day!
Here's the custom function I wrote and you can view the video on my website. You start the Visual Basic Editor and enter the following code:
Function paypackage(salary)
'House Rent Allowance (HRA)
'HRA=60% of basic salary,br>
'Leave Travel Allowance (LTA)
'LTA=8.33% of basic salary
paypackage = salary + salary * 0.6 + salary * 0.0833
End Function
This function automatically calculates the paypackage of an employee based on the basic salary that you assign this Employee.
What is Excel and how do I use it?
A complete guide to how Microsoft Excel is used.Using the Function - If - In Excel
How can you perform calculations based on criteria? Use the 'if' function!Getting Information From Your Data in Excel
Once you have data in an Excel worksheet, the next step is to extract information out of the data. For example, a teacher may need to know which students got grade A in Maths, an employer may need to know about all the employees who were absent for more than 3 days in a month or a doctor may need to know how the patient responds to a certain medicine.