UrbanPro
true

Excel Macro Programming using VBA

LIVE
37 reviews
Ongoing

Course offered by Vivekananda Sinha

56 reviews

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 (48)

+41 more

About the Trainer

Vivekananda Sinha picture

5 Avg Rating

56 Reviews

68 Students

9 Courses

Vivekananda Sinha

Certified Microsoft Office Specialist

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

Students also enrolled in these courses

LIVE
3 reviews
40 Hours

Course offered by ACLM Institute

3 reviews

Reviews (37)

5 out of 5 37 reviews

Vivekananda Sinha https://p.urbanpro.com/tv-prod/member/photo/200765-small.png Vasundhara
5.00537
Vivekananda Sinha
M

Excel Macro Programming using VBA

"I recently cracked my IJP after upgrading myself to VBA Programming. I joined Vivek sir 5 months back. The in-depth course content with the expertise of Vivek sir was a great combination. He has a great variety of industry examples. He is really a great mentor. His students are star performer. I am lucky to attached with him. He is truly the best trainer around. I enrolled for the next level. "

Vivekananda Sinha
S

Industry Level MIS Training

"Vivekananda Sir is a person with whom you can achieve yours big dreams and got depth knowledge" I had known about Mr. Vivek Sir from year-2014 by my friend Depak. We both are working in same company "Data Flow" and searching MIS training Institute but they had joined to Vivekananda Sir, but that time i was making my career in Web Designing but till now i am also part of crowd with low salary but my friend is now working with good company on high salary, Then will decided to change my career career path. I have decided to join Sir. Sir enrolled me in MIS batch on February-2017. I had joined as I had trust on Vivek Sir that he will be supporting me in any way. I did not know about Excel. I feared but he gave me friendly environment. I really appreciate that you are always so friendly and supportive in all way. I feel free and comfortable to talk to you. I really appreciate your teaching ways. Learning from you are very enjoyable. Your explanation way is very unique. I have also enrolled for other sessions conducted by him. "

Vivekananda Sinha
V

Industry Level MIS Training

"Vivek sir you are the only one who made me crack that interview. You are our hero. You are the only one who is behind my success. Like me there are a lot more students who really can't express how much thankful we are that our paths cross with future in Hands. I never ever expected that I can also get success in my career. I started my career with calling profile and yet I was tele caller. Now I just can't express my happiness. I am Thankful to you. Advice or suggestion for everyone also keep improving your skills. That's what I did followed Vivek sir guidelines. With Excel and VBA Programming, I learnt Advance Dashboard, Power Point. And now already enrolled for the upcoming Brainstorming Microsoft Excel session. Some of you think that all of these courses are not possible but it is. Instead of watching television, I watched those videos. And now more exited to get my self enrolled for more courses. I will always be thankful to Future in Hands Institute. \"

Vivekananda Sinha
S

Excel Macro Programming using VBA

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

View All
Have you attended any class with Aclm Institute Of Professional...?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 37 reviews

Vivekananda Sinha https://p.urbanpro.com/tv-prod/member/photo/200765-small.png Vasundhara
5.00537
Vivekananda Sinha
M

Excel Macro Programming using VBA

"I recently cracked my IJP after upgrading myself to VBA Programming. I joined Vivek sir 5 months back. The in-depth course content with the expertise of Vivek sir was a great combination. He has a great variety of industry examples. He is really a great mentor. His students are star performer. I am lucky to attached with him. He is truly the best trainer around. I enrolled for the next level. "

Vivekananda Sinha
S

Industry Level MIS Training

