How to code in Excel and Tableau using python?

Question

I am trying use python coding to analyse data in excel and Tableau. I do not know how or where to start with.

Answer 1

It seems that Excel only supports VBA so you cannot use python there.
However, you can export .xls to .csv and apply the Pandas library, then open your result in Excel and turn it into .xls again.