Excel VBA Macro Training in Chennai

Excel VBA - Course Outline

This 2 day Excel VBA course is suitable for advanced users of Microsoft Excel responsible for very large and variable amounts of data, or teams, who want to automate routine activities in Excel based on their requirements.

Prerequisites
Good proficiency in Microsoft Excel is required, or completion of our 2 day Advanced MS Excel course.

Benefits
At the end of the course the delegate will have ability to automate their Excel based Work in Macros.

List of Topics:

Object-Properties-Methods, Control Structures, Editing Macros, Event Handling, Controls/ VBA Forms, Functions.

Visual Basic Editor, Editing Macros, Msgbox, Inputbox, Application.Inputbox, AssigningMacros to Buttons/Objects, Objects Properties and Methods, Variables, Using Basic Functions, Control Structures, If…Then Decision Structures, Select Case, Logical Operators, Loops - Do Until; For; For each, Workbooks and Sheets, User-Defined Functions, Creating Another Function, Creating and Using A User-Defined Function, Event Handling, Vba Editing & Debugging, Auto Macros, Error Handling, Controls/Vba Forms

Exce Spark is the Authorised Testing Center to conduct Microsoft Office Specialist (MOS) Exam

Contact:

Mohamed Rafiq M
+91 99622 33352
info@exceltrainer.in