"Vivekananda Sir is a person with whom you can achieve yours big dreams and got depth knowledge" I had known about Mr. Vivek Sir from year-2014 by my friend Depak. We both are working in same company "Data Flow" and searching MIS training Institute but they had joined to Vivekananda Sir, but that time i was making my career in Web Designing but till now i am also part of crowd with low salary but my friend is now working with good company on high salary, Then will decided to change my career career path. I have decided to join Sir. Sir enrolled me in MIS batch on February-2017. I had joined as I had trust on Vivek Sir that he will be supporting me in any way. I did not know about Excel. I feared but he gave me friendly environment. I really appreciate that you are always so friendly and supportive in all way. I feel free and comfortable to talk to you. I really appreciate your teaching ways. Learning from you are very enjoyable. Your explanation way is very unique. I have also enrolled for other sessions conducted by him. "

Vivekananda Sinha
V

Industry Level MIS Training

"Vivek sir you are the only one who made me crack that interview. You are our hero. You are the only one who is behind my success. Like me there are a lot more students who really can't express how much thankful we are that our paths cross with future in Hands. I never ever expected that I can also get success in my career. I started my career with calling profile and yet I was tele caller. Now I just can't express my happiness. I am Thankful to you. Advice or suggestion for everyone also keep improving your skills. That's what I did followed Vivek sir guidelines. With Excel and VBA Programming, I learnt Advance Dashboard, Power Point. And now already enrolled for the upcoming Brainstorming Microsoft Excel session. Some of you think that all of these courses are not possible but it is. Instead of watching television, I watched those videos. And now more exited to get my self enrolled for more courses. I will always be thankful to Future in Hands Institute. \"

Vivekananda Sinha
S

Excel Macro Programming using VBA

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

Vivekananda Sinha
A

Excel Macro Programming using VBA

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

Vivekananda Sinha
S

Excel Macro Programming using VBA

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

Vivekananda Sinha
P

Industry Level MIS Training

"It’s a pleasure in writing and sharing my success story as there has been many hiccups in my career starting from the day I stepped into this corporate world and later on some great learning experience with a supportive hand from my Mentor Vivek Sir who has guided me into a right direction. It all started when I wanted a spark in my career as I switched my job profile from Call Centre Executive to a MIS Executive. Initially I took help from Google and YouTube and learnt certain basic fundamentals of Excel and its uses. However I knew that things were not going the way I wanted as I joined my current company Virtual Employee as Administrative Assistant which required a great knowledge of Microsoft Excel, Microsoft Word and other corporate learning. Then I came to know about Future in Hands and the best trainer (Vivekananda Sinha) in NCR from Ankit Saxena, one of the alumni of FIH who himself has a great success story and that influenced me to join FIH and Vivek Sir. Thus, after a successful training sessions on Advance Excel, I enrolled and completed Productivity Enhancement session, Dashboards, Excel Power Tools (best in class), VBA and SQL training. All this resulted in direct positive impact on my career and get promoted as Business Analyst and now as Sr. Business Analyst II within three years of completion. I’ll always be thankful to Vivek Sir for being a great mentor, soft spoken, disciplined and passing the zeal of never stop learning new things in life. "

Vivekananda Sinha
R

Industry Level MIS Training

"The training i attended was the best training of my life. So much of practical exposure I never had. I gain confident on Analytical skills. The best part of the training is the Brainstorming Microsoft Excel Tool that covers 100+ very very complex interview question which is not provided by any training institutes. The recommend Mr. Vivekananda the best Mentor for Reporting & Analysis and the Future in Hands the best center for future growth. Thanks for everything, I learnt from here. "

Vivekananda Sinha
D

Excel Macro Programming using VBA

"Good, Excellent June 2014 "

Vivekananda Sinha
L

Industry Level MIS Training

"It was a great experience with FIH. Vivekananda Sir is one of the best faculty in Delhi for VBA, Excel, SQL and SAS. I learnt VBA and EXCEL from this institution and got a higher position in Accenture. Thanks to Vivek Sir for his unique way of teaching that helped in building my career. "

Vivekananda Sinha
S

Industry Level MIS Training

