Python In Excel: Microsoft Changed EVERYTHING

u know whats really cool? an actual sql dialect. checkmate excel...

god there's only one app i hate worse than excel and thats powerpoint, but outlook the webapp is ...okay... granted we abuse powerpoint for data communication at my work... its way more spamming graphs than communicating insight...

trying to push for dashboarding...

Excel does linear regression

I cannot get Python in Excel... HEEELPPP

Python in excel is like driving a sports car on a go cart track. Makes 0 sense

Excellent editing Luke. Had to pause less than 2 minutes into the video to let you know.

I would like to ask basic question: How to install Python in Excel, I really go throught this vedio, but still do not know how to build up python in Excel like your vedio.

you know you old when instead of skipping the video you are like 'tf mate its crazy, could be useful on my daily basis'

Bro... your videos are next level 🔥

I am new to a lot of this stuff and trying to get better. Where did you get the data? Where do I get data like that?

I'm a marketing operations analyst and only use Excel. The nice thing about marketing analytics, is the data is always provided to you by BI groups or CRM/GA4 reports. No data science or mining is required, at least in my position.

awesome

Your videos are just 🔥🔥🔥🔥🔥🔥

Lol, why not just dump excel all together?. Once you have mastered pandas, spreadsheets become the coloring books people use them as.

Great and quite informative video. Can you share the demo Excel data sheet link please ?

This has been in libreoffice calc for years and its free and runs locally.

Really, really informative!

Can SO tell me which laptop is he using? Thank youuu

Try R.

Hello. Could you please share the template of your personal portfolio website. It's really awesome !. Please create a guide for how to build one ?. Using static templates or Wordpress etc ?. It would be really helpful. Please !

Doesn’t seem that I have this on my excel

useles. absolutely no point. while excell is full of bugs

I don't speak English, I had to watch the video with a plugin that gives you audio of the subtitle text. I loved the video, although you don't explain anything in depth, you do say everything you need to know about python and excel and all this with an excellent sense of humor. I have subscribed to your channel.

I have 12 years in excel, 3 years chopping code with vba, 3 years in dax and power query, 9 months with the new Lambda functions and 3 months in python.

I started without knowing that it would be in Excel. I think this new functionality will give me the additional motivation I needed to learn to program in Python, I hope that my second language is typescript so I can take advantage of it in Excel.

The big catch is it runs on cloud! It is not going to free(forever and unlimited) and we can not build in-house python library for excel to share . This TBH kills my usecase .

So excel automatically recognized libs and do the downloading and installing too?
That is something 😂

Can I use 'requests' function in Excel for crawling online data?

👍

Is this 365 excel ? Cause the excel we use at working doesnt havent python embedded

Python in a cloud? A bit of no no. Wouldn't be weird for MS start to charge for "additional feature" to run it in your Excel... while having this feature already installed on your machine. Hope they will switch to local interpreter.

Good

This is so obvious, yet brilliant.
Every organisation needs to be on top of this

Excel just gets in my way. It's for suits that can't code.

Is python in excel is free or we have to buy subscription?

Brilliant video. Thank you

Quality, story telling 👌🏿 🔥

that was so funny, entertaining and educative! kudos to you and keep up the effort!

This would be awesome if it was actually usable for everyone.
Completely useless if nobody else can use python with their excel....

One of the best Python in Excel analysis that I've seen. Well done Luke. keep it going.

One negative you didn't mention - this is for Windows users only currently. Mac users need to wait.

A really stupid idea. The last thing an Office user needs is another programming language whose ONLY obvious use is to call FUNCTIONS from a function LIBRARY, which in turn was written in completely different languages. It would have made much more sense to make libraries like NumPy or Pandas directly accessible for VBA, instead of converting table cells into uncomfortable editor fields for Python scripts (this is also possible with other libraries whose functions can be called as functions or formulas). If I only need Python to call C, C++ or Rust functions, there is a lot wrong. What Microsoft thought about this remains mysterious - the explanations are anything but rational - it will probably be about economic interests. Probably they have seen that obviously many people like to program in Python and want to bind them as new customers, what do I know. Once again, it's a stupid, completely unnecessary idea - and I'm not saying that because I have something against Python, but I would also say that if it were any programming language.

Does it work with an offline version of Microsoft office?

Does it mean we can use python code in VBA editor...if so this is great

what is the best way for a newbie to start practicing the combination of these skills?

Thanks, “Cool Hand Luke.”😎

I have been trying out the case studies and assignments from my MIT No Code AI ML course in ChatGPT's Advanced Data Analytics and it's been really fascinating to see how far it can go. Typically it does EDA and outlining the approach for models very well. It usually fails at the point where it is missing the libraries it tries to access or if the dataset is too large.

I communicate more with chatgpt than my own mother

Great for malware developers ^^😊

Luke, you are awesome, thanks for sharing