Python is the excellently language and one of more used languages in Microsoft projects. I wanted an Excel that was secure and easy to use ironPython in it. The current version is very similar to most of my expectations and is revolutionary. I want this powerful language to be used by more people.
I thought it may be great at first BUT from what I've read python code is at Microsoft's end of the server (not your local machine). Apparently anywhere python is inserted it acts like a volatile function; seriously affecting performance, so you can't have much python in your spreadsheet, refreshing each time you click inside a dataframe I'd imagine. i have not been lucky enough to receive the python in excel despite updating to the latest build in the Insider 365 beta channel.
New subscriber here. Anyone!. I'm not knowledgeable to excel. Even a simple basic. Any recommendations of how to learn excel from basic to advanced. A simplified teaching will be much appreciated. Thank you
Thanks for this great video. That is excellent! Could you please upload your Excel workbook for this tutorial? Then I can follow step by step for practice.
Hey Kenji, great video. I've gone through all of the steps and have added the Python add-in but only get the "preview" option. I've tried to troubleshoot but no luck. Is there something else I need to do? Many thanks!
Hi Kenji, I am a huge fan of your videos and all your advice. I have an interview excel test coming up and I was wondering if you have any videos on that? Like what sort of questions to look for? I was told it would be basic cash flow definitions, WACC calculations, and fundamental financial statement questions Thank you
Hey yeah I have mulitple excel test videos! See here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HXJ34-iN5H4.html Good luck with the interview! This other finance interview questions should also be useful: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hZALF58_qsY.html
At this point why even use excel? If you want to create good visuals with python you need many more lines of code. Easier to just put the data in a csv, import and manipulate with pandas. Then matplotlib however much you want to tweak to perfection.