"Words cannot express Enormity of Mr. Vivek. He is one of the best Teacher/instructor or career path maker with his well-informed Teaching about excel/VBA & All I ever had. I would recommend FIH for best Learning Centre in Delhi-NCR. Today whatever I have got because of him, which I never thought in my Dreams as well. From bottom to top. "

Vivekananda Sinha
S

Industry Level MIS Training

"Here I am speechless to say about my best teacher of my life. I studied many institutions like NIIT and other institutions for technical knowledge, but the knowledge, the path, the guidance I obtained by Vivek Sir; I do not say “Future in Hands” is an Institution. Actually FIH is an NGO where peoples do not need to worry about their future. I was nothing when I joined FIH. But now I am something. And if I am something, the complete credit goes to Vivek Sir. Only due to Vivek Sir I am in Airtel. Thanks Sir. Thanks FIH. Will be grateful to you. "

Vivekananda Sinha
S

Industry Level MIS Training

"Here I am speechless to say about my best teacher of my life. I studied many institutions like NIIT and other institutions for technical knowledge, but the knowledge, the path, the guidance I obtained by Vivek Sir; I do not say “Future in Hands” is an Institution. Actually FIH is an NGO where peoples do not need to worry about their future. I was nothing when I joined FIH. But now I am something. And if I am something, the complete credit goes to Vivek Sir. Only due to Vivek Sir I am in Airtel. Thanks Sir. Thanks FIH. Will be grateful to you. "

Vivekananda Sinha
S

Excel Macro Programming using VBA

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

Vivekananda Sinha
U

Industry Level MIS Training

"I am surprised, having seen Mr. Vivekananda Sinha because his art of teaching can not be defined. I am so satisfied by joining him. Before join him, I went in several institute but I could not find out such an art of teaching. I want to say something about Mr. Vivekananda Sinha, "He not only delivers the best quality but also he helps all the students for making the best career" So, I am really very grateful of Mr. Vivekananda Sinha for giving the best quality as well as the best career. Thanks a lot to Mr. Vivekananda Sinha. "

Vivekananda Sinha
R

Industry Level MIS Training

"Mr. Vivekananda Sinha is an awesome trainer in Delhi NCR. The pedagogy of Mr. Vivekananda Sinha is outstanding and he caters the best career. His motive is not provided a job, his motive is provided a career. I am really very thankful of Mr. Vivekananda Sinha for giving me the best career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart. "

Vivekananda Sinha
B

Industry Level MIS Training

"I have no word to explain to Mr. Vivekananda Sinha. He is an outstanding trainer in Delhe NCR. "Just as a drop of water helps to live at the time of thirst, in the same way Mr. Vivekananda Sinha helps us in making of wonderful career at the time of spread career." His motive is not provided a job, his motive is provided a career. I am really very thankful of Mr. Vivekananda Sinha for giving me the best career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart. "

Vivekananda Sinha
B

Industry Level MIS Training

"I have no word to explain to Mr. Vivekananda Sinha. He is an outstanding trainer in Delhe NCR. "Just as a drop of water helps to live at the time of thirst, in the same way Mr. Vivekananda Sinha helps us in making of wonderful career at the time of spread career." His motive is not provided a job, his motive is provided a career. I am really very thankful of Mr. Vivekananda Sinha for giving me the best career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart. "

Vivekananda Sinha
V

Excel Macro Programming using VBA

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

Vivekananda Sinha
B

Industry Level MIS Training

"I have no word to explain Mr. Vivekananda Sinha. He is Outstanding Trainer in Delhi NCR. "Just as a drop of water is necessary to live at the time of thirst, in the same way he always helps his students at the time of their tough hours" His motive is not provided a good job, his motive is provided a good career. Thanks a lot to Mr. Vivekananda Sinha from core of my heart to light the career of my spread life. "

Vivekananda Sinha
S

Excel Macro Programming using VBA

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

Vivekananda Sinha
A

Industry Level MIS Training

"Vivek Sir is one of the best trainer in NCR. "

