Course / Class 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
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