Excel - Learn How to Use Python in Excel - Beginners Guide to Python Integration - Episode 2614

I have Microsoft 365 and joined to Microsoft 365 Insider beta version. But unfortunately I always get an error code: 30183-28 (400) after pushing update button.
Tried all option what I got from internet (they are almost same) but without any success. Can you help in this please?

Is ChatGPT any better at writing in Python than VBA?

This is only available in Beta Channel Insider level. Rubbish.

I can understand your teaching much better, simpler than the python pro tutors guess cause I'm near your shoes learning it

you have shown us the implementation of python in excel. But where is the setup.
How have you done this setup and everything. You haven't told that. Where are those details to setup python in excel??

Hi I was able to get into insiders beta, but still do not see python. Please help thanks

Amazing

Thank you this is exactly what I wanted to see!

Does this mean VBA in Excel will be replaced by Python in Excel? Can we create forms and stuff using python in Excel now?

pressing ctrl alt shift m types accented m. how to turn that off and use this shortcut to switch between python object and excel value 😢

I can't get this =PY( mofo to work and it's making so big mad I could fight ten elephants. I can't wait... I can't sleep... I can't stop thinking of the possibilities...

I
WANT
PYTHON!!!!!!!

Wow!

Sir can I still run my vba code in excel?I mean in excel with this python apps?

perhaps its just me but i don't think this looks super helpful for my work

Can you get Python to dynamcially add sheets/insert rows based on user input, like you can in VBA?

the fee will be to cover the cost of the cloud hosted Conda python environments; if it's possible to get it running using a local python environment then it should be free?

Exciting!!! but where is the step forward?

Nice Visualizations Bill !!!

great introduction ! i've been waiting for excel+word hybrid for a long time. let me resize column for each table independently(same sheet).

Must be different levels of "InSider" -- every time you show new stuff on the insiders - i get it 12-15 days later. You must be A-Level insider, and us peons, are D-Level.... LOL. Oh my more to learn :Visi-Calc, Basic, Lotus-1-2-3, Fortran, Excel Pascal, C, C+, Visual Basic, now Python... Danny Glover said it bets - "I'm getting too old for this S***"

I love how you showed your purchased py book from 2013. Can relate 100%

Thanks for share this information.

great!
pandas library in phyton is like power query
and phyton is great tool for data analytics and machine learning, integrating all of this in excel...mind blowing 🤯🤯
i think the best course for python basics there is no best course than CS50 python programing
to have all the story "Accounting Data Analytics " Illinois university coursera course is the best.

Great tips using python, thanks MR Excel

This is great and i am looking forward to more :)

Please make a new video for forecasting using Python in Excel

Very cool indeed. I'm an occasional pythonist. I'm not necessarily convinced by the interface, but I like it. I do like the idea of a toggle on the formula bar but not sure it should be used the way it is, and can't help but think that could have been used for specifying lambdas instead of name manager. For me, returning a cell value or data type should be specified in the code itself. It's not really a setting in my opinion. I like the graphs, but the single cell might be problematic.
A great start though and thanks for bringing it to us!

what version of Excel because it does not work for me. I have excel 2021.

That's a very comprehensive test. Thanks for doing it!

finally! is lambda() useless now?

This is great news. Can't wait to learn some new tricks.

Thank you Mr Excel for introducing to us this new feature

Wow. Nope.

Interesting, thanks Bill!

GREAT but Fight the Fee!!

Wow I will wait for it after the refresh

Wow finally a moment of clarity on their part.
Mr. Excel, do you think this is a step in replacing VBA with Python?

That news on the fee is a right bummer. There are additional fees for AI/Windows CoPilot features and now this, it's all adding up like TV subscriptions. I feel like most businesses will be locked out of this and AI, shame.

Joy, oh joy, for what seems to be the world's most creative obfuscating complication of a simple range?

Thank you