Pre Requisite:  Attendees must have good knowledge of Excel (any version) specially formatting, function, reference, Pivot etc. 

Duration: This course is scheduled for 3 days.

Target Audience: This comprehensive course will benefit all those who wish to use Visual   Basic for Applications (VBA) to create macros for automating repetitive tasks in Excel.

Course Objective:

Macros automate common and repetitive keystrokes that you use in Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend staring at an electronic spreadsheet each day.

Macro VBA, or Visual Basic for Applications, is the simple programming language that can be used within Excel to develop macros and complex programs. The advantages of which are:

Learning Outcome: After attending the VBA Macro Training course, you will be able to:

• Record and Run Macros Easily using Relative & Absolute Reference.
• Write and edit the VBA Code.   
• Understand the VBA Object Hierarchy.
• Understand the basic programming technique.
• Perform Loops, Controls and Error Handling.
• Create User forms and Sheet Controls.
• Use Events to trigger specific VBA code.

Write useful applications that boost productivity and reduce time on routine activities