Course Details

VBA and Macros Training Classes has the below stated areas:

Module 1 - Learn about Programming

Gather knowledge on objectives and start & end points

How to identify solutions and break it into sequential steps?

Concept of writing an algorithm

What is object oriented programming?

Objects, functions, methods and properties of oriented programming

VBA and Macros Training Classes has the below stated areas in our programme:

Module 2 - Details on flowcharts & algorithms

What are flowcharts, processes and flow diagrams?

Introduction to MS Excel Macros

Brush up your skills on when and how to use Macros

Module 3 - A brief description of Events

How & when to use of events?

Using the 'Macro' Visual Basic Editor (VBE)

What are Developer Tabs and Security issues you must know of?

Module 4 - All about VBE

Definition

What is a properties window?

How to use project explorer?

How to ensure password protection of code?

How to use VBE (Features, Options and Intelligence technology)

What is the debugging mode?

What are Bookmarks and Breakpoints?

Importance of watch window, immediate window and locals window

How to make the most of Inbuilt VBE Help Feature - Tips and Tricks?

Get familiar with terms like 'Compile', 'Debug' 'Keywords' etc.

Getting started with Recording Macros - If and when should you use Macro recorder with the code?

Module 5 - Understanding Excel Macros

What is the structure of an Excel workbook from VBA point of view?

Key things to know about MS Excel Objects like Applications, Work sheets, Workbook, etc.

Important Coding platforms you should remember

Module 6 - Concepts related to Variables and Constants