For those that are payroll professionals, how much do you think it may be in your benefit to learn/know the VBA computer language for Excel?

Asked by Last Modified  

2 Answers

+1 Microsoft Excel Training

Follow 5
Answer

Please enter your answer

Nev Laishram

Everyone should learn VBA if they spend any significant time working with Excel. As others have already pointed out, you can automate tasks that you do repetitively. Rather than doing these mundane things yourself, you get the computer to do it instead. You can also write a function that does exactly...
read more
Everyone should learn VBA if they spend any significant time working with Excel. As others have already pointed out, you can automate tasks that you do repetitively. Rather than doing these mundane things yourself, you get the computer to do it instead. You can also write a function that does exactly what you want to do. If there are any complex formulae that you employ in your payroll process, it might be better to convert it to a VBA function. What you might lose in terms of processing speed you would gain in readability and maintainability. Both of these are ultimately more expensive than processing time in most cases. After all, it is painful and costly to pay someone to fix a spreadsheet that is very hard to understand. If you write your VBA code well, almost anyone with a reasonable level of VBA can help you out. It also depends on the particular environment, job duties, and even programming proficiency. But a background in Computer science would be most helpful. I hope this helps. read less
1 Comments
Dislike Bookmark
It depends on the work detials.
Comments
Dislike Bookmark

Related Questions

which is the best college or institute for Data analysis course certificate  with Fresher placement support  in pune?
Hi.. There are the institutes conducting online courses. Like for example, Simplilearn Edureka. Particularly in pune, ExcelR* Hope it will helpful. *before joining compare with other institutes.
Priya
0 0
5
Are there any excel and VBA coaching centres at As Rao Nagar?
nope
V
How to use vlookup in excel?
Syntax for using vlookup function is =VLOOKUP(LOOKUP_VALUE,TABLE_ARRAY,COL_INDEX_NUMBER)
Ankita
0 0
7
What are the best practices when modelling in Excel?
Best Practices for Modelling in Excel: Know your Tool which is excel in this case. Avoid Circular Referencing Have a Glossary for your model which states what means what Use same theme and formatting...
Ajay
1 0
6

which is the best institute or college for Power bi and AWS course with job Support in Pune location? 
Hackers University APC Learning Solutions is the best training institute for AWS & Devops, Power BI they provide training with job placements
Vk

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

Ask a Question

Related Lessons

Newspaper columns
One of the many wonderful features included in MS Word is newspaper columns. With the help of Drop Cap, Multi column features and with Section breaks one can create wonderful articles just as it appears in a Newspaper.

Ramesh Kn

0 0
0
VLOOKUP and LIST Creation Explained
.) This table is in the range A1:D4. You want to find the salary of employee with ID 102. Excel =VLOOKUP(102, A1:D4, 4, FALSE) 102: The Employee ID (your lookup_value). A1:D4: The table containing...
G

Ganesh S.

0 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
Range Selections
G

Gagan G.

0 0
0
An Introduction to Business Intelligence Concepts
Looking for a Business Intelligence (BI) solution for your company can be intimidating. BI uses its own special terminology and the database design concepts can be difficult to grasp. So where do you...

Itech Analytic solutions

0 0
0

Recommended Articles

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

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 >

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

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 MS Office Software Training near you
MS Office Software Training in Delhi
MS Office Software Training in Bangalore
MS Office Software Training in Mumbai
MS Office Software Training in Hyderabad
MS Office Software Training in Chennai
MS Office Software Training in Pune
MS Office Software Training in Kolkata
MS Office Software Training in Ahmedabad
MS Office Software Training in Gurgaon
MS Office Software Training in Jaipur

Looking for MS Office Software Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you