Enroll for our Excel/VBA training programs for assured perfection in Microsoft Execl/VBA. These training programs will help you in becoming fast and efficient in your day to day Excel related work. The training programs have been designed by people with expertise in Microsoft products. Also the training programs are very economic which suits everyone’s pocket.

Topics Covered

Introduction to VBA Visual Basic Editor Window - Introduction Creating first Macro Running & Assigning Macro Recording a Macro Variables & Operators Types of variables Declaring & using variables Introduction to message box and Input box Excel Objects Excel Objects - hierarchy Accessing objects Referring Ranges\Cells Methods & Properties of objects Basic Range Manipulation Formatting Control Statements If and select statements Loops With Endwith Debugging basics Debug windows Stepping through code Bug reduction tips Procedures Useful excel functions How to use excel functions in VBA Writing procedure in VBA Calling procedure Passing Argumnets Froms & Control Tool bars Usage of forms Using controls Calling other applications & Arrays Opening Powerpoint\Outlook FSO Arrays

Who should attend

Person with any profession

Pre-requisites

Microsoft Excel 2003 onward installed on the system

What you need to bring

Notepad and a Pen. Laptop if you have."

Key Takeaways

Expert in Excel VBA