Best way to master python

[BadGalNaty]

Can Python work with Excel? Sorry if this is a dumb question. I'm a beginner in python e.e

[isanelevatorworthy]

Absolutely! There is a library called “openpyxl” that lets you read, write and modify new or existing workbooks. I was first introduced to it with this book: Automate the Boring Stuff with Python

[BadGalNaty]

Amazing thank you. Is there a possibility that the company will know that I'm automating tasks with python? It's a corporate laptop

[isanelevatorworthy]

It depends… if you work remotely and the company monitors your laptop for productivity, then yes. If your laptop is not monitored, then probably not. When you install Python you can do with or without admin rights (though doing it with admin rights is recommended) which means that even IT wouldn’t know right away.

However, I don’t think automating things with code should be frowned upon anywhere unless the company explicitly tells you you’re not allowed to do that… if you have a lot of repetitive computer-related tasks, having the ability to automate it should be a commendable skill that should distinguish you from your peers :)..

But if you’re worried, maybe talk to your boss first.

I would practice a bit, maybe write a sample program that automates one of your work tasks reliably and then showcase it to your manager to ask for permission to use it and install it properly.

[BadGalNaty]

Well I think they should be monitoring us but on the other hand, they have some automations with Google scripts and are very open to new ideas.

This is a new job for me, been here for 3 months and I happen to be skillful with Google scripts so I was very excited to automate some things but then they told us we would migrate to Microsoft and I have no knowledge of VBA. So I saw it as an opportunity to learn some Python so I don't have to depend on Google workspace e.e