UrbanPro
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

Use of INDEX in MS Excel?
INDEX function is a powerful tool that allows you to retrieve values from a specified range or array based on row and column numbers. INDEX(array, row_num, ) As it requires row_num and column_num, it is...
Prabhakar
0 0
6
Is MS Advanced Excel training very costly?
no
Pritty
0 0
5
I am looking to learn immediately Advanced Excel & VBA Macros. Please provide the Institute contact details and tutor availability in week ends ( Sat- Sun) .
Hi Pratap, Would you please let me know your educational background as to know VBA Macros , you must have good hands on Programming...and if you are novice or not from it background then I suggest you...
Prathap
Excel formulas in advance level?
Hi Manoj, There are over 500+ formulas in Ms Excel. Ms excel is very vast application. There is no basic & advanced level in Excel but we have divided into it. That is depends on work type, even we can...
ManojGS
Hi, I'm BCA graduate, and I have seven years in the general insurance field now I want to change my profile and upgrade my knowledge. Will learning python help me with my growth in my career?
Hi, as far as my knowledge goes first, you should learn data processing tools or programs like MS Excel, Power Bi, or SQL then you should then take a leap into Python, which will make automating your work quite simple.
Supriya

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

Ask a Question

Related Lessons

Basic EXCEL Tips
Learn Use of MAX function in EXCEL: Penalty of Rs. 2% or Minimum Rs. 100 Amount Penalty Formula Rs 1000 200 +MAX(1000*2%,100) Rs 400 100 +MAX(400*2%,100)

Kshitij Agrawal

0 0
0
Hidden Gems Of MS Excel - Consolidate
Situation: You are part of the Finance Team, and work at Headquarters of an Organization.Periodically, You receive expense data from Teams in different Regions.After You receive expense data, You SUM all...

Ankur Sharma

1 0
0
Flash Fill: Advance Excel
Flash Fill is only available in MS excel 13 and above versions. Flash fill is used to fill the data automatically in the below cells if a pattern is evident. It can also extract, insert or concatenate. Some...

Trisha J.

0 1
0
Arrange and View Multiple Worksheets at Once in Excel
Arrange and View Multiple Worksheets at Once in Excel This feature allows you to view multiple worksheets at once from the same workbook at the same time. You need to follow beneath simple...

Vishesh Golya

0 0
1
Excel basic Sessions Demo - Save a File

Vipin K

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