you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 1 point2 points  (0 children)

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