I have just finished Python in Excel course by XelPlus!
If you are looking for comprehensive online courses in Excel, then I recommend XelPlus. The videos are clear and thorough. There are worked examples to go through and extra help if that is required.
I was skeptical about the need for Python, but I can see now where it could be useful. In fact, I have used it in two jobs already. The first was to deal with a big lot of data. I would have normally done this with power query, but the specific calculation required does not work in power query. I had done the work on the Excel sheet using VBA and this worked, but was quite slow and made the file size large. Switching to Python, made the processing quicker and the file smaller.
The second area where Python will be great, and I have already made use of, is in graphs. The ability to create graphs, that would be difficult, if not impossible with ‘normal’ Excel will make a big difference. You can also build in, relatively easily, the ability for the user to make selections that change the graph, from how it is split, to colours, to the type of graph!
