TRAINING ON VBA / MACRO In EXCEL

Microsoft Visual Basic for Applications (VBA, Macros) when used with Microsoft Excel can build powerful automated business tools quickly and with minimum cost. VBA, a general purpose programming language, that comes along as standard with the Excel or Office can be used to perform various business tasks like-

•   Automate Report Generation
•   Automate Chart creation
•   Creating dashboards
•   Communicating with business databases
•   Analyzing business data
•   Reconciling data
•   Automating worksheet construction
•   Business model calculations
•   Build professional grade wizards rapidly
•   Build Excel Ad-ins and much more. .

Excel with its vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges combines together to create dashboard driven programs. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have.

Our Training on VBA focuses on using all of these elements to construct powerful data processing and analysis programs in Microsoft Excel.

Advance Excel Training from Excelgoodies

COURSE DURATION: 20 Hrs

Creating Record Macros

• Recording a Macro • Running a Macro • Running a Macro from the Macros Dialog Box • Creating a Short-cut key to run a macro • Running a Macro with a Shortcut key • Assigning a Macro to a Menu or Toolbar • Editing a Macro with Visual Basic

Visual Basic Editor

• Objects • Methods • Properties • Programming Tools • The Menu Bar

The Project Explorer

• Using the Project Explorer

Using Constants

• Excel Constants • Variable Constants

Excel Objects

• Objects, Properties and Methods • Getting & Setting Properties • Calling Methods • Passing Arguments • Singular Objects & Collections of Objects

Using Visual Basic Functions

• InputBox Function • MsgBox Function • Using a Set Statement

Building Formular Control Structures

• If Then Decision Structures • Logical Operators • Select Case Decision Structures • Case Else • Comparison Operators with Select Case Structure • For Loops • Do Loops • While...Wend Statement

Running Code

• Run mode and Design mode • Running Code from the development environment • Running Code from the host application

The Properties Window

• Changing a Property

Variables

• Dimensioning a variable • Using variables in routines • Object Variables

UserForms

• Designing & Creating Forms • Working with Controls • Creating Custom Dialog Boxes • Userform Properties Methods & Events

Event Handling

• VBA Editing & Debugging • Auto Macros • Error Handling

Pricing    

Online Instructor Led Training on Excel - How it works ?

You can listen to our instructor, interact with him on a one-to-one basis, access his computer screen from your desktop, make changes on his excel sheet, and get your doubts clarified instantly.

 

  COURSE FEE  US$ 499

Group Training

Encouraging the live interactions with the trainer as well as the understanding of Excel applications in various domains, Group Training on Advance Excel is scheduled on Weekends (Saturday & Sunday) at our premises.

Batch Size:12

Please call +91 91766 33246 / 91766 33247 for further details.

Individual Training

If you need self spaced training, Excelgoodies provides you with an option of Inividual Training which can be scheduled on any of the weekdays (Monday - Friday) at our premises.

Please Call +91766 33246 for further details.

For Corporate

We offer private hands-on training courses that can be held at your company's site. Our Onsite Corporate Training Packages go beyond the standard excel training and can be tailored according to the needs of the organisation and knowledge level of the employees.

Minimum Batch Size : 10

Click Here to request for quote

For Colleges and Universities

Our Services are now available on demand at Colleges and Universities

Minimum Batch Size : 25

Click Here to request for quote

System Requirements