VBA in Excel Course Overview

VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word and MS-Access. This tutorial teaches the basics of VBA. Each of the sections contain related topics with simple and useful examples.

Audience :

This reference has been prepared for the beginners to help them understand the basics of VBA. This tutorial will provide enough understanding on VBA from where you can take yourself to a higher level of expertise.

 

 

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Working with Procedures and Functions
  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedure
  • Using the Immediate Window to Call Procedures
  • Creating a Functions Procedure
  • Naming Procedures
  • Working with the code Editor
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variables Scope
  • Understanding Constants
  • Using Message Boxes
  • Using Input Boxes
  • Declaring and Using Object Variables
  • Understanding Control-of-Flow Structures
  • Working with Boolean Expressions
  • Using the If… End If Decision Structures
  • Using the Select Case… End Select Structure
  • Using the Do….Loop Structure
  • Using the For…To…Next Structure
  • Using the For Each….Next Structure
  • Guidelines for use of control-of-Flow Structure
Live Online Training (Duration : 16 Hours)
Group Training 750 Per Participant
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 1500 1000 + If you accept merging of other students.
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours for only USD 2,000

Course Prerequisites
  • Before proceeding with this tutorial, you should install MS Office, particularly MS-Excel.

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
The Fee includes:
  • Courseware
Yes, Koenig Solutions is a Microsoft Learning Partner