Visual Basic for application (VBA) for Excel is to automate repetitive Task, Reduce work load & unlock real Excel Power.

In this course, Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.

You will first learn how to record a Basic macro, how to define Short cut key, how to debug and run macros. Once you are comfortable with VBA environment, we will cover most frequently used commands like Do while, For Next, Input box, Userform, Workbook and worksheet Events. At last we shall take many practical long problems to advance your knowledge on VBA.

The best way to learn Macro is to learn it with case studies. With case studies, you develop your creativity. You will learn multiple ways to write a program with different coding.

Download