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