Excel VBA Training | Learn Advanced Excel Automation Techniques | ATI

Course Content

Tools and Techniques:

• Books
• Online Courses and Tutorials
• Official Documentation
• Communities and Forums

.

Key Concepts of Excel VBA:

• Macros
• Programming Language
• Object Model
• Event-Driven Programming
• User Forms

Getting Started with Excel VBA:

• Enabling the Developer Tab
• Accessing the VBA Editor
• Writing Code

Learning Path of Excel VBA:

• Basic Syntax
• Understanding Objects
• Event Handling
• User Forms
• Error Handling
• Advanced Topics

Advanced Topics

• Workbook Object
• Worksheet Object
• Range Object
• Cell Object
• Chart Object
• Shape Object
• Application Object
• Workbook Events
• Userform Object
• Userform Object
• Pivot Table Object
• Query Table Object
• Connection Object

Functions in Excel VBA:

• VBA Functions, Part I
• VBA Functions, Part II
• The Split Function
• Date and Time Functions
• More Date and Time Functions
• Excel Worksheet Functions
• Custom Functions

Conditionals in Excel VBA:

• Boolean Expressions
• The If Then Statement
• The ElseIf and Else Statements
• Select Case
• The AND & OR Logical Operators
• Logical Operators
• The NOT Operator

Iteration in Excel VBA:

• The For Next Loop
• The Step Keyword
• Deleting Rows
• Fill Empty Rows
• The For Each-Next Construct
• Iterating over a Range of Cells with For Each
• The With-End With Construct
• Exit For and Review of Exit Sub
• Iteration

Request for Free Demo Lecture

Fees Structure

Fees Structure will be depends on the what type of course you are joining, for example if you are joining for regular batch for 3 month course then fees will be 15000/- if you are joining in group then fees discount will be applicable, for weekend batch fees will be different, For Faculty Development Program and Industrial Training Fees will be different.