Python in Excel - Beginner Tutorial

[@KevinStratvert]

Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ Learn the fundamentals of Python in just one hour: kzbin.info/www/bejne/mGGcZJSndr-chrcsi=Rv1r2vAqBnsQfPWO Watch even more free Excel tutorials: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

[@SamirHabib]

Dear Kevin! You opened my eyes for using python in excel. Yo do good things bro, carry on ❤! Thank you very much! Greetings from Azerbaijan, Baku!

[@DavidT99999]

Thanks so much for your videos Kevin - you are a master of your craft! 🌟

[@napsec9807]

I am a web dev that happens to be working as a middle manager and this has sparked an interest for my actual job!

[@DannyHusky33]

I was wondering when something like this would come out from Kevin! Thanks again for being the go-to for getting started with apps/programs that somebody would possibly hardly know anything about. Your guides are always so beginner friendly and motivating.

[@antonynganga7868]

Absolutely brilliant way of navigating through excel using Python,you've made it so easy to understand, good job Kevin😊,Dubai

[@UniversalBuilder]

Tremendous value ! And I speak of not only the content itself, but also how it is produced. Clear, easy to follow, and a tons of resources linked. It's inspiring. Thank you for sharing this.

[@dianadiazak8342]

Hey kelvin, you're the only one who makes me understand things in my computer.. would you kindly tutorial on how to design a website please please please 🙏🏽🥺

[@ahmedskullab]

This is great! I pay attention to this in the coming few weeks, this is a great video! I have been using python for automating workflows and this is really helpful.

[@hlangananimdibi4670]

Thank you brother. You're helping me prepare for a post-interview assessment. God bless you.

[@SimonAdansi]

I can believe it what!!!!! Python in Excel !!! !!! 🥰😍😄😆🤣😂🙂😋😛 ... I' m sooooo excited

[@superspak]

Another amazing video. The describe method just changed my life. Looking to more programming videos! I am a Mechanical Engineer trying to branch out into more skills 😁

[@AdisaAratunde]

Great stuff @Kevin I learnt so much in one evening following your videos. I've also subscribed to more videos to never miss any more of your juicy posts!

[@Londoneriam]

My Excel does not show the python buttons like in your example. What do I do for it to show in the formula tab? Thank you

[@ShowAloudLy]

Same problem here.

[@erikpaterson1404]

I'm guessing you might need to use the online version of excel (?)

[@grr82]

Sign up for beta channel. Restart the computer. Worked for me.

[@MNovakMNovak]

You need to sign up to the Microsoft insider program to have access to it

[@graymccarthy685]

Now on general release (update to make sure on the latest version)

[@Fredjoe5]

Just updated by Excel 2019 - No Python option. Kevin should really have mentioned that this may or may not be available in your specific Excel version.

[@nczioox1116]

Same with my companies excel 2023

[@ShaunMcDngh]

He probably didn't know. I believe it's only available in the Insider program. It's not in the 360 either and I believe it's only online.

[@dave2329]

@@ShaunMcDngh WRONG,. ITS IN 365 INSIDER ON MY LOCAL EXCEL

[@SurgeEquityResearch]

@Fredjoe5 Do you need him to hold you hand too?

[@SurgeEquityResearch]

@@ShaunMcDnghwrong

[@tanjiaqi7840]

Awesome 🎉🎉🎉 I can't spell my gratitude toward you man. You are the hero of my day.

[@pjohn1435]

Thank you for all this wonderfulness, I've opened my Excel, went to Formula, oops there is no Python. Can't understand why there is no Python, using Microsoft 365, can you explain? Thanks Kevin!

[@lokisinaryedu]

same

[@guolunli1908]

same

[@TheEJonesve]

Can you explain how to activate the Python feature in Excel? What are the requirements?

[@KevinStratvert]

