You should learn the basics of VBA, as much as I despise this language, I can tell you as a mechanical engineer myself, that you will stumble over countless excel sheets with VBA from your colleges and it’s good to have at least a rough understanding of what they did.
Also it’s unfortunately the automation/macro language of many CAD-Systems (Catia, SolidWorks, Inventor,… to name just a few).
Python with jupyter notebooks or julia with weave are also worth taking a look into it.
They a both pretty good for calculations + documentation and drawing nice graphs.
That’s what most of my collegues do in excel with VBA, but it’s much nicer to do in the two mentioned before.
You should learn the basics of VBA, as much as I despise this language, I can tell you as a mechanical engineer myself, that you will stumble over countless excel sheets with VBA from your colleges and it’s good to have at least a rough understanding of what they did. Also it’s unfortunately the automation/macro language of many CAD-Systems (Catia, SolidWorks, Inventor,… to name just a few). Python with jupyter notebooks or julia with weave are also worth taking a look into it. They a both pretty good for calculations + documentation and drawing nice graphs. That’s what most of my collegues do in excel with VBA, but it’s much nicer to do in the two mentioned before.