Is VBA for Excel becoming a less common skill?

jillian728

Active Member
Joined
Jun 20, 2003
Messages
250
We have many VBA for Excel projects that have been developed over the last 10 years or so. We typically have had a long term intern on staff working to create and maintain. All of these interns had VBA for Excel experience coming in and were able to hit the ground running. Our problem now is that it has become increasingly hard to find students with VBA for Excel experience.

We are considering converting our VBA for Excel macros into Alteryx. We have a license but haven't had much time to really kick the tires to see if our VBA projects could convert. Considering looking for an intern with Alteryx rather than VBA to give us another option.

Now for my questions:

1) Is VBA for Excel becoming a less common skill for college students or in general?

2) Anyone have thoughts about converting VBA projects to Alteryx? For example, do you think it would work to focus on someone with Alteryx skills and they don't necessarily need to have a handle on VBA code? Of course that will be more work for us to explain what the code is doing if they are unable to ascertain on their own.

3) Any other thoughts on this topic? Such as, if they don't have Alteryx but have another similar (?) tool, could that work?
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
1) VBA is not becoming a less common skill in general. However, students with proper VBA skills are pretty rare. For example you could give a shot at:

- Data scientists/analysts
- Math students
- Engineering students

The thing is, in many cases VBA is self-taught, which takes a lot of time. Especially getting to a high level. Most students do not fully focus on VBA.
For the future, VBA is not disappearing anytime soon, since Excel is world's most widely used program among companies.
 
Upvote 0
And I don't know if you would have any better luck finding people with experience with Alteryx.
Quite frankly, I have never heard of it before now, so I am not sure how common it would be to find students with knoweldge in it (unless it is something that is used at colleges and universities).
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,241
Members
452,622
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top