Nothing better than on the job training. For Excel, there is a macro recording capability that records the code needed to execute any command function you exercise.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!
FYI: If you get some proficiency in Excel VBA and understand Object Models and Object Programing, the Excel VB Editor has tools like Watch Window, that make discovering Object Properties in other systems like CAD, possible. I've written VBA procedures in Excel VBA, for applications I had no documentation at all for, just by my general knowledge of Objects and Object Model Structure, that I learned at Tek-Tips and personal research.
This site and Tek-Tips will serve you well in your endeavors.
Skip, Just traded in my OLD subtlety...
for a NUance!
Coursera has a fantastic VBA course where you learn to code in VBA for use in Excel. The "Macro Recording" mentioned by IRStuff is ok for really simple tasks but if you truly want to be able to optimize your engineering calculations and build powerful spreadsheets, then I suggest taking this course. I had zero experience with coding of any language and took this course with no problem and I'm now proficient in VBA and build spreadsheets to use everyday for my structural designs. The course (3 parts total) can be taken for free or you can pay a fee (i think $50-ish) at the end for a certification of completion.
Follow this link to go directly to the course page... "