My method of success for Excel:
No training on Excel or VBA or any other programming language. Trying to teach myself as needed.
I have a Mechanical Engineering degree, that is collecting dust.