1. Professional can learn this course

2. Expert level vba scripting practical training.

3. Carry laptop, but not mandatory

BASIC

• Fundamental
• Use of VBA
• What is Macro
• Displaying the Developer Tab
• Managing the Macro Security Problem
• Recording a Macro
• Running Macro
• Editing Macro
• Running Macro from a Button on the Quick Access Toolbar
• Create a Macro
• Excel Macro Recorder
• Macro Security
• Visual Basic Editor
• Macro Comments
• Message box
• Input box
• Errors Handling
• Debug Macros
• Objects Properties and Methods
• Classes and Modules
• Rows, Columns, Cells
• Workbook and Worksheet
• Application Object
• Range Object
• Connection String

CONTROLS (ActiveX Controls and Form Controls)

• Textbox
• Label
• List box
• Combo box
• Checkbox
• Option Buttons
• Spin Button
• Ref Edit Box
• Frame
• User form
• Command Button

PROGRAMMING

• Variables and Data Type
• Array and Data Type
• Use special character for data type
• Option Explicit
• Option Base
• String Manipulation
• Arguments & Parameters
• Calculation
• Operators and Operands
• AND
• OR
• Looping (Do, Do While, Do Until, FOR)
• Logical Operators
• If Then End if Statement
• If Then Else End if Statement
• Select Case End Select
• Events
• Date and Time
• Function and Subroutine
• Call macro in another macro
• Create User Defined Function
• Creating Macro for conditional formatting
• Data import into controls
• Data export from controls
• Using Controls on Worksheet
• Using Controls on Form

PROJECTS

Question and Answer

Note:-  Topics  are covered with example of vba coding. 80% practical and 20 theoretical training.