VBA Course in Dubai

Visual Basic for Applications (VBA) is an event-driven programming language implemented by Microsoft to develop Office applications. VBA helps to develop automation processes and user-defined functions. It also enables you to manipulate the user interface features of the Excel.

VBA enables you to use English like statements to write instructions for creating various uses. VBA is easy to learn, and it has easy to use User Interface in which you just have to drag and drop the interface controls. It also allows you to enhance Excel functionality by making it behave the way you want. For business use, you can create complete powerful programs powered by excel and VBA. 

What you will Learn?

In this course you will be exposed to use the leverage and the powerful features of excel in your own custom programs. At the end of the course the participant will be an expert in the following features:

Introduction

• Writing Code
• Code Indentation
• Comments
• Switching views

Message Box

• Message boxes
• Input Boxes

Variables and Data Types

• Introduction
• Declaring a Variable
• Declaring Many Variables
• Value Assignment

Adding a Control to a Container

• Control Selection
• Properties of a control

Introduction to Data Types & Variables

• Type Characters
• Value Conversion
• Integer
• Long
• Decimal Variables
• Double Precision
• A String
• A Date
• A Time
• A Variant
• Boolean Values

The Scope or Lifetime of a Variable

• Introduction
• Global Variables
• The Access Level of a Global Variable
• Private Variables
• Public Variables

Operators and Operands

• Introduction
• Dimensioning a Variable
• The Assignment Operator
• The Comma , The Colon Operator : String Concatenation: &

Arithmetic Operators

• Positive Unary Operator: +
• The Negative Operator –
• Multiplication *
• Subtraction –
• Integer Division \

Logical Operators

• And Operator
• OR Operator

Workbooks Fundamentals

• Identifying a Worksheet
• Referring to a Worksheet
• Selecting a Worksheet
• Worksheets Names
• Changing the View of a Worksheet
• Operations on Worksheets

Introduction to Conditional Statements

• Checking Whether a Condition is True/False
• If, Else, Else if

Introduction to loops

• While loops
• For loop
• Do while loop

Introduction to Functions

• Creating a Function
• Returning a Value From a Function
• Calling a Function
• Calling a Function in a Spreadsheet
• Arguments and Parameters
• Calling a function with Argument

Working with Forms

• Creating forms
• Placing Controls
• Form Actions

Database Connectivity

• Introduction to SQL
• Fetching Data from SQL
• Inserting data into SQL
• Updating data in SQL
• Deleting data in SQL

Project

For whom is the course for?

This course is suitable for

• Data analytics.
• Students.
• Administrators.
• Accounting Experts.

Pre-requisites:

• You don’t need any specific knowledge to learn MS Excel, Basic knowledge of computer and basic calculation logic is all you need to get started.