Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Tuesday... 01-11-2016
Search Course Here




Live Chat
Support


Excel VBA



overview


VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs.

VBA stands for Visual Basic for Applications an event driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS-Excel, MS-Word and MS-Access.



Ecorptrainings is an excellent Advanced Excel VBA training institute in Hyderabad India. Our course module will enable you to master this very helpful software, and make the process of analysis much quicker to grasp and implement.

prerequisties

  • The delegates must have a good knowledge of Excel.

Duration

Online
  • It is a 8 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 2 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.

course content

  • Visual Basic Editor

    • Visual Basic for Applications
    • Object Programming
    • Event Procedures and Macros
      • Event Procedures
      • Macros
    • Using Help
      • Getting Help in the Object Browser
    • Using the Visual Basic Editor in Excel
    • Saving and Running a Procedure
  • Programming Basics

    • Data Basics
    • Scope of Variables
      • Reserving a Procedure-level Variable
    • Naming Variables
      • Selecting the Appropriate Data Type and Name for a Variable
    • Using Variables to Accept User Input
      • Reserving a Procedure-level String Variable
      • The InputBox Function
      • Concatenating Strings
  • Control Structures

    • Decision Structures
      • Using the If Then Else Statement
      • Nesting If Then Else Statements
    • Using the Selection Structure in Excel
    • Coding the Calculator Procedure
    • The Select Case statement
      • The Select Case Statement
  • Custom Dialog Boxes

    • User Forms
    • Adding a Form
      • The Toolbox
      • Sizing, Moving, Deleting, and Restoring a Control
    • Using the Custom Dialog Boxes in Excel
      • Adding a Form
      • Control Properties
    • The Update Inventory Dialog Box
  • Debugging and Error Handling

    • Errors
    • Automation and Error Trapping
      • Using the GetObject Function
      • Intercepting and Handling Run-time Errors
      • Preventing Multiple Instances of an Application
    • Using Automation and Error Trapping in Excel
      • Modifying the OpenMemo Procedure

Videos

For Videos Click Here Videos
  • excel vba course
  • excel vba course in hyderabad
  • excel vba training course content in ecorp trainings
  • excel vba online training from india

Flash News


AngularJS New Batch Start From 09th OCT & 10th OCT.


Hadoop Dev New Batch Start From 10th OCT & 11th OCT.


IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.


Informatica Dev New Batch Start From 12th OCT & 13th OCT.


Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT
.

Tableau New Batch Start From 16th OCT & 17th OCT

PUBLIC DEMO

(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

(2) SAP MII Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th OCT & 07:00A.M IST on 14th OCT

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings