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.
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.
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 th-cam.com/video/HXJ34-iN5H4/w-d-xo.html Good luck with the interview! This other finance interview questions should also be useful: th-cam.com/video/hZALF58_qsY/w-d-xo.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.
✅Learn more Excel with my course here: www.careerprinciples.com/courses/excel-for-business-finance
Hi Kenjie, I would really like to enroll on the Excel and Power BI bundle course, do you till provide discount?
I'm not that excited about this per se - but I am excited about what more talented people can do with it that I can copy!
have the same thought
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.
Thanks!! Could you do a tutorial on the S&P Capital IQ plug in
Not sure but will keep it noted! Thanks for the suggestion
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.
But both Python and R are available in Power BI.....
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.
Thanks for your video. I just found out about this and want to use it as soon as it available.
Extraordinary way to summarize this update for Excel. Thanks for sharing!
Thanks for the nice comment :) Glad it was helpful!
Your Excel knowledge was really helpful for me on today's exam ❤
Great video on the new Python feature!! Thankssss
Thanks🦋💙🦋, greetings from 🇵🇱🇩🇪
please explain, vba versus phyton....what same the fiture or phyton more full and more good vba
Nice job as usual Kenji. I am following closely. Keep it up.
Awesome, thank you!
Great one Kenji!
i have a new install of office 365 with excel... but do not see python in the formula bar. How to get this ?
Great video, thanks Kenji!
My pleasure!
Is there a quick reference of the python codes that you’ve used in this? Can we see anywhere in the excel sheet or we need to just Google it up?
Super Do-per
doesn't look like its on the Mac version :(
Great video! When is this going to be available for the public to use?
It's already available for some people so should be rolled out more generally soon :)
Hi Kenji, I cannot find python in my insert tab. Any way that I could activate it? thank you!
To clarify, this is only available to a few for marketing purposes, this is not available to the public.
Not true
It is in the beta channel of excel releases (which anyone with a subscription can get. Ltsc licenses do not get updates)
@@redeux Of course you can sign up for it, but that still doesn’t mean you can use it.
no wonder
Thank you so much!!
Glad it helped!
Kenji you are a ⭐️ ❤
Haha thank you!
hello - what version of Excel is this possible - I still have 2010 excel in my PC
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!
never mind figured it out!
Thanks
Thank you for supporting the channel! Hopefully more good videos coming :)
is this availible for MAC ?
Not yet!
please help me to get office 365
For me Insert Python itself is not enabled. Can you help enabling it.? I have already joined the insider program but it is of no help.
Hey, I explain more about the rollout process in the video
see towards the end for the details of the rollout process
correct if i wrong but excel dont install python in your machine only use python which is hosted in a server.
Does it autoupdate or we need to buy a premium version for it? Which version has this feature
Autoupdates with microsoft 365
What excel year from? 2013 or after? And how to install it?
Office 365, newest version!
Kenji, You are the Man. Thank you a million.
Thanks for watching man I appreciate you!
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 th-cam.com/video/HXJ34-iN5H4/w-d-xo.html
Good luck with the interview!
This other finance interview questions should also be useful: th-cam.com/video/hZALF58_qsY/w-d-xo.html
Awesome - thank you very much indeed for this very useful tutorial!
You're very welcome!
😂F tc fv 🎉CRoz😅😅
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.
Python is best
If you know python
Upwork give you 1st job
Notification gang
Lets go!
If you have a team you do something if you are alone you dont do any think
nice intro lol
XD
Every video i have seen so far doesn't tell you how to enable python inside excel, they only tell you how to use it, for god sake!!!
This is not Python...