Signup as a Tutor

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

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

No Reviews Yet

Richmond Road, Bangalore

Course ID: 4475

Richmond Road, Bangalore

No Reviews Yet

Date and Time

Not decided yet.

T K Vijayalakshmi

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

About T K Vijayalakshmi

I have good experience in relative manner.
No reviews currently Be the First to Review

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.

Reviews

No reviews currently Be the First to Review

Discussions (1)

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now