Your first step could be learning the basics of Excel, Python, and VBA right here. Get the Complete Excel, VBA, and Data Science Certification Training Bundle for £41.55.

Python and Excel can only really talk to each other through limited functions—xl () and =PY ()—that can only return code results, not macros, VBA code, or other data, Microsoft claims.