It’s currently rolling out. Here’s the latest update from Microsoft on the roll out status: Python in Excel is now available to all Enterprise, Business, Education, and Family and Personal users running Beta Channel on Windows. This feature will roll out to Excel for Windows first, starting with build 16.0.16818.20000, and then to the other platforms at a later date. To get it now, you can join the Microsoft 365 beta channel directly from within Excel.

[@VikasBille]

Could you please use a simple machine-learning model as an example to get familiarized with the features? This is life-changing for someone who cannot code as fluent as a software engineer but understands the code and data

[@GaborCsirke]

Thank you for video! It is very informative. One step for me! :)

[@emelel19]

Amazing! I learned today, love it! Looking forward to more tutorials in python using excel.. 😊

[@orangeklay]

You're a hero!!!! I learned a lot from you today.

[@dominicgentolia9259]

I am deaf and it would surely be amazing your posts be supported with transcripts. I really, really want to learn.

[@ChillborgRosa]

It has updated now.

[@krzysztofnosek5328]

I have Excel 2019, is it possible to use Python or is this presentation only for Excel 365? Alternatively, is there any official and safe plugin so that I can also use Python in my Excel?

[@holgerk.4650]

it seems to be not possible, for now it will work only in 365

[@kenkenwelch]

Thank you so much. Looking forward to them releasing to the public so I can play with it at work.

[@rafaelaraujo7127]

Amazing! Thanks for sharing! 😀

[@micheleduardoosorioherrera5751]

Sign up for the Microsoft insider program, restart the computer, it should be there after the restart. You may have to enable it in the add ins.

[@NagaPratapaReddy]

Very good tutorial ❤

[@TimmieTennis]

Thanks for the great intro, well done. Tim in San Diego

[@PyExcel-rq8qp]

Amazing! Great content for beginners!

[@shrirajdeshpande8125]

Gantt was best!!! Looking for more such videos.

[@douglasemsantos]

Great video! Looking forward for this feature to be GA

[@willfungusman8666]

Kevin will show us how his python excels!

[@grant178]

What?😂

[@ShawnFX]

Ayo? Which Python you talking about...😈

[@willfungusman8666]

@@ShawnFX well Kevin would say it's more like an anaconda

[@joshmorgantech]

​@@willfungusman8666😂😂😂

[@corlettw]

Awesome! I learned a ton from this video. Very easy to follow and very clearly explained. However, when I ask Bing Chat to create a Gantt Chart (and I typed it exactly as you have in the video) I produces different code and improperly creates the Gantt Chart. Is there a more consistent way to produce python code than an ever-changing AI service? Thanks again for the helpful guide

[@memolingvo5563]

How to install the Python libraries which are missing in the Python for Excel?

[@wah866sky7]

Thanks, I want to know which version of Excel directly supports the Python functions?

[@MichałG-k8n]

Kevin - both thumbs up! Great video, thx

[@infoseeker9151]

Thanks Kevin. Highly informative. I signed up but was placed on a waiting list with no ETA.

[@AI_Python_freak]

Keep up the amazing work

[@natidadon]

Great video. But as I see Python in Excel is not available yet. Am I wrong?

[@KevinStratvert]

It’s currently rolling out. Here’s the latest update from Microsoft on the roll out status: Python in Excel is now available to all Enterprise, Business, Education, and Family and Personal users running Beta Channel on Windows. This feature will roll out to Excel for Windows first, starting with build 16.0.16818.20000, and then to the other platforms at a later date.

[@mr.bananaman197]

hey, can you make a video on how to up the quality of the Xbox game bar and how to download NVİDİA?

[@jesus21282]

Loved it, now that Python on Excel went GA . Thanks!

[@MrStuartAllan]

Very interesting, especially the Gantt Chart example

[@whatisiswhatable]

Definitely not robust enough for most use-cases but has potential

[@SrikanthBoga]

Great Video, I am not able to expand the image generated by python. I do not see the icon to expand the image.

[@sigfigronath]

need an advanced python excel video kevin, looking forward to it ;)

