Signup as a Tutor

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

Excel Macro Programming using VBA

12 Reviews

Ghaziabad, Delhi

Course ID: 7266

Ghaziabad, Delhi

Students Interested 0 (Seats Left 0)

12 Reviews

About the Course

Will cover the Excel macro programming using VBA that is required in the Industry. It is a fully practical based training. Beneficial for career oriented people.

Topics Covered

Introduction to Visual Basic

Object Orient Programming concepts and Illustration

Excel Object Model

VBA Data Types

Arithmetic Operators
Comparison Operators
Logical Operators
Concatenation Operator

Basic Excel Operations

Dialogs in VBA screen

Defining Constants

Defining Variables
Defining Global Variables
Defining Static Variables

Working with Functions
Creating Functions using Optional Arguments
Creating Private Functions
Creating Public Functions

Working with Subroutines
Creating Functions using Arguments
Creating Functions using optional Arguments
Creating Private Subroutines
Creating Public Subroutines

Handling errors

Working with Message Box

Decision Statements

Looping Statements

Working with User Forms

Developing different Consolidation Tools using VBA programming

Working with system Registry

Database Connectivity using VBA
Introduction to SQL Server
Making connections in SQL Server through VBA
Concept of Recordset
Retrieving records from database
Updating records to database
Adding records to database
Deleting records from database

Creating Excel based application

Creating Time saving tools

Creating Plug-Ins

Who should attend

MS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments, HR Managers, Students


Understanding of Microsoft Excel

What you need to bring


Key Takeaways

Develops simple-to-complex models for measuring performance using VBA Automation.

Designing and set up new Automated Reporting Systems to monitor the productivity, quality of the employees.

Develop Excel based high quality Applications.

Develop Time saving Utilities.

Date and Time

Not decided yet.

Gallery (5)

About the Trainer

Vivekananda Sinha picture

5 Avg Rating

54 Reviews

57 Students

4 Courses

Vivekananda Sinha

Certified Microsoft Office Specialist

8 Years of Experience

8 Years industrial experience in core MIS.

Trained Executives, Engineers, Managers, Students.

Received MICROSOFT OFFICE SPECIALIST title from Microsoft Corporation.

Awarded several times as Best Trainer at corporate level for receiving excellent feedback for trainings on Advance Excel, Statistical Analysis using Excel, VBA Macros and Microsoft Productivity Tools.

Developed Global Content Repository System, a 20,000 USD project developed in VBA for an IT company in South America. Received excellent customer feedback for the application.

Been as a Project Guide on Construction Site Layout Planning System, a VBA project initiated by group of Civil Engineers of Indian Institute of Technology, New Delhi. This project emphasizes on the planning of different facilities of a site in an optimized way. This is a generic-algorithm based model for site layout planning.

Developed and Implemented Utilities for Excel, a multi functionality tool that helped in saving lots of time for the Excel users. It covers the functionalities such as Sending Mails, Format Cells, Workbook Management, Workbook Library, Text Operations, Arithmetic Operations, Color Themes and Printing.

Developed various Consolidation Tools using VBA that helped in the reduction of 99% of the time taken in manual consolidation of Reports. It proved great at the time of Yearly Baseline Analysis.

Developed and Implemented Awareness Evaluation System, a VBA project to check the skills of the internal employees in different domains. This project includes SQL Server 2005 for storing questions, scores, user information and other details of the application. Login is based on windows Authentication.

Developed a Solution for Human Resource to taken user inputs in email. The data received are automatically saved to central database.

Developed Document Management System Plug-In for Microsoft Excel. This is a VBA Application that facilitates the users, to have documents easily available without wasting their time and efforts in searching them in the drive.

Student Feedback


Average Rating




Sanjeev Pant

This was one of the best training of my life. The mentor Mr. Vivekananda left no place for any doubts in this. The entire training was great with very useful and practical examples that relate to our day to day Reporting activities. I have taken VBA Training from this Institution and learned the subject very well. Sir cleared all our doubts without thinking of any time limitations during our sessions. He has a great knowledge on Excel Analytics. His expertize on the subject made us more confident. I have applied the leanings in my office and its WOW. Thanks to sir for your guidance. I recommend his Institution Future in Hands as one of the best learning place in Delhi.


Anil Kumar Pal

I would rate the institute by five stars, because the excel and VBA training was damn amazing. He makes us everything understand. I would specially thanks vivekananda sir for his valuable guidance and support. I would highly recommend him.


Siddharth Singh

I attended the VBA Training under the guidance of Vivekananda sir and his training changed my life. I got a better position in Amex and lots of appreciation in my office. Earlier I though that VBA could be impossible for me as I dont have any tech background but the way he guided me was awesome and very easy to understand. His examples are very practical and related to our work. Surely, He is a GEM and the best of the best trainer and a wonderful person. I was referred by one of my Friend to join his session and believe me this decision was one of the best decisions of my life. Most of his students are outstanding performer in their company. Thank you Vivek Sir for your exceptional guidance.


Daljeet Singh Rana

Good, Excellent June 2014

Sunil Kumar

Because teaching method of educating is very simple and he has very good experiences in Excel & VBA programming. Any doubt of queries solved in seconds. He is a very good teacher in this world.


Vandana Chauhan

The Teaching method of Vivekanda Sir is so progressive in a very simple and understanding language. I want to say "thank you to Vivek Sir as I got a lot of improvement in my official task by join the MIS classes from UrbanPro.



He is a awesome teacher for all course. I have done Excel & VBA. Good notes, appreciate the way of teaching.



I would like to share my experience with vivek sir, As a teacher, his concept about course is very much immpresive. Assignment are very much helpful to learn the course in easy way. tough question has resolved with in a minute. he knows how to manages 10 -50 peoples in a group in classroom. his video programmes were very much impresive and help ful for each student. and i think most of the students has got a new jobs after attending his classes. thats not enough about vivek sir, i just want to say thank you vivek sir, for those times which i have spent with u in classes. regards vasu saini


Mohit Sharma

Vivekanand Sir, Who always helps Students to get the knowledge and always stands beside the students when they have problems. He's not only teacher he's a good friend, philosopher and guide. he's made a good platform to our bright future


Gaurav Tyagi

Mr. Vivekananda has been tutoring me from last two months. I was scared by the name of VBA before I met him but in last couple of months under his guidence and my hardwork I have been making very complex VBA programming applications. He is a very good teacher and a better human being. He is an optimistic person not just for himself but for the students too. He motivates and drives trainees to excel in whatever training he is providing. He is surely a master at what he does. I'm really glad that I joined his initiative "Future in Hands" and now I'm enjoying my fruitful career, all thanks to him. Thank You Sir


Anant Jain

The method of teaching is excellent. Very supportive and helpful in teaching. Its a great experience to learn from Vivekananda S.

Shivkant Pathak

Vivekananda is an excellent knowledge of MS Office tools. His way of teaching is excellent as he have the experience of IT industry.

Discussions (1)

Students Interested 0 (Seats Left 0)

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


Submit your enquiry for Excel Macro Programming using VBA

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Vivekananda

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more