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

Workday HCM Demo New Batches Starting from Monday... 13-11-2017
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 Starting From 14th NOV & 15th NOV.


Hadoop Dev New Batch Starting From 15th NOV & 16th NOV.


IBM COGNOS TM New Batch Starting From 16th NOV & 17th NOV.


Informatica Dev New Batch Starting From 17th NOV & 18th NOV.


Mean Stack New Batch Starting From 18th NOV & 19th NOV.

SAP BODS new Batch Starting From 19th NOV & 20th NOV.

SAP S/4 HANA New Batch Starting From 20th NOV & 21st NOV
.

Tableau New Batch Starting From 21st NOV & 22nd NOV

PUBLIC DEMO


(1) Workday Technical Demo Training

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

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