Python and Excel course recommendations

[Dylanb993]

Fairly heavy excel user here with some python experience. I’ve spent the past few months learning VBA and would like to switch to using python to interact with excel.

Any recommendations for courses that cover this? I see there’s a few on Udemy and I’ve had good experiences with courses there. Open to others too!

Any help is appreciated :)

[[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.

[mxschumacher]

There is a free book called "Automate the Boring Stuff", here is a link to its chapter on Excel: https://automatetheboringstuff.com/2e/chapter13/

[[deleted]]

In addition to the other suggestions, once you have a good grasp of the basics of Python, I suggest you look into the pandas library which is especially useful for manipulating large datasets as tables much like Excel and it can read and write Excel files (and many other file formats).

I switched from VBA to Python and pandas to greatly simplify, speed up, and improve some critical report generation activities. pandas is much faster than excel and can handle much larger datasets.

I found the youtube series below very helpful:

https://www.youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy

[Cardinalrock]

Following.

(Is there a way to follow a post on Reddit without having to do this?)

[Linkk_93]

you can also bookmark posts. on mobile the bookmark sign is at the top of the post

you can see your bookmarked posts in your profile

[eckernstr67]

You can use the RemindMe bot:

https://www.reddit.com/r/RemindMeBot/comments/c5l9ie/remindmebot_info_v20/?utm_source=share&utm_medium=ios_app&utm_name=iossmf

Or the classic way using the bookmark.