This event is now over

Event Details


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.

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

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


Mohamed Rafiq M
+91 99622 33352

     Microsoft Authorized Testing Center Chennai


Mohamed Rafiq M
99622 33352


June 24, 2017 — 9:30 am to
June 25, 2017 — 5:30 pm

Add to your calendar


Excel Spark
No: 109, Chowdri Nagar Main Road,
Chennai, Tamilnadu