Name: Aptech Learning Gariahat
Address: Lake Gardens, Kolkata, Lake Gardens, Kolkata, 700029
Telephone: 011-40117076

Best VBA Macros Training Institutes in Egra as on May 03, 2024

NIIT Haldia Centre

Khanjan Chowk, HALDIA, 721606

( Also serves in Egra )

VBA Macros Training, Engineering and technician job training, Banking

+59 more

Distance: 61.16 Kms

Enquire Now

SHYAMALI ENTERPRISE

Kriparampur, South 24 Parganas, 743398

( Also serves in Egra )

VBA Macros Training, Online Services, Engineering and technician job training

+5 more

Distance: 91.79 Kms

Enquire Now

NIIT Kolkata Behala Centre

Behala, KOLKATA, 700034

( Also serves in Egra )

VBA Macros Training, Engineering and technician job training, Banking

+59 more

Distance: 103.15 Kms

Enquire Now

G-Tec Computer Education New Alipore

New Alipore, Kolkata, 700053

( Also serves in Egra )

VBA Macros Training, Banking, Finance & GST job training

+21 more

Distance: 105.89 KmsSulekha score: 4.8Working hours: 10 AM to 7 PM

Enquire Now

TCS iON Training Partner

Garia, Kolkata, 700084

( Also serves in Egra )

VBA Macros Training, Database administrator training, Business productivity tools training

+34 more

Distance: 106.83 KmsSulekha score: 5.7Working hours: 9:30 AM to 7 PM

Enquire Now

NIIT Kolkata Garia Centre

Garia, Kolkata, 700084

( Also serves in Egra )

VBA Macros Training, Engineering and technician job training, Banking

+59 more

Distance: 106.9 Kms

Enquire Now

Palium Skills

Jodhpur Park, Kolkata, 700068

( Also serves in Egra )

VBA Macros Training, Professional development training, People skills training

+22 more

Distance: 107.98 KmsWorking hours: 9:30 AM to 6:30 PM

Enquire Now

NIIT Kolkata Hazra Centre

Kalighat, KOLKATA, 700026

( Also serves in Egra )

VBA Macros Training, Engineering and technician job training, Banking

+59 more

Distance: 108.01 Kms

Enquire Now

NIIT Kolkata Jadavpur Centre

Jadavpur, KOLKATA, 700032

( Also serves in Egra )

3.0/5 Based on 2 reviews

VBA Macros Training, Engineering and technician job training, Banking

+59 more

Distance: 108.17 Kms

Arnab from KOLKATA

"Hi DJ Arin here, any party djing sound light etc service done..."

Enquire Now

Aptech Learning Gariahat

Lake Gardens, Kolkata, 700029

( Also serves in Egra )

5.0/5 Based on 26 reviews

011-40117076

VBA Macros Training, Banking, Finance & GST job training

+25 more

Response Time: More than 60 MinsDistance: 108.35 KmsSulekha score: 7.2

Aptech is a global education and training company headquartered in Mumbai, India. The company has 863 centres in India and 1,300 centres across 43 countries across Africa, West Asia, South America, Russia and South East Asia through a franchise model. less

Enquire Now

This training VBA macros will help candidates with all the essential skills required to handle the VBA environment, creating dashboards, using VBA macro applications and understanding other advanced topics associated to it. This course is structured and by the end of it, candidates will become aware of all necessary skills required to use macros in VBA.

Course Contents

Introduction

Introduction to macros
Introduction to Visual basic editor
Modules
Macros

Macro Code

Macro architecture
Running macros from VBA
Utilities for running a macro

Visual Basic Editor

Objects and methods
Properties
Programming tools
Using the menu bar

VBA Syntax

Objects
Properties and methods
Understanding parameters
Object browser
Object hierarchy
Tools for coding
Moving to other cells
Editing specific cells
Immediate Window
Control through immediate window
Formatting cells
Using variables and constants
Object variables
Dimensioning
Displaying data
If and nested If statements
Select case statements

Functions with VBA

Functions and optional arguments
Pass by value
Pass by reference
Creating custom functions
Loops and their variation
Do while and do until loops
Using loops For loop
Next loop

Variables

Introduction to variables
Creating variables
Setting variables
Explicit variables
Implicit variables

Advanced Techniques

Excel utilities with VBA
Error Handling
Using built-in excel features
Pivot tables and charts
Importance of excel events
Interaction with other applications
Add Ins

App development

Working with Ribbon and shortcut menus
Support for applications
Development of user oriented apps

Connecting to Database and Outlook

Connecting to MS access and outlook using VBA
Retrieve data from MS access
Modifying DB
Filter DB using Query
Query data grouping, retrieve mail and CC address
Retrieve mail subject and attachment

IT Training Courses

IT Administration & Architecture Training

3500+ Verified Institutes

Know More

Programming Languages Training

5100+ Verified Institutes

Know More

IT Projects Training

3000+ Verified Institutes

Know More

Project Management Certification Training

3500+ Verified Institutes

Know More

Quality Management Training

4300+ Verified Institutes

Know More

Telecom and Datacom Training

5000+ Verified Institutes

Know More

Oracle Training

7000+ Verified Institutes

Know More

SAP Training

9000+ Verified Institutes

Know More

Web Technologies Training

12000+ Verified Institutes

Know More

Cyber Security Training

7000+ Verified Institutes

Know More

Why Sulekha

Sulekha is India's most efficient and affordable premier listing service. When you choose Sulekha, you get the best offers available in the market and negotiate your terms with the top service providers. Our professionals guarantee 100% customer satisfaction while delivering the service on-time.

45+ M

Happy Customers

4+ M

Verified Experts

1000+

Cities Served

200+

VBA Macros Training in Egra

For which of these do you require training?

Best VBA Macros Training Institutes in Egra as on May 03, 2024

NIIT Haldia Centre

SHYAMALI ENTERPRISE

NIIT Kolkata Behala Centre

G-Tec Computer Education New Alipore

TCS iON Training Partner

NIIT Kolkata Garia Centre

Palium Skills

NIIT Kolkata Hazra Centre

NIIT Kolkata Jadavpur Centre

Aptech Learning Gariahat

Course Contents

IT Training Courses

Why Sulekha