Course Curriculum

• The Visual Basic Editor
• Recording Macros
• Editing macros using VBA Editor
• Recording and running macro
• Understanding the project explorer
• Storing macro in different books
• Exploring windows properties
• Creating buttons and assigning macro to it
• Modifying code in code window
• Creating my menu
• Debugging code
• Programming fundamentals
• User forms
• Variable ,data type , constant, Array, object variable 
• Creating forms, form events
• Conditional structures (if. Then, select case)
• Creating custom menus and toolbars
• Logical operators
• Creating Add-ins MIS with database reports
• Looping constructs (for loop, Do loop, while. Wend)
• Built-in-function, creating subroutines
• Working with other applications
• Excel object model
• Working word, PowerPoint and other applications
• Working with object –properties, event and methods (Note: lecture will be conducted on webinar)
• Application objects
• Workbook objects, worksheet object and range objects
• Understanding Security levels
• Charts objects
• Why security
• Pivot table objects
• Security levels and its meaning
• Working with functions
• What is function and subroutine
• Working with live 15 industry oriented
• Writing function using vba editor comprehensive project
• Calling function in other work book

Exam & Certification

• Once you complete this master’s program, you will receive the course completion certificate by ICIT

ICIT Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 50% marks in the quiz. ICIT certification is well recognized in top  MNCs .

Who should attend?

• Any individual who uses Excel in their daily life
• Accountants, Auditors, Financial planners to put an end to boring repetitive tasks >
• Managers, Project Managers, Project Planners who handle excel files and want to become more productive by using macros
• Anyone who wants an introduction to programming or want to seek new skills to improve their productivity

FAQ's

1) Explain what is VBA or Visual Basic for Applications?

VBA stands for Visual Basic for Applications; it is an event driven programming language developed by Microsoft. It is predominantly used with Microsoft office applications like MS-word, MS-Access, and MS-Excel.

2) Mention where you can write your VBA program for Macro?

Module is the place where you can write VBA program for Macro, to insert a Module navigate to Insert ->Module

3) Mention what are the comments style used in VBA?

Comments are used to document the program logic and the user information with which other programmers can work seamlessly on the same code in future. There are mainly two methods in VBA to represent comments.

• Any statement that begins with a single quote is treated as comment
• Or you can use statement REM instead of single quotation mark (')

4) In VBA how we can declare variable and constant?

In VBA, variable can be declared with the keyword “DIM” while constant is declared with keyword “Const.”