loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Excel Macro Programming using VBA

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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 support@urbanpro.com 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 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

Share

Excel Macro Programming using VBA

Excel Macro Programming using VBA

Ghaziabad, Delhi

4,000

12 Reviews
0 Interested

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

Operators
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

Pre-requisites

Understanding of Microsoft Excel

What you need to bring

Notebook
Pen

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.
Gallery
Reviews

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. "

attended Excel Macro Programming using VBA


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. "

attended Excel Macro Programming using VBA


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. "

attended Excel Macro Programming using VBA


Questions and Comments

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

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 10 of 13
U

26/05/2014

I want someone who can make macros in Excel

0 0

Answer

You can add upto 6 Images

U

14/05/2014

MIS

0 0

Answer

You can add upto 6 Images

U

13/05/2014

Please let me know the timing, contact no & exact location

0 0

Answer

You can add upto 6 Images

U

05/04/2014

Hi
I am interested in this course, Please confirm your location and contact no.

0 0

Answer

You can add upto 6 Images

U

03/04/2014

Hi vivekanada Good to see you you can directly mail me regarding excel vba

0 0

Answer

You can add upto 6 Images

U

02/04/2014

hi i am intrested in VBA excel and Acess and Advanece Excel .Pls tell m fee.

0 0

Answer

You can add upto 6 Images

Vivekananda 19/02/2014

Dear Margaux, Saurabh. Please call me so that i can guide you through the details.

0 0

Answer

You can add upto 6 Images

U

19/02/2014

Dear Sir,

I would like to improve my skills in Excel especially in VBA.Please, I would like to know how many hours are included in the Excel Macro Programming using VBA at 3 000/- and in the Basic Excel classes at 4 000/-? I work in Finance, so I would like to know if these classes are adapted for a Finance profile?

0 0

Answer

You can add upto 6 Images

U

13/02/2014

Hi I am working on VBA and advance MS excel,dashboard if anyone need to automate macro of manual reports contact me I ll writing macros for you :)

0 0

Answer

You can add upto 6 Images

U

09/07/2013

I am intrested in this training.

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

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. "

attended Excel Macro Programming using VBA


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. "

attended Excel Macro Programming using VBA


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. "

attended Excel Macro Programming using VBA


Daljeet Singh Rana

"Good, Excellent June 2014 "

attended Excel Macro Programming using VBA


Sunil Mahour

"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. "

attended Excel Macro Programming using VBA


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. "

attended Excel Macro Programming using VBA


Sweety

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

attended Excel Macro Programming using VBA


Vasu

"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 "

attended Excel Macro Programming using VBA


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"

attended Excel Macro Programming using VBA


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"

attended Excel Macro Programming using VBA


Anant Jain

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

attended Excel Macro Programming using VBA


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. "

attended Excel Macro Programming using VBA


Date and Time

Not decided yet.

About the Trainer

Vivekananda Sinha picture

Vivekananda Sinha

Certified Microsoft Office Specialist


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.
Seats Left-

Students Interested 0

Course Id: 7266