Project on VBA Macros – Automation using Loop

This advanced training on VBA will help you learn decision Making using VBA, variable and data types.

5

 28m | 5 Videos | 67134 Views |   Intermediate

Introduction to Automation using Excel VBA:

Visual Basic for Applications (VBA) is user friendly programming language developed by Microsoft. With VBA we can design a very good interactive screen with all label, text boxes and buttons; and by doing proper coding with Macros, we can make this work very simpler and systematic.

A macro consists of instructions that the user can record as per his/her need & associate with a shortcut key combination or a macro name. Then whenever that shortcut key is pressed or macro name is clicked, computer automatically carries out those set of instructions.

Course Objective:

• Conceptual and practical understanding of VBA features
• Decision Making using VBA, variable and data types

Target Customers:

• Suitable for students pursuing Degree, Diploma, Engineering, commerce and all general studies
• MBA, BBA students from all specializations
• Charted Accountant (CA)
• Also suitable for working professionals
• People who want to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker for them Excel is the language that they should speak

Pre-Requisites:

• Basic knowledge of using Excel
• Basic knowledge of applying VBA
• Passion to learn

Back to top ▴