Excel VBA Macros Training

We organize Corporate Excel VBA Macros Training or workshops in Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune etc.

Key Learning: Automate repetitive tasks | Prepare month-end reports with the click of a button | Automate PowerPoint preparation from Excel reports | User-defined functions (UDF) | Prepare User Forms … and more. For Corporate Enquiry Visit Here

Join our Free Video Course on Excel VBA Macros to get started. 

Introduction to Macros

• The Power of Macros – What can be done with Macros and When to use Macros
• Objects, their functions, methods and properties
• Introduction to Events
• What are events, how & when to use them

Preparing to ‘Macro’

• Visual Basic Editor (VBE) – Developer Tab, Security
• Introduction to the VBE, Project Explorer, Properties window, Password protection of code
• How to use the VBE – Features, Options, Intellisense technology
• Debugging mode
• Inbuilt VBE Help feature – Tips and Tricks.
• How and when to use the inbuilt help features, Object browser
• Common terminology
• Terms like ‘Keywords’, ‘Compile’, ‘Debug’ etc.
• Recording a Macro
• If and when to use Macro recorder along with the code

More On Excel Macros – I

• Structure of an Excel workbook from VBA point of view -Common Objects
• MS Excel Objects like Applications, Workbook, work sheets, etc. Where to write the code?
• Variables and Constants
• What are variables and constants?
• Type of variables; How and when to use variables to store information.
• Typical Variable naming conventions
• When to use Variables or constants

More on Excel Macros – II

• Loops
• For-Next, For-Each, Do-While, Do-Until
• Decision-making and Code Branching
• If-Then-Else, Select-Case, And/Or conditions
• User defined functions (UDF)
• What are user defined functions. How to create & use them.

Getting into the Code

• MsgBox
• Working with Data in Excel
• Data types in Excel worksheets, like Dates, Texts, Nulls etc.
• Working with workbooks, worksheets, ranges, cells etc.
• Using offset and other cell navigation methods.

Power Data Processing

• Working with Data in Excel
• Working with dynamic ranges.
• Protecting worksheets, cells and ranges.
• Working with multiple files. Opening & Saving files

Illustrative Examples.

• Using Google to locate VBA code
• Using Sample Code Snippets – Merging 100s of workbooks in one, Splitting worksheets into multiple workbooks, Creating index of hyperlinks to worksheets.

Learning Prerequisites: Cell/Range Navigation shortcuts; Logical Statements – IF(), AND(), OR(), ISBLANK(), ISNUMBER(); Cell Format – General, Text, Number, Date; Basic formulas – SUM(), AVERAGE(), COUNT(), CONCATENATE(), LEFT(), RIGHT, MID(); Sort & Filter, Basics of Pivot Table

We provide corporate training in Advanced Excel, Powerpoint, Excel VBA Macros across India. You can also check our Corporate client and success stories