Use of Excel and VBA (visual basic for applications) in quality systems

M

mclau152

Hello all,

I'm currently an intern at a Tier 1 Automotive supplier and a lot of my work involves excel spreadsheets of anything from measurement data to finance records. I have taken it upon myself to learn the inner workings of excel to make my job easier. I've successfully created programs which can automate most of my work and even provide my fellow workers with tools to expedite their own spreadsheet requirements (i.e. creating 500 worksheets for financial records with a macro).

My question is where is the best place to apply this sort of knowledge if not in the Automotive industry? Is there better potential in another field or should I move onto using spreadsheet analytics in finance for a better raise?

If that's too much to take in have this tl;dr

Soon to be college grad learns uses of VBA coding, wants to get involved in the right field early so asks advice of those who know the markets better

Thanks in advance

-Leo M
 
M

mclau152

Thank you Steve, I've always had my eye on government work. The types of statistics I'm learning in automotive quality might be a little different however. I'm doing my best to absorb all the information I can about the commonly used statistical methods and programs like Minitab and especially excel, hopefully they can be applied towards experience in a "Quant" job.
 
V

Vthouta

If you are really interested in this kind of work, please look at the below:

http://www.careersinsupplychain.org/job-roles-profiles/Profile/SCAnalyst.asp

Supply chain analyst roles involves lot of data gathering, automation and smart decision making to improve the important metrics like productivity, inventory turns etc.

Since you are working in Tier-1, you can get to meet some folks within that organization on how they manage supply chain network.

Vik
 
You must log in or register to reply here.
Top Bottom