Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Share

course photo

Excel Macros and VBA Training, Nr. Richmond Road, Bangalore

Richmond Road, Bangalore

8,000

No Reviews Yet
0 Interested

About the Course


Users who use Microsoft Excel in their day to day tasks knows the importance of learning some basic macros to simplify the tasks. This course is targeted to those who would like to use Excel in a smart way.

Course Duration : 16 hours (2 days) on Weekends. Contact us if you are looking for other days.

Batch Size: 10-15

Benefits:

We are Certiport Authorized Testing Center. People who are interested in becoming Microsoft Office Specialist can take up a crash course and take up the Exam to become MOS.

Topics Covered

Difference Between Macros and VBA Programming
Why VBA?
Is VB different from VBA? How?
Understanding Macro Security
Working with Record Macros
Setting Up Digital Certificate for VBA Projects
Understanding Excel Object Model
Edit Macros in VBE
Create Modules
Working with I/P and O/P functions
Working with predefined functions in VBA
Working with Objects, Methods, Events and Properties
Integrating conditions and loops with objects
Executing macros via controls, events, menus/tools etc
Difference between a Template and an Add-in
Creating Macro-enabled Template
Creating Add-in
Debugging the code
Understanding types of errors and error handling techniques

Who should attend

People having good knowledge in Excel, people looking for automation who would want to enhance and speedup the mundane tasks, repeated and manual functions

Pre-requisites

Basic to Intermediate knowledge of Microsoft Excel

What you need to bring

Laptop with MS Office installed

Key Takeaways

Create customized programs to speed up daily routines, Excel Automation, in-depth understanding of functions in VBA and logics to innovate work around.
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Showing 1 to 4 of 4
U

Ramamurthy Gandhi 02/01/2014

Hi,

I would like to persue Macros & SQL via online.

Pls share with me the price, duration and other details if any.

Thanks and regards - Ram

0 0

Answer

You can add upto 6 Images

Vijatiya Training Solutions Llp 29/10/2013

Please contact us for more details, timings and contents can be customized according to your needs.

0 0

Answer

You can add upto 6 Images

U

Nandini 16/10/2013

Need information on this Course about VBA and Macro.

0 0

Answer

You can add upto 6 Images

U

rizwan 09/09/2013

wolud like to learn vba in weekends

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review
cash back100% Money Back Guarentee

About the Trainer

T K Vijayalakshmi

Master of Computer Applications from The Chennai University & Post Graduate in Financial Management from IMT Ghaziabad


I have good experience in relative manner.

Course Id: 4475