Excel VBA FUNCTIONS & ARRAYS with Projects - Series3

Goals

What will you learn in this course:

• In section1 , We will learn that What are arrays .Why we use them? Why they are so powerful and holds so much weightage in VBA learning.
•  What is their by-default index system and how we can change it using option base. 
• What are static and dynamic arrays.
• how to use arrays with VBA loops and if functions . They work like magic together. 
• What is the use of Preserve word in arrays and how we can use it in projects.
• Complete tutorial with in-depth discussion.
• How to use split function in arrays and what are the key things to be taken care while using split in arrays.
• Questions discussed from  VBA interview perspective as well.
• As usual- Assignments are also added to give you confidence and to check the progress.
• how to use Dim or Redim Statements .Their real use in projects. How to use variable value in Arrays and what is the purpose of using them in arrays.
• How to use split function ,one of the best function we can use in arrays. How arrays work under split function.
• How option Base-1 works for arrays created by split function.
• What is the use of preserve word in arrays and how we can use it to hold the values. What happens if we do not use them.
• How and where we use them . Complete discussion on its use.
• For more understanding on arrays tutorial we are discussing amazing Projects. Only for you. In-depth discussion.

• In section2, 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.

Prerequisites

What are the prerequisites for this course?

You should have good knowledge of VARIABLES & LOOPS before opting for this Course.

If you know it , you can take this course otherwise you can see Part1 and Part2 before this one.