UrbanPro

Location Set your Location

Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

Microsoft Excel > Learn Microsoft Excel Training > Is it necessary to have the knowledge of VB script...
✕

Search in

Is it necessary to have the knowledge of VB script for Excel Macro Training?

Asked by Last Modified  

40 Answers

Learn Microsoft Excel Training

Follow 2
Answer

Please enter your answer

Graphic / Web / CAD Freelance Designer and Faculty

Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more. The knowledge of Excel VBA is required to learn 'Excel Macro'. You should know that the term 'Macro'...
read more
Please make a correction, its not VB Script but Excel VBA that you need to learn. VB Script is different form Excel VBA even though they both are subset of VB (the same parent), Please google to know more. The knowledge of Excel VBA is required to learn 'Excel Macro'. You should know that the term 'Macro' means code. So obviously 'Macro Training' means training to code. In Excel you can create macros by using the macro recorder or writing the code manually. Most of the times the macro recorder may not do everything for you exactly as you need. Sometimes you may be successful using macro without properly knowing it. it's something like searching for a unknown location in the darkness without a route map or somebody's help. You can choose to learn macro if there is a professional requirement or you have a craze towards learning it. Anyways Your question has the answer clearly VB Script or Excel VBA, make a choice yourself. Thanks read less
Comments
Dislike Bookmark

Not necessary. As many have mentioned, the beauty of Excel is that most of your work can be done without VBA. Use formula as extensively as possible. You can also use record macros to look how the VBA works. Take help from online forums or from people on this site. Happy to help
Comments
Dislike Bookmark

Tableau Certified Developer and Trainer with 10+ Years of experience trained 300+ students

Yes it is needed
Comments
Dislike Bookmark

Personalised training for your needs.

If you have fixed steps that you want to perform without changing yhe conditions of the process you do not need to know VB script. You can use inbuilt macro record function. However note that VB script is different from macro development. Macro development is referred to as VBA and not VB Script. ...
Comments
Dislike Bookmark

Hi Suma, "We all talk about it.... often which is less understood." goes the saying. It is and it is not. VBScript (VB with .Net) should be considered if you are doing computation across One Computer , not Sheet. You will need multiple DB calls and puts secured architecture, MultiThreading, more importantly...
read more
Hi Suma, "We all talk about it.... often which is less understood." goes the saying. It is and it is not. VBScript (VB with .Net) should be considered if you are doing computation across One Computer , not Sheet. You will need multiple DB calls and puts secured architecture, MultiThreading, more importantly services which should not be called from excel to start with. VBA on the other hand (People errornously confuse it with erstwhile Windows Application builder which is now VB in Microsoft Blend) is ABSOLUTELY ESSENTIAL if you are going all the way to learning Macros. Whether the Instructor likes to tell you or not Invoking Numerical methods/ custom Functions can help. Macros are a popular representation of a proceedure or Subroutine (SUB in VBA). If you look at the video posted, you can see how recording a Macro helps you in learning VBA, but has several limitations which can be corrected only in code.... Limitations overcoming which reduces likelihood of error. VB and .Net will be perhaps as costly to learn as much of advanced excel. So unless you are to build Windows applications beyond scope of spreadsheets, there's no need. You can rather spend time learning more mundane technologies, and can bypass the need of learning complex return types. Again if you are already into cross MS Office application programming including complex VBA, you might just take the leap. if you'd need guidance on Business applications on Excel, and I'd be happy to help. Regards, Subhrodip Sengupta Scintilaa Education Center. read less
Comments
Dislike Bookmark

Professional Tutor with 15 years of experience.

to record macros VB is not required ..But to alter or to built your own, programming skill is very much required
Comments
Dislike Bookmark

Excel Expert

It will be easy to understand, however necessity makes you learn everything quicker
Comments
Dislike Bookmark

ITs ot compulasary but if u have knowledge for VB scripts then its easier and faster to learn Excel macro. Please contact us smartnubss@gmail.com for more details
Comments
Dislike Bookmark

Post Graduate in Engg

VB script is not needed for writing macros-Prakash Shukla
Comments
Dislike Bookmark

Dedicate quality time and there is nothing that cannot be learned

Its not necessary..However you need to have a fair understanding of excel to get a hang of macros.
Comments
Dislike Bookmark

View 38 more Answers

Related Questions

How to use the h look up in excel worksheet ???
Horizontal lockup
Sandeep

How many days it will take to complete advance excel course?
The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics...
Amit
Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7
What are the 5 most essential excel tools to master?
Data Validation Conditional Formating What if Analysis ( Scenario Manager, Goal Seek, Data Table) Filter Remove Duplicates
Yashraj
0 0
6
What is Microsoft Excel?
It is an Application which consist of Spread Sheet for creating Document based on requirement
Swati
0 0
5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Hidden Gems of MS Excel - Reapply Filter
Q) How does Reapply help? Or, when could I use Reapply?A) e.g. Please refer following screenshot: You are Analysing a Dataset.You have applied Filter on Date Column, to focus on April month entries.You...

Ankur Sharma

0 0
0
Data Analysis with MS Excel Filter - Top Performers, Bottom Performers, Above Average Performers, Below Average Performers!
In the following, You would find lesser-known, unexplored yet Powerful Features of Filter. Please refer to sample dataset below: To do Data Analysis:Step 1) Apply Filter on the dataset.Step 2) In Sales...

Ankur Sharma

1 0
0
VBA - Loop Demo

Vipin K

0 0
0
Microsoft Outlook
Microsoft Outlook is the preferred email client used to access Microsoft Exchange Server email. Not only does Microsoft Outlook provide access to Exchange Server email, but it also includes contact, calendaring...

ITech Analytic Solutions

0 0
0
My Experience on Recruitment for Data Analyst role.
Hi All, I want to share my experience here and why I chose to take up classes on Advanced excel. This is not technical lesson but a motivation to improve your skills. I was leading Data Analyst team...

Sai Krishna

0 0
0

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

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

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 you
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

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

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved