Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ Learn the fundamentals of Python in just one hour: kzitem.info/news/bejne/w2ZvmZWneoyag4osi=Rv1r2vAqBnsQfPWO Watch even more free Excel tutorials: kzitem.info/door/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
@Fredjoe5
9 ай бұрын
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
6 ай бұрын
Same with my companies excel 2023
@hlangananimdibi4670
3 ай бұрын
Thank you brother. You're helping me prepare for a post-interview assessment. God bless you.
@SamirHabib
4 ай бұрын
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!
@napsec9807
9 ай бұрын
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
11 ай бұрын
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
11 ай бұрын
Absolutely brilliant way of navigating through excel using Python,you've made it so easy to understand, good job Kevin😊,Dubai
@dianadiazak8342
11 ай бұрын
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 🙏🏽🥺
@user-qv6eu1qi7w
11 ай бұрын
I can believe it what!!!!! Python in Excel !!! !!! 🥰😍😄😆🤣😂🙂😋😛 ... I' m sooooo excited
@ahmedskullab
11 ай бұрын
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.
@Alban.Bytyqi
11 ай бұрын
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
9 ай бұрын
Same problem here.
@erikpaterson1404
9 ай бұрын
I'm guessing you might need to use the online version of excel (?)
@grr82
8 ай бұрын
Sign up for beta channel. Restart the computer. Worked for me.
@MNovakMNovak
8 ай бұрын
You need to sign up to the Microsoft insider program to have access to it
@pjohn1435
11 ай бұрын
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
11 ай бұрын
same
@guolunli1908
10 ай бұрын
same
@TheEJonesve
11 ай бұрын
Can you explain how to activate the Python feature in Excel? What are the requirements?
@KevinStratvert
11 ай бұрын
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.
@micheleduardoosorioherrera5751
23 күн бұрын
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.
@superspak
10 ай бұрын
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 😁
@user-bq5jp4me4x
11 ай бұрын
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
@krzysztofnosek5328
10 ай бұрын
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
8 ай бұрын
it seems to be not possible, for now it will work only in 365
@willfungusman8666
11 ай бұрын
Kevin will show us how his python excels!
@grant178
11 ай бұрын
What?😂
@ShawnFX
11 ай бұрын
Ayo? Which Python you talking about...😈
@willfungusman8666
11 ай бұрын
@@ShawnFX well Kevin would say it's more like an anaconda
@joshmorgantech
11 ай бұрын
@@willfungusman8666😂😂😂
@rafaelaraujo7127
11 ай бұрын
Amazing! Thanks for sharing! 😀
@emelel19
11 ай бұрын
Amazing! I learned today, love it! Looking forward to more tutorials in python using excel.. 😊
@aYn_5Y
11 ай бұрын
I don't see python under formula tab
@edsonwinnerify
11 ай бұрын
Man, thanks
@douglasemsantos
6 ай бұрын
Great video! Looking forward for this feature to be GA
@user-sn1vx3vr1y
11 ай бұрын
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!
@kenkenwelch
11 ай бұрын
Thank you so much. Looking forward to them releasing to the public so I can play with it at work.
@natidadon
11 ай бұрын
Great video. But as I see Python in Excel is not available yet. Am I wrong?
@KevinStratvert
11 ай бұрын
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.
@orangeklay
9 ай бұрын
You're a hero!!!! I learned a lot from you today.
@user-uz8nr8mc1n
11 ай бұрын
Kevin - both thumbs up! Great video, thx
@tanjiaqi7840
11 ай бұрын
Awesome 🎉🎉🎉 I can't spell my gratitude toward you man. You are the hero of my day.
@TimmieTennis
6 ай бұрын
Thanks for the great intro, well done. Tim in San Diego
@dominicgentolia9259
9 ай бұрын
I am deaf and it would surely be amazing your posts be supported with transcripts. I really, really want to learn.
@shrirajdeshpande8125
11 ай бұрын
Gantt was best!!! Looking for more such videos.
@MrStuartAllan
11 ай бұрын
Very interesting, especially the Gantt Chart example
@whatisiswhatable
9 ай бұрын
Definitely not robust enough for most use-cases but has potential
@sigfigronath
11 ай бұрын
need an advanced python excel video kevin, looking forward to it ;)
@mr.bananaman197
11 ай бұрын
hey, can you make a video on how to up the quality of the Xbox game bar and how to download NVİDİA?
@infoseeker9151
11 ай бұрын
Thanks Kevin. Highly informative. I signed up but was placed on a waiting list with no ETA.
@PyExcel-rq8qp
11 ай бұрын
Amazing! Great content for beginners!
@SrikanthBoga
11 ай бұрын
Great Video, I am not able to expand the image generated by python. I do not see the icon to expand the image.
@AI_Python_freak
11 ай бұрын
Keep up the amazing work
@StefanoVerugi
11 ай бұрын
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
11 ай бұрын
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
11 ай бұрын
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!
@segunharuna
11 ай бұрын
I use excel version 2016 but I can't see python in the formula Tab.
@leeblack2103
11 ай бұрын
It is only for Excel 360 😞. The video author failed to disclose this important bit of info
@jerrydellasala7643
11 ай бұрын
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.
@gurucharan5707
9 ай бұрын
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!
@oso1248
11 ай бұрын
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.
@ASHU-TOSHK.
5 ай бұрын
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 :)
@memolingvo5563
6 ай бұрын
How to install the Python libraries which are missing in the Python for Excel?
@wah866sky7
6 ай бұрын
Thanks, I want to know which version of Excel directly supports the Python functions?
@AndreAranha01
2 ай бұрын
Great. Thanks!! And how to activate Python in my excel?
@marialauramolina4534
27 күн бұрын
Muy bueno
@samsonadeyemi160
11 ай бұрын
Thanks Kevin
@user-qv6eu1qi7w
11 ай бұрын
show as how to download the new version of microsoft office 2023
@mohamoudmohamoud9040
11 ай бұрын
Can you make a video about exporting Excel infographic charts to video file, so we might include animated charts in videos.
@hubertmallard7254
11 ай бұрын
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)"
@ousmanelom6274
11 ай бұрын
Thank best tuto
@galitmilo.grafix
11 ай бұрын
Hi Kevin, do you have a video about Microsoft Copilot?
@MathesonMykal
10 ай бұрын
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?
@aceofdatabase
7 ай бұрын
Liked, subscribed. 👌
@Sancarn
11 ай бұрын
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
11 ай бұрын
@@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
3 ай бұрын
Is the run speed any different?
@emc3000
11 ай бұрын
Very eager to see Kevin's python today 😏😘
@melodypeng3592
11 ай бұрын
Amazing
@danbromberg
7 ай бұрын
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.
@HarryHarshaw
4 ай бұрын
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.
@makingsensewithsteve3620
11 ай бұрын
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.
@dominicgentolia9259
9 ай бұрын
Kevin, how do text TRUE and FALSE get to the formula bar?
@MrXceller
11 ай бұрын
what version of Excel comes with Python?
@garydunken7934
11 ай бұрын
Microsoft365. Currently only available for beta testers. But I guess it won't be too long before production release.
@johnnydepp4114
7 ай бұрын
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
@Transuran
5 ай бұрын
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?
@lbby3162
4 ай бұрын
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?
@peterlarsen4809
10 ай бұрын
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.
@Letslearntogetheruzh7
26 күн бұрын
1:27 2:01 2:31 3:08 4:01
@dimknaf
8 ай бұрын
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?
@leeblack2103
11 ай бұрын
It is only for Excel 360 😞. This bit of info was failed to be disclosed.
@mairathorn3331
11 ай бұрын
Absolutely complicated.
@christerolofsson2038
8 ай бұрын
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 ?
@Grafic.mat-geo
4 ай бұрын
Guys, what is it version of Excel?
@suhailanjumabdurraheemsayy7639
11 ай бұрын
Is it available for ms office 2019?
@KevinStratvert
11 ай бұрын
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
11 ай бұрын
@KevinStratvert Thanks, Kevin 😊 ! Your videos are really very much helpful!
@CheatingStoriesWithChinwe
11 ай бұрын
💕 from here
@bananaapple9698
7 ай бұрын
Can I use python in excel Mac version ?
@hydrogennetwork
11 ай бұрын
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🤣
@Randomuser11231
10 ай бұрын
I am just confused If the size of your dataset is not beyond Excel's capability, why use Python?
@trident1000y
9 ай бұрын
Is this still a beta version? I cannot access Python and everything I see online says you must be in the early adopter program.
@user-ex5ez2uo7q
11 ай бұрын
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 .
@aashishkatyal
11 ай бұрын
I am not able to see the Insert Python option in the Formulas
@KevinStratvert
11 ай бұрын
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
11 ай бұрын
@@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
11 ай бұрын
@@aashishkatyal Check out the following article: insider.microsoft365.com/en-us/join/windows
@aashishkatyal
11 ай бұрын
@@KevinStratvert Yes I have checked it, but in my Microsoft account Microsoft 365 Insider button is not coming
@danchuzhov6445
11 ай бұрын
Do I need to install some extension to get Python inside Excel? Now I don't have it
@Suto_Ko
11 ай бұрын
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.
@bendiknyheim6936
11 ай бұрын
What happens if I share this workbook with someone that does not have the feature yet?
@Suto_Ko
11 ай бұрын
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.
@suparnachatterjee4651
11 ай бұрын
I need python in advance... Like create a project using database or create a game for children.... Thank you
@nanaakwasiopokuaboagye6751
11 ай бұрын
I think l am kinda bored with windows, but can you introduce Linux
@vbombos
19 күн бұрын
Online only..."you might think this is a disadvantage"...oh no...actually this is a deal breaker.
@OZTutoh
Ай бұрын
**googles "python to excel tutorial no AI"**
@usamaaslam940
11 ай бұрын
Which Microsoft ofc version contains python?
@Suto_Ko
11 ай бұрын
The Microsoft Office version that contains Python is Microsoft Office 365.
@caty863
11 ай бұрын
There is absolutely no scenario where running the interpreter on MSFT servers is a good thing for the user. It just gives the company control over the user and is nightmare for privacy. Besides, not everybody is always connected to internet and, for me who lives in Africa where data is prohibitively expensive, the cost of internet connection will add up.
@anasadel
11 ай бұрын
Love your work … but so far all examples can be done without python …. Last time I did coding was in 1999 and it was in C . I’m still trying to find a reason to learn Python
@tmb8807
11 ай бұрын
I have been experimenting a bit with this and I think for it to be truly useful you either need to have a more esoteric requirement for visualisation, or just absolutely enormous data. There are obviously things Python can do that Excel can't. But specifically within Excel, I'm not sure what the practical applications are besides the above (which is not to say that there aren't any applications at all - just that a notebook might be a better environment for those things). I also haven’t been able to find a way to actually get external data using this - still dependent on Power Query or other existing connectors. One good thing is that you can read directly from queries without loading them to a worksheet, so you could potentially work with larger datasets that way. Not sure how performance compares to just using Power Pivot in that scenario, though. All of this is probably going to be moot for me anyway since it seems Microsoft will charge a subscription to use Python in Excel when it reaches gold.
@Moshie71
7 ай бұрын
Why are non of you KZitem content creators mentioning The Insider Program?
@charmaineh1239
11 ай бұрын
Am I the only one who's unable to see some of the data because of the caption? I don't see the option to turn it off.
@KevinStratvert
11 ай бұрын
My bad! Will make sure to position the screen so it doesn't interfere with the captions in the future. You can turn captions on/off with the CC icon.
@judahneuhoff9151
11 ай бұрын
I can't access python in my excel
@benjamintownes6122
11 ай бұрын
Let us try Java script
@andresa5781
6 ай бұрын
Why this video is dubbed in spanish?
@Grafic.mat-geo
4 ай бұрын
Guys, what is it
@ashoknathtripathi
11 ай бұрын
NO INFORMATION FOR MULTIPLE PAGES FILES OR BOOK. ONLY BASIC INFORMATION HAS BEEN GIVEN.
Пікірлер: 142