Vivekananda Sinha
V

Excel Macro Programming using VBA

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

Vivekananda Sinha
A

Industry Level MIS Training

"Sir is so helpful, always try to motivate you and always ready to help you in any condition. thank u sir that i gain so much from future in hands. "

Vivekananda Sinha
S

Industry Level MIS Training

"This is an amazing class. I def was not expecting the instructor, Sir, to be so awesome. He is super well versed with Excel, a fantastic teacher. we learned awesome tips and techniques about how to most efficiently use Excel. It's amazing how much time many of us waste doing things manually. I never realized how simple it is to use the methods/shortcuts that vivek sir teaches.Vivek sir's style of teaching is to keep drilling a concept over and over until it sticks. He is a very good teacher and technical mentor for excel and vba programming,his class tutorial is well organised to understand basics as well as advance excel and vba programming.Every class we are getting the video of tutorial which helps later to understand the missing things.The most important thing is that we can clear our doubts any time at cell phone or chatting. I am very happy to took this class. Compared to what else is out there..... "

Vivekananda Sinha
A

Industry Level MIS Training

"The way he teach is best amongst all and he have all the good qualities and skills needed in a trainer. He focus on every individual student and clear every doubts. So far I can say he is master on excel and vba. I highly recommend him as trainer for all the courses he is providing and can guarantee that after course you will post same things as I did for him. "

Vivekananda Sinha
M

Excel Macro Programming using VBA

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

Vivekananda Sinha
D

Industry Level MIS Training

"really feeling honoured while giving recommendation , as vivek sir....the way u teach and approach every student queries quiet majestic and brilliant.The main highlight of the session are tricky assignments that you used to give after every class and believe me it takes a toll to do those brain storming assignments. "

Vivekananda Sinha
M

Industry Level MIS Training

"He is awesome in Excel & VBA with a simple and the best teaching method. He is the only person who made me to believe MIS is an awesome profile to choose. "

Vivekananda Sinha
G

Excel Macro Programming using VBA

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

Vivekananda Sinha
R

Industry Level MIS Training

"thanks to you sir......for so much of learning. guys if you are looking for specialized training and expertising excels and VBA skills then this would be the end of your search. vivek sir , provides all study materials with tricky assignments. the best part of his sessions are personalised attention to each and every student as the batch size is very small with reasonable fees structure that too in installments."

Vivekananda Sinha
D

Industry Level MIS Training

"According to me, this is right place to get the knowledge about excel/ VBA /others. And as concerned about Teacher," explain each & every point very clear". Thanks to Vivekanand !!"

Vivekananda Sinha
A

Excel Macro Programming using VBA

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

Vivekananda Sinha
S

Excel Macro Programming using VBA

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

Vivekananda Sinha
A

Industry Level MIS Training

"Hello Sir, It was pleaasure being your student and having your guidance on MIS. This was really beneficial training for me, now i have been able to analyze data from various angle and can make dashboards. It has saved my effort at large by scrapping manual effort by using formulaes. I would also request you to please start classes for complete MS-Office package."

Vivekananda Sinha
V

Mastering Microsoft Excel - New Year Offer

"One day Training session on Expertising Excel is a great learning experience. This training is beneficial for all those who are working in corporates. I attended this training and learnt many things that can be used in our routine tasks. Waiting for VBA Session to commnece."

Vivekananda Sinha
V

Industry Level MIS Training

"Consummate skills of trainer make tough things very easy. Trainer covers all part of excel from root level to complex level like macros and decision enabling data analysis tools. Fee is affordable too.I must recommend everyone to go and learn excel in a way you never knew before."

Have you attended any class with Aclm Institute Of Professional...?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Excel Macro Programming using VBA by Vivekananda Sinha

Vivekananda Sinha picture
LIVE
(37 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Excel Macro Programming using VBA by Vivekananda Sinha

Vivekananda Sinha picture
LIVE
(37 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. 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