Python for Excel: Use xlwings for Data Science and Finance (Udemy.com)

Good part: Installation of Anaconda and Jupyter Notebook has been helpful because this is what I was looking for. Maybe bad point: I have learned pandas first, and I do not want to confuse myself by learning xlwings steps which could also be done by pandas.

The instructor is a very good English lecturer (though English does not seem to be his first language). He speaks at a measured pace and very understandable. He includes a crash course on Python in case you haven't used it in a while (like myself... very helpful to jog up the memory). Is this Udemy course going to teach you everything about xlwings? Of course not... It will give you an "advanced introduction" and then you will have to dig deep into what you want out of xlwings.

Overall, I am happy with the course content and especially liked the crash courses. I just finished a UDEMY course on Python from Jose but I really liked the crash courses. From there, I enjoyed the first few lessons but ran through some issues with the course using reference to libraries deprecated and not used anymore... Also, one little issue I experience is related to courses going backward and forward in the same notebook. I think it would be more pedagogic to show one aspect of the issue with a note and then, duplicating the codes in another notebook entry with the improved feature to clearly show what changing the codes will yield. Otherwise, it is really difficult to follow and in few months time, I would have completely forgotten the point being made... Finally, I must admit that the UDF section is very complex to follow: all the codes are given and I suspect you need to be an expert in Pandas to understand what the code does. Applying the functions worked as expected but replicating the codes would be virtually impossible for me. For instance, the correlation function is super powerful but I could only use the codes as a basic user and writing those lines would be impossible for me. I hope this feedback will be helpful and not too depressing! I enjoyed the course...

A very good piece on how to make Excel and Python talk to each other. Really useful for anyone who works with Excel, but wants to enhance their productivity with Python, as well as for those whose workload is mainly in Python, but for any reason need to use Excel as a front-end. Thanks for the lecture on how to implement Monte Carlo simulation!

The instructor is excellent. He knows how to teach. He teaches both by showing how to properly handle certain things in Python, and why other ways would not work and would lead to pitfalls. He knows how to break the material in little manageable pieces, how to move from one topic to the other and how to beautifully arrange the materials and examples so that one builds on the previous one. Well done!

This is an exceptionally valuable course. It was my introduction to Anaconda which is an excellent development environment. That was valuable in itself even though it is just a small part of the course. The XLWings coverage is very thorough, and the Numpy and Pandas sections are also valuable.

Actually course content is very good , for me i am accountant and studying machine learning found that best things i got from this course till now is : - Macros "Run Python" it automated my work too much and lindked it with pandas and data visualization tools , and it is very important tool for me . - But projects of simulations and yahoo finance it is not usesful for me , i think projects like daily report automations and something like that would be useful for me , but it's great .

Alex have detailed knowledge on all the courses he made. He explained every concept very well and also answers to our questions within a day. If someone wants to learn Pandas, xlwings and trading setup then his courses are must to enroll. He starts from very basic and take us to advance level. He even include appendix so that if something is needed in the course we don't need to look anywhere else. Thanks Alex for so many awesome courses.

I'm an accountant and been wanting to learn python for financial data analysis... as a newbie to coding, everything that is discussed in this course excites me!... there are items discussed that confused me but after replaying the video, a few reading, and re-examination of the codes , im starting to get the hang of this python programming... i'm very excited to actually apply this to real world problems! I hope choosing python as my first programming language would be the right choice! Great Course so far!

I enjoyed this course. Before this course I had previously tried to use xlwings and pandas-reader and had run into problems. Following the lectures made it easy to get these to work and get results. The practical examples of loading stock data was useful to demonstrate the process and getting the settings right. Accessing stock data outside USA was really good. Excel is useful front-end for many people and the python-excel combination is a good option in some cases. I did not complete the python background as I had this knowledge before the course.