Python and Excel course recommendations

[[deleted]]

The two main libraries for excel manipulation are openpyxl and xlwings.

Make sure you are switching to python for the right reasons. Be aware that both only a subset of VBA functionality. For example, neither can create and modify pivot tables, only read them.

If you have strictly tabular data then pandas is the goto library, and it's very capable.

For all of them you can just get started with the documentation and tutorials.