[@BoNuSSoftware]

Which version of Excel must I have to use it ? My MS office prof 2021 doesn't seem to have the button ?

[@evaristeu]

Thank you for the lecture, but what about if they didn't give you coding and you have to build it by yourself?

[@ASHU-TOSHK.]

Hi Kevin, Is it possible to import private or authenticated Google sheets in excel, since Power Query in excel does not have any google sheet connector and it can only import public sheets. Do you have any workaround for this? Also thank you fir your videos on Power Query and Power Pivot, I was able to create some automated models at work. They saved hours :)

[@galitmilo.grafix]

Hi Kevin, do you have a video about Microsoft Copilot?

[@aYn_5Y]

I don't see python under formula tab

[@AndreAranha01]

Great. Thanks!! And how to activate Python in my excel?

[@StefanoVerugi]

thanks for the video surely Excel+Python is just at the beginning but, apart from some fancy chart, I don't see how this can be translated in the real world If you have a stand alone Excel file installing Python and Jupyter notebook takes no time and little skills, there you are free to work in a much more practical way, that can be exported to Excel if needed If instead you need to share your work with others...not so easy A good value of this I can think of it's a way for lots of people to gradually be introduced to Python, who eventually will migrate to Python for good 🙂

[@coreymorton6613]

Strongly disagree. Being able to easily build charts outside of the inbuilt Excel charts is a fantastic outcome on its own, as previously that required external plug-ins. But more importantly, being able to access Python's existing libraries is huge, as it allows you to access pre-built statistical functions that aren't in Excel. In the past you would have either had to write a monstrous formula, take the data out of excel for one task, or write your own implementation in VBA as a UDF (which would require saving as a macro enabled workbook). Now you can access these functions through Python. Manipulating and transforming data tables will also be much simpler with DataFrames and Pandas. Previously this would have required some combination of PowerQuery, array functions, intermediary calculations, VBA, and/or pivot tables. And to your own point, being able to share your work with others is a massive benefit. Most of the corporate world still runs on Excel, despite its many faults. Being able to do any of the above and send it to someone without having to worry about them having a Python install is amazing. Anyone in sales, HR, marketing, etc can open an Excel book; good luck getting them to run Python. This definitely isn't for everyone, and using Python+Jupyter will obviously always be more powerful, but this will very much be translated to the real world.

[@caty863]

I think this is the beginning. I have a feeling that more features will be added and we will reach a point where VBA in Excel is a thing of the past. This is fantastic for the user since Python skill is transferable. My reluctance to learn VBA is going to finally pay off!

[@aceofdatabase]

Liked, subscribed. 👌

[@jerrydellasala7643]

Would have been useful if you had provided the code for the Gantt Chart. I got a different response and the data is displayed in the reverse order you have, and the date is from 40 to 90 with other scientific notation.

[@Booyah]

Is Python in Excel still calculated Left to Right, Top to Bottom? I've seen this stated a few times, but if I assign a variable in B2, I can still access that variable in A1. Am I misunderstanding how this works, or was the calculation method changed from left to right, top to bottom?

[@MathesonMykal]

I currently use excel (VBA and analytics) for analyzing industrial data. It currently sits behind firewalls …. By running the same analysis using python.. on the cloud, how can I be assured that all our sensitive data (and analysis) is not being see/sold to competitors?

[@danbromberg]

How about a video on how to install Python into Excel? My Excel 2016 doesn't have it so how can I update it so the Python icon appears in the FORMULA tab.

[@mohamoudmohamoud9040]

Can you make a video about exporting Excel infographic charts to video file, so we might include animated charts in videos.

[@cristtos]

@KevinStratvert Hi there, when checking how Python is executed Microsoft says: "You type Python directly into a cell, the Python calculations run in the Microsoft cloud, and your results are returned to the worksheet". Are there privacy concerns regarding my data being "calculated" in the vague microsoft cloud? Thank you.

