Tuesday, January 15, 2019

How to Create User Defined Functions in Excel (Function to convert n...

The latest version of MS Excel has more than 450 inbuilt functions in it. But still, there are times when we feel these functions are not enough to carry out our work. A Simple example is A function that can convert numbers into words. Thousands of accountants will love to have this function in Excel.

The good news is MS Excel allows us to create functions of our own which can make our life easier.

Topics discussed are :

1. Creating User Defined Function (UDFs)

2. Example 1 - Function for finding out Area of Rectangle

3. Example 2 - Function for finding out Area of Triangle

4. Function for converting numbers into Words






No comments:

Post a Comment

Most Used Formula in Excel (15 functions explained in 20 minutes)

Most Used / Most useful 15 Functions in MS Excel are explained with simple Examples, in this video. A must watch Tutorial for Beginner and...