What is the best way to learn Python with Excel?

Hi, I’m just starting to learn python right now, I’m about 200 pages through my first book. Over the next 6 months to a year, I’d like to spend at least 20-30 hours per week studying and coding in python. But python, since it is so versatile, I’d like to learn more about how to use python with Microsoft Excel.


do you want to automate stuff in MS Excel (I.e. create macros)? In the past I processed batches of CSV files and created calculations and diagrams (though I used Excel macros resp. VBA back then).

Or do you just want to create/read/modify/process data given in one of the Excel file formats?

What usecases do you have in mind?