[@dominicgentolia9259]

Kevin, how do text TRUE and FALSE get to the formula bar?

[@Sancarn]

3:50 since when was installation a requirement for python? You could compile python to a dll and include it in excel.exe, or as an xll addin, or compile python to wasm and execute from a wasm engine [e.g. Pyodide] (either on-prem or in the browser for web excel) Ultimately installation is absolutely not the reason I'm sure, it's because either they are stealing your data or they want to make this a subscription model where you pay for server time. 6:00 thanks for including this, most previews didn't include this critical understanding. Is there one python runtime per workbook? Or does it evaluate from the first workbook opened to the last within the same runtime? It would be interesting to know what ActiveX implementations there is for working with python in Excel.

[@Sancarn]

@@Suto_Ko This looks like a direct copy pasta from chatGPT? Microsoft could integrate Python DLL into Excel. Whether these are widely supported or not is irrelevant. And Excel isn't doing installation of python AT ALL, so idk why that is at all in this comment...

[@lt4376]

Is the run speed any different?

[@hubertmallard7254]

How to use the LET Excel function and Python, example "=PY(4+2)" ok it works. How to have the same result with "=LET(x:PY(4+2),x)"

[@Jguthro]

So you dont need the function name? For example print()

[@segunharuna]

I use excel version 2016 but I can't see python in the formula Tab.

[@leeblack2103]

It is only for Excel 360 😞. The video author failed to disclose this important bit of info

[@johnnydepp4114]

so all the code including data you use in the python script will go to microsoft ? i find that concerning if you handle confidential data

[@oso1248]

All that would be really cool if you could run it locally, in the background and have a file structure… just make python available in the VBA editor. I can 1000x more in the editor than can be done with cells, just imagine python in editor.

[@HarryHarshaw]

On a project that relies on use of tables and headers. Using Python I get errors for cannot find header. I have a header in excel using a table. I selected options table has header. Why would an error be thrown when I have a header ? If you are able to let me know what to do or maybe assist me in this error.

[@edson_winner]

Man, thanks

[@suhailanjumabdurraheemsayy7639]

Is it available for ms office 2019?

[@KevinStratvert]

You’ll need Microsoft 365. It’s currently rolling out to Microsoft 365. Here’s the latest update from Microsoft on the roll out status: Python in Excel is now available to all Enterprise, Business, Education, and Family and Personal users running Beta Channel on Windows. This feature will roll out to Excel for Windows first, starting with build 16.0.16818.20000, and then to the other platforms at a later date. To get it now, you can join the Microsoft 365 beta channel directly from within Excel.

[@suhailanjumabdurraheemsayy7639]

@KevinStratvert Thanks, Kevin 😊 ! Your videos are really very much helpful!

[@emc3000]

Very eager to see Kevin's python today 😏😘

[@samsonadeyemi160]

Thanks Kevin

[@peterlarsen4809]

I currently use a windows machine, but am thinking about switching to a MacBook. My fear as that some significant features of excel will be missing.

[@gurucharan5707]

why am I not able to see the python option in excel? And how do I enable that option? Kevin this time didn't cover this topic unfortunately, not usually like him!

[@neerajkapoor1050]

simpler cleaner use cases of python within excel

[@lbby3162]

Hey man, Im doing some excel copying and pasting to another but when i try to paste dates it doesnt show up like "dd-mm-yyyy" its like "yyyy-mm-dd 00:00:00" any help?

[@Letslearntogetheruzh7]

1:27 2:01 2:31 3:08 4:01

[@ousmanelom6274]

Thank best tuto

[@Transuran]

