Excel VBA Functions for Data Analytics Series5
Discussion on functions - User defined functions as well as vba in-built functions ( complete tutorial)
Description
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.
How to use Match function in a loop along with VLOOKUP to create this wonderful real practical automation.
My online support forever for you.
What You Will Learn!
- You will be master in creating your own designed functions and your team can use it in excel
- Learn how to create your own custom built functions . We call them USER DEFINED FUNCTIONS, UDF.
- How to write UDFs and why do we need it . Advantages of UDFs in VBA
- How to use arguments in UDFs. What happens if you give more arguments and user uses different arguments
- How to debug functions . Can they run on F8 mode
- Learn about type mismatch errors if you provide wrong arguments types in your functions.
- How to use VLOOKUP , LEFT, RIGHT inbuilt functions in VBA.
- Several Projects for you to give practical visibility
- You will also understand the mixing of arrays ,loops with functions which is going to be pretty awesome.
- Functions use Loops and Arrays a lot so we must know this as well other than understanding basics and fundamentals.
- Take a deep dive into VBA Date and time functions too
Who Should Attend!
- People who want to make their own functions and get them executed in excel sheets. if you want to be a great programmer you simple cannot avoid this.