Excel VBA Functions for Data Analytics Series5

We are learning everything about VBA Functions from their definitions to their practical use in excel day to day work life.

Lessons are started from very basic understanding and gradually moving toward advance levels. 

You will see the use of functions practically as well and their powerful and unique combinations with loops and arrays. Must watch for wannabe developers

VBA has its own function library and it offers various powerful function just like excel. Let us see how to use Inbuilt functions of VBA

UDFs – User defined functions in VBA

Advantage of UDFs over Inbuilt excel functions. From limitations to dealing with complex situations – I have got everything for you. Many amazing projects are shared in the series.

Can we pass in parameters in sub routines .

How to Call Functions from excel sheets or sub routines.

How to do debugging of UDFs and Inbuilt VBA Functions.

What is the process of passing parameters from a sub routine to a function and how it is useful for us.

Questions asked in your VBA Interview.

Assignments are added to give you a real exposure.

How to use VLOOKUP in VBA at advance level project discussed. Real application coming your way.