script> (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) })(window,document,'script','https://www.google-analytics.com/analytics.js','ga'); ga('create', 'UA-85989171-1', 'auto'); ga('send', 'pageview');

Quick Enquiry

Who Should Attend?

Manager, Supervisor, Administrator, Personal Assistant, Assistant Departments, Secretary and those who are interested in achieving data automation using Excel VBA.

Why should attend?

Using a step-by-step approach, this course shows how the VBA programming language can extend the functionality of Excel.

What is The Output?

Hands-on, practical experience to solve the most popular problems. Fulfilling your potential and realising your career ambitions. Upon completion of the course, you will have a good understanding of the major components of VBA. You will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.

Course Details

Module 1

Introduction to Visual Basic

Module 2

Building the Visual Basic Application

Module 3

Working With Controls

Module 4

Writing the Codes

Module 5

Visual Basic Data

Module 6

Managing Visual Basic Data

Module 7

Controlling Program Flow-1

Module 8

Controlling Program Flow-2

Module 9

Looping Part-1

Module 10

Looping Part-1

Module 11

Visual Basic Funtion-3(Formating Output)

Module 12

Manipulating Strings

Module 13

Creating Your Own Functions

Module 14

Arrays-1

Module 15

Two Dimensional Arrays

Module 16

Graphics

Module 17

Working With Files

Module 18

Creating Basic Database Applications In VB

Module 19

ADOCONTROL

Register For Demo Seat

Other Courses We Offer

Our Class Room Training

Our Online Training

Our Certifications & Accrediation

Our Testimonials

I learnt many things & improved a lot after joining here.
Pushpalatha

Classes were really nice. I liked it very much.
Muzammil

My Experience was very good & comfortable. What ever doubts I get I asked my faculty, he clarified all my doubts. This helped me to improve my confidence to learn
Deepak Kumar P

I feel very confident to talk with any person now. I have learnt many things after coming here.
Kishore

No Suggestion to give, actually you people made me so comfortable with learning & speaking in English. Thanks, Zonal Tech Solution & Rajiv Sir.
Lavanya

Worth of taking training before joining I was thinking how the class would be but really what they committed while counselling they have given very good training.
Lakshman