Learn Microsoft Excel Training from the Best Tutors
Search in
I have got over ten years in customer service. Currently working as a team leader in an MLM company. Will doing VBA course help me get a better package I am having CTC of 7 lakhs hoping to touch 8 to 9 lakhs CTC.
Asked by Francis Last Modified
As you are a Team Leader, Learning VBA is not going to help you. You just need Basic Excel Knowledge to manage your team.
VBA is for programmers who need to develop softwares.
Learning VBA is like - How you learned Bi-cycle. You will learn it, but it would take you an year to master it. You need immediate returns of your invested time, to make more money, and should not waste your another 3-6 months.
read lessIf you want true answer read below:
Firstly, Excel and VBA directly has no relation. VB (Visual Basic) is a separate programming language like other languages Java, .Net, C++ etc. Visual Basic for Application (VBA) is used as support to all Microsoft Office applications in form of Macros.
So, VBA macro is nothing but that component of Visual Basic which does certain tasks alowng with Microsoft office applications which helps in some automations. People have misconcept that for automation VBA is required. It's INCORRECT.
Excel is application full of logic through it's formulae and functions. So, automation can be done using formulae only even better than VBA. Just by putting input, you can get output if your solution model is perfect. There is no need to run any macro. Further, disadvantage of macro is that one should learn VB first and editing is not simple for person who has not learned VB. Also modification in existing VBA code is not that simple unless you know thoughtprocess of coder.
So, logic is most important. If you have it clear, you will creat path to reach solution and excel functions are powerful enough to help you doing that. VBA or excel functions are not going to help you with logic.
To conclude, make your logic clear first and learn excel functions. If you are good with those, then only jump for VBA coding.
read lessHarish S
Microsoft Certified Professional with 12 years of experience in Data Analysis and Report Automation
View 3 more Answers
Related Questions
What is use of VBA? Can you explain it?
Suppose our Customer requires following:
An Excel Software for POS, with following functionalities:
Can you make that?
How much time will it take to you to make it completely?
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRecommended Articles
Why Should you Learn Microsoft Office
Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...
Read full article >
What is Applications Engineering all about?
Applications engineering is a hot trend in the current IT market. An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...
Read full article >
Make a Career in Mobile Application Programming
Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...
Read full article >
Learn Hadoop and Big Data
Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...
Read full article >
Looking for Microsoft Excel Training classes?
Learn from the Best Tutors on UrbanPro
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near youThe best tutors for Microsoft Excel Training Classes are on UrbanPro
The best Tutors for Microsoft Excel Training Classes are on UrbanPro