Excel VBA Functions for Data Analytics Series5
Discussion on functions - User defined functions as well as vba in-built functions ( complete tutorial)
4.85 (10 reviews)
84
students
6.5 hours
content
Nov 2021
last update
$19.99
regular price
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
Screenshots
Related Topics
1639940
udemy ID
4/10/2018
course created date
2/8/2020
course indexed date
Bot
course submited by