VBA in Excel Certification Training 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.

 

 

Excel VBA Courses (Duration : 16 Hours) Download Course Contents

Live Virtual Classroom 800
Group Training
18 - 19 Oct GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 02 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

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
Module 2: Using Expressions, Variables
  • 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
Module 3: Controlling Program Execution
  • 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
Download Course Contents

Request More Information

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