Can someone please tell me why I can`t find the "insert Python" option in formulas? I`m using this paid version of Microsoft 365. Do I have to update anything there? Shouldn`t that be automatically always be the new version or what am I doing wrong?

[@hydrogennetwork]

hey there, i trying to figure out how to setup docusaurus by facebook. Can you make a video on how? PS. my spelling for docusaursus is not good🤣

[@leeblack2103]

It is only for Excel 360 😞. This bit of info was failed to be disclosed.

[@HimanshuPakhale-n3i]

integration of python and copilot in excel changes all the traditional ways. no place for hardwork now. just put the commands and understand how it is done?

[@melodypeng3592]

Amazing

[@dimknaf]

I receive connection errors when I am trying to connect to localhost with Flowise or Local LLM APIs. In Python it's ok, but with excel it's not. Any thoughts?

[@marialauramolina4534]

Muy bueno

[@SimonAdansi]

show as how to download the new version of microsoft office 2023

[@makingsensewithsteve3620]

Did you ever work with 1-2-3? Excel is so far behind. Back around 2000 using Lotus Script (built in to Lotus Suite) you had complete manipulation without having to place code into the cells. In Approach I was communicating with outside servers and populating data.

[@bananaapple9698]

Can I use python in excel Mac version ?

[@danchuzhov6445]

Do I need to install some extension to get Python inside Excel? Now I don't have it

[@Suto_Ko]

No, you don't need to install any extension to get Python inside Excel. It is now available as a built-in feature in Microsoft Office 365.

[@NyphronRising]

i find it very slow when working on larger tables say 100 rows

[@haqminhas6358]

Python is not supported on Mac even on office 365. How can we use it on Mac

[@aashishkatyal]

I am not able to see the Insert Python option in the Formulas

[@KevinStratvert]

It’s currently rolling out. Here’s the latest update from Microsoft on the roll out status: Python in Excel is now available to all Enterprise, Business, Education, and Family and Personal users running Beta Channel on Windows. This feature will roll out to Excel for Windows first, starting with build 16.0.16818.20000, and then to the other platforms at a later date. To get it now, you can join the Microsoft 365 beta channel directly from within Excel.

[@aashishkatyal]

@@KevinStratvert Thank you for your response. But I have checked my updates in Microsoft Excel, and it is up to date, and I have not found any Join Microsoft 365 beta channel option. Can you make a separate video for that? or suggest another option. The current version of my Excel is Version 2308 Build 16.0.16731.20182

[@KevinStratvert]

@@aashishkatyal Check out the following article: insider.microsoft365.com/en-us/join/windows

[@aashishkatyal]

@@KevinStratvert Yes I have checked it, but in my Microsoft account Microsoft 365 Insider button is not coming

[@christerolofsson2038]

this do not work at all for me. I have a PC with Windows 10 an d one with Windows 11 and both and everything is updated. None of the suggested way to start Python in Exel works. I get no Python to start in Exel in none of the PC´s. I live in Sweden. is that the cause of the problem ?

[@trident1000y]

Is this still a beta version? I cannot access Python and everything I see online says you must be in the early adopter program.

[@bendiknyheim6936]

What happens if I share this workbook with someone that does not have the feature yet?

[@Suto_Ko]

Sharing an Excel workbook with someone who doesn't have the feature yet may limit their ability to access and edit the workbook's advanced features. It's best to ensure that all participants have the necessary features enabled for a smooth collaboration experience.

[@Randomuser11231]

I am just confused If the size of your dataset is not beyond Excel's capability, why use Python?

[@usamaaslam940]

Which Microsoft ofc version contains python?

[@Suto_Ko]

The Microsoft Office version that contains Python is Microsoft Office 365.

[@angelinajoy3084]

You can just make sum and done! 😉

[@Aviaguy_gar411]

Guys, what is it version of Excel?

[@Butchy-t6u]

Kevin , could you please direct me to a FREE SIMPLE IMAGE EDITOR that will help me see objects ( cars , vehicles ) in water ? I am enjoying trying to find missing people who end up slipping into water ( ponds , rivers , streams , etc ) . . all over the country and it is very rewarding . Have downloaded a few image editors but there are too many controls with strange names I do not understand and it is an awful experience . Thank you .