This event is now over

Event Details

About

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

     Microsoft Authorized Testing Center Chennai

Contact

Mohamed Rafiq M
99622 33352
info@exceltrainer.in

www.excelspark.in

Schedule

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

Add to your calendar

Venue

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

Map