Тёмный

How to use Python in Excel - Demo + My Review 

Chandoo
Подписаться 651 тыс.
Просмотров 99 тыс.
50% 1

Опубликовано:

 

13 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 142   
@chandoo_
@chandoo_ Год назад
💥 Get my FREE Python for Excel book 👉 chandoo.org/wp/download-free-python-for-excel-book/
@stopthink9000
@stopthink9000 Год назад
Chandoo, you have THE BEST Excel channel on RU-vid!! So clearly explained, no marketing fluff, real world point of views. So rare these days and immensely valuable!! Keep up the awesome work!!
@pravinshingadia7337
@pravinshingadia7337 Год назад
Your videos are brilliant Chandoo. You take time to explain both the good and bad of any new introductions and agree that this adds new level of complexity above learning all the other features.
@chandoo_
@chandoo_ Год назад
Thanks for these lovely words :)
@pup1407
@pup1407 Год назад
I learnt Excel from you back in 2010. Your passion for this is still the same. More respect and power to you Chandoo Sir !
@chandoo_
@chandoo_ Год назад
Wow.. always a pleasure to (re)connect with long-time fans such as yourself. More power to you ⚡
@alaneloff9693
@alaneloff9693 11 месяцев назад
Same here. Got almost all my excel and data skills from him
@aiasaiascon3894
@aiasaiascon3894 Год назад
One of the most Honest and Valuable review and opinion on the new features of Excel, because not everything that shines, is gold !
@yupingsun40
@yupingsun40 26 дней назад
the good thing about python in excel is some complicated calculations can be done inside excel with the help of python. A lot of people still like the interface excel provides for data and visualization.
@venkatatalatam3740
@venkatatalatam3740 Год назад
Thanks you! you've made complex tasks feel accessible! Mr. Chandoo
@Danny-ex3tj
@Danny-ex3tj Год назад
8:10 Right click on the image > Picture in Cell > Create Reference Alternative way instead of merging, Also...incase you need to paste into another sheet
@piyushnautiyal6271
@piyushnautiyal6271 Год назад
Very excited to use python in Excel.. thanks chandoo for the amazing video lecture on this topic 👍👍
@davidfelipepenaguardiola1177
Thanks so much for this absolutely usefull video, Mr. Chandoo
@tw9535
@tw9535 Год назад
Wow. 1. Cloud based only 1a. Slow 1b. Nothing is private 2. Subscription based pricing 3. Not the full power of Python ecosystem Python, running on your local machine and at full strength, can already get access to that local data and via installed libraries already do all of the data analysis and reporting. And more. At full strength. Locally. For free. Excel or Libreoffice. Microsoft is so lucky so many people are dependent on Excel, for whatever reasons. The only advantage to this is letting Microsoft deal with keeping Python and third-parties up to date with no version conflicts. That is certainly worth _something_ , but not even close to balancing out the negatives. Thank you for this great video! Excellent presentation. Subscribed.
@allanmachado2011
@allanmachado2011 11 месяцев назад
Thank you. I think you saved me a lot of time. I've been trying to decide on the right language to build myself some tools for work. I've been using Power Query M, but it hasn't been the right fit for the job. The tools need to be portable and M hasn't been great for that. The tools also need input from the user depending on what is in the data. There are several other challenges I found with using M for my tools. I know I could build my tools in VBA and it would resolve the challenges I faced in M, but I didn't want to build my tools in a dying language if there's a better new way. I thought Python in Excel might be the way or maybe the Javascript library, but ultimately it seems VBA will still be the answer (weather it's dying or not). Seeing this video was the tipping point on the decision. I'm glad I didn't put hours into exploring Python in Excel at this stage. Thanks again.
@IoannisStoupis
@IoannisStoupis 11 месяцев назад
Thank you Chandoo! I always follow your videos and I want to say that you are amongst the best instructors for Excel and beyond.
@chandoo_
@chandoo_ 11 месяцев назад
You are most welcome
@TomlynAdvisors
@TomlynAdvisors Год назад
Would be good to first being with a high level overview of what python is and the benefits of using it. This way it will make better sense for students to follow, rationalize, and understand the video.
@chandoo_
@chandoo_ Год назад
Thanks for the suggestion @Tomlyn... I do have a detailed Python video to help you with this. See ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uoC48wrJ-yM.html
@LiyakatLal
@LiyakatLal 8 месяцев назад
Lovely! seeing chandoo in years and he is awesome as always.
@maheshsonwane8614
@maheshsonwane8614 Год назад
Thank you! Your content is very useful, as always
@dheerajpatel5906
@dheerajpatel5906 Год назад
Thankyou Chandoo for the amazing information. Helping a lot of people like me in our daily tasks.❤
@chandoo_
@chandoo_ Год назад
My pleasure 😊
@sairamadaboina8257
@sairamadaboina8257 8 месяцев назад
Thank you Sir, your explanation was very effective, please upload more and more new trending courses.
@barttitulaerexcelbart9400
@barttitulaerexcelbart9400 Год назад
Thanks Chandoo, I saw a few video's about the new Python, but you were also giving con's. That is very good! Sometimes we do not realize how much the scope of Excel has widened. see min 12.30. Very good video!!
@chandoo_
@chandoo_ Год назад
Glad it was helpful!
@mssankararaman
@mssankararaman Год назад
Brilliant Chandoo. Thank you! Covers all aspects an enthusiast would love to know. Big fan btw.
@dereksmith5934
@dereksmith5934 11 месяцев назад
The key advantage for me as someone who switches between excel and Python/Pandas, is that sometimes I don't know where I want to go with my data. Being able to create intermediate dataframes and see them in excel, before having that lightbulb moment, is something that I struggle with when working in VSCode. Holding a many step dataframe sequence in your head as you work towards a solution is tough. This may be a good way to deal with that. I look forward to trying it out. Nice video.
@soliver111
@soliver111 4 месяца назад
Very impressive support material. Thank you
@chrism9037
@chrism9037 Год назад
Thanks Chandoo! Looking forward to experimenting with Python.
@chandoo_
@chandoo_ Год назад
All the best Chris. Do let us know how your Python experiments are going.
@TwinAna
@TwinAna Год назад
Wow! Enlightened! thank you so much chandoo....🤗
@spilledgraphics
@spilledgraphics Год назад
added to the playlist, yes!!!
@vaibhavshinde6419
@vaibhavshinde6419 11 месяцев назад
This is going to be a game changer for Traders.... Unbelievable algos can be written now...
@CaSh-DriVeGame
@CaSh-DriVeGame 11 месяцев назад
Chandoo hope you are doing well. I just want to inform you that you are one the best teachers. Oh i almost forgot to mention that you are funny and that spices up.
@chandoo_
@chandoo_ 11 месяцев назад
😍 Thanks for that lovely message.
@rikmoran3963
@rikmoran3963 Год назад
As someone who plays around with Python I was excited to see it coming to Excel. However, seeing the whole Microsoft Cloud requirement is a real disappointment. Having people temporarily without Internet access not able to look at their spreadsheets is unacceptable. It's frustrating when you consider that Python is free and you can run it on pretty much any platform, but Microsoft (of whom I am usually a big fan) have decide to implement it in a less than satisfactory way, just so that they can monetize it! You're the first person I have seen cover this topic and include the downsides. And for that, you have earnt a subscription! Thank you.
@iankr
@iankr 11 месяцев назад
Many thanks for this informative video, Chandoo. Very clearly explained.
@shrirams3442
@shrirams3442 Месяц назад
03:55 timeframe , my roommate was checking with me whether i am studying or watching something else 😂
@sundertalreja7208
@sundertalreja7208 Год назад
Happy Teacher's day, your learning have helped me grow immensely. 🙏
@caissa6187
@caissa6187 Год назад
Thanks so much!! Really appreciate the video and the free pdf. 😊😊
@fokhrulislam2633
@fokhrulislam2633 Год назад
Thank you for such an honest review. I totally agree with you.
@Jamesmichael312
@Jamesmichael312 Год назад
Thank you so much. Happy teacher's day.. 🙏🙏
@arbazahmad7177
@arbazahmad7177 Год назад
Appreciate 🎉 Chandoo... excellent explanation about python....
@JavedAnsari-vba
@JavedAnsari-vba 9 месяцев назад
Thanks Sir, it is one great helpful video
@bc4198
@bc4198 Год назад
Bahaha I was just clicking like at the exact moment your rubber ducky first squeaked, and for a moment I thought RU-vid had sound effects 😂
@chandoo_
@chandoo_ Год назад
That is GREAT :)
@canirmalchoudhary8173
@canirmalchoudhary8173 Год назад
I did not even adapted to office script because we want dynamic automation not absolute automation. So there will be some excel feature will be underutilized. Because I see people are still new to Power Query even after 12 years of implementation. But yeah I am happy that you started to lean python in very recent past.
@keithmason1485
@keithmason1485 Год назад
Would love it if you could detach the formula bar. Considering how many lines can be in python code that would be really helpful.
@deinbleiz
@deinbleiz 11 месяцев назад
Great video as always!
@PhatTony
@PhatTony Год назад
Will Python overtake VBA at all? What I mean is do you think they will remove VBA at some point??
@stanislasgrare5046
@stanislasgrare5046 Год назад
absolutely two different things. python is for data science. vba can do wayyyy more things ( access to all office apps, can send email print things, use events etc) .
@abdifatahwebdeveloper117
@abdifatahwebdeveloper117 Год назад
hi sir I'm using microsoft2016 i don't see any python in formulas button what is wrong with it thanks
@mehtasanto
@mehtasanto 5 месяцев назад
Very nice content!! But I'm not able to enable python in Excel 365. In fact there is no inbuilt add-in given.
@menggambarsenyum
@menggambarsenyum Год назад
i hope microsoft update the vba , just add some input type like html and it will be great
@drashar841
@drashar841 Год назад
Hi Chandoo! All your tutorials are excellent! Can you make another video about extracting data from websites and ti upload in excel. Thanks.
@chandoo_
@chandoo_ Год назад
You are welcome. I have a few on webscraping. Check this playlist - ru-vid.com/group/PLmejDGrsgFyCPqKERr-anrRZAdeKYhoxZ
@joseescobar9031
@joseescobar9031 Год назад
Thankyou Mr. Chandoo.
@yuruaribondanese8743
@yuruaribondanese8743 Год назад
Thanks again professor. Good to know that.
@unnikrishnansanthosh
@unnikrishnansanthosh Год назад
well explained, especially the good and bad ones
@jagatkrishna1543
@jagatkrishna1543 Год назад
Thanks 🙏❤
@chandoo_
@chandoo_ Год назад
You're welcome 😊
@minecraftmike5193
@minecraftmike5193 Год назад
I haven't seen its benefits yet. People praise it, but everything in the video seems doable in Excel, and more simply.
@chandoo_
@chandoo_ Год назад
The marketing hype is too rose tinted. While this is an exciting turn of events, I am not sure it will catch on so wildly with the way they implemented it.
@Michael-iw3ek
@Michael-iw3ek Год назад
they're getting rid of vba??? this might finally motivate me to learn python
@chandoo_
@chandoo_ Год назад
They are not. VBA is here and probably will be for a LOONG time to come.
@umairkolsawala2370
@umairkolsawala2370 Год назад
Sir for Data analysis we should learn python language? Or excel,Power BI, Tableau and SQL is enough... to manage a data?
@GroovVictim
@GroovVictim Год назад
Please let me know when u find out. I'm also curious
@DarkoVlajkovic
@DarkoVlajkovic 11 месяцев назад
Im struggling to find advantage of Python in Excel...With formulas, pivots, queries, dax, vba...Maybe there is some specialty in 3% of the time that i might use Python in Excel but im trying to figure out for an average analyst what are the benefits...
@akibul_islam
@akibul_islam Год назад
the python is shown in the formula tab but it is not working in my excel. why?
@snackplaylove
@snackplaylove Год назад
13:00 should give you all the info
@kristopherambrose4748
@kristopherambrose4748 Год назад
Дякую за ваші відео.)
@andrewdove342
@andrewdove342 Год назад
Thanks Chandoo
@tomekja3034
@tomekja3034 Год назад
Biggest pain in ass is that you still have to open excel files. Normally if i want to use python to analyze data, i want it because of i have 20 files with 1000000 rows and it just lags, python in excel doesn't help here
@chandoo_
@chandoo_ Год назад
Of course that is always there. That is why this implementation of Python is not "full" Python.
@dv7299
@dv7299 Год назад
Amazing video ❤
@wardellcastles
@wardellcastles 10 месяцев назад
Can Python running in the cloud read and write to the local machine?
@taizoondean689
@taizoondean689 Год назад
Thank You Sir, please create videos on DAX Language....few more and Happy Teacher's day
@keeniejelcabahug7151
@keeniejelcabahug7151 Год назад
Well said. I'm excited to learn this, but that is me being a forever student. However, being able to run if offline is not an option atm. Nonetheless, what do we know about what's to happen in the next months or years, right?
@chandoo_
@chandoo_ Год назад
That is right. Hopefully, we will have an option to switch run-time to local Python instance.
@shinlanten
@shinlanten Год назад
Curious when or even IF R (aka Posit 😩) will be coming to Excel
@Apun_hi_bhagvan_hai
@Apun_hi_bhagvan_hai Год назад
Please make a large video on SQL
@chandoo_
@chandoo_ Год назад
I did.. see here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l8DCPaHc5TQ.html
@anupshastry5969
@anupshastry5969 Год назад
Hi sir do data analyst require knowledge of Linux will they ask any question from Linux during interview .Or is it good to have Linux understanding for this data profiles please suggest me ?
@DarsviniMuniandy
@DarsviniMuniandy 6 месяцев назад
how to enable python in microsoft excel i am using microsoft excel 365
@rishisharma9256
@rishisharma9256 Год назад
What about Google Sheet, can we automate the process in it ? Is it more approachable?
@vishal958
@vishal958 Год назад
saw this last week in Kenji Explains
@peterlarsen4809
@peterlarsen4809 11 месяцев назад
Chandoo will there any data analysis tools that are lost if I made a switch to MacOS
@thasneemmuthalib4003
@thasneemmuthalib4003 Год назад
Thanks for this informative video. im a getting a '#PYTHON!' error. It is an 'unexpected failure'. Does anyone know how to resolve it ?
@dard4642
@dard4642 Год назад
One of my favorite things about using Python is NOT having to open Excel. That said, my work is paying for me to take Anaconda's 10-hr, "Python in Excel" workshop. I'm hopeful that the integration will just get better from here.
@Driving4bangers
@Driving4bangers Год назад
Since Xlookup you should say
@vishalyadav630
@vishalyadav630 Год назад
How to master in excel as beginner
@sammayekar2972
@sammayekar2972 Год назад
Woah 😮 super super ✨
@amitkumarsingh4489
@amitkumarsingh4489 11 месяцев назад
what problem does python in excel solve ? i mean why do this in the first place ? please share your thoughts here or any other video ...thanks
@toulasantha
@toulasantha Год назад
Machine learning in Excel?
@INhumanLAST
@INhumanLAST Год назад
If only excel 365 were not so slow already, I am afraid it will be more heavy
@mamalik1088
@mamalik1088 Год назад
Nice again SIR
@moutazeldeib9481
@moutazeldeib9481 Год назад
I can not find Python even as a formula in Excel 365?
@keylanoslokj1806
@keylanoslokj1806 Год назад
Its available only on a special online service of 365
@JoeG2324
@JoeG2324 Год назад
does code completion work with python in excel?
@canirmalchoudhary8173
@canirmalchoudhary8173 Год назад
This video is quite informative and it's very interesting to know that it uses internet connectivity which undermines the excel calculation capabilities because people still faces some glitches when they work on auto save enabled file. But yeah it's good that Microsoft is adopting new language, God knows we may get tableu also in future
@chandoo_
@chandoo_ Год назад
hmm.. not so sure about Tableau in Excel (unless MSFT buys out Salesforce)
@Tony_Montana659
@Tony_Montana659 Год назад
Great.
@bhushansangle9425
@bhushansangle9425 Год назад
Interesting 😎
@myopinionlaxmamma
@myopinionlaxmamma Год назад
Ok anna😊
@sakibzamanmohammad8895
@sakibzamanmohammad8895 Год назад
Can I use python to fetch the data from my company's MIS portal and use it to link it with powerpivot.
@chandoo_
@chandoo_ Год назад
You can use Power Query to "fetch" the data and then use Python to analyze. As of now Excel Python can't access any data that is not already in Excel (either physically or in Power Query).
@irf7aan
@irf7aan Год назад
Why the resource site is not opening ??
@chandoo_
@chandoo_ Год назад
Try again.. my site was probably too busy.
@milindkapadia1425
@milindkapadia1425 Год назад
Hi. Chandoo. You forgot to explain how to activate Python in excel.
@chandoo_
@chandoo_ Год назад
I did mention how to get it. You need to join the beta / insider program and update your office. See this article for more information - chandoo.org/wp/introduction-to-python-in-excel/
@keylanoslokj1806
@keylanoslokj1806 Год назад
​@@chandoo_does it cost extra money
@TheFlounderPounder
@TheFlounderPounder 11 месяцев назад
Microsoft (Like Autocad) Devs think in a very old way of developing. You would think there would be easier steps to uh…make a line or a circle. Some people know how to keep their jobs and manipulate the people paying them. 😅
@faruksedef
@faruksedef Год назад
07:10 Dial-Up Sound affect is bigger than Excel and Python 😂
@chandoo_
@chandoo_ Год назад
😂 Couldn't resist as I grew up with that.
@drkesavsarma_singer
@drkesavsarma_singer Год назад
Python raani vallu em cheyali sir mari...
@chandoo_
@chandoo_ Год назад
You can learn it, you can ignore it, you can use something else you already know. They are not replacing anything in Excel with Python. They are just adding the feature.
@surajD21
@surajD21 Год назад
The day is not far when we will only give command and everything will be on your fingertips...! Just like that😅
@Innosos
@Innosos 10 месяцев назад
Online connection required? Well, that just made this feature utterly useless - I'd rather run python and load the excel sheets myself using pandas without Microsoft listening in.
@HairoHeria
@HairoHeria Год назад
I'm more surprised of your beard
@chandoo_
@chandoo_ Год назад
I am hoping to grow it out until end of the year. Let's see. Might color it dark once I have enough hair.
@kyoujinko
@kyoujinko Год назад
I am far more concerned with what Microsoft are going to do with said data in their cloud. As I already know Python, pandas and how to export that, I really see no value. Likely suited for managers who have heard of Python.
@i_am_Sabhi
@i_am_Sabhi Год назад
This is driving me. nuts() 😂
@chandoo_
@chandoo_ Год назад
😜
@danielgoncalveslima9350
@danielgoncalveslima9350 Год назад
Many things for my mind 😢
@keylanoslokj1806
@keylanoslokj1806 Год назад
What security gaps and functional collisions will this unholy matrimony create...?
@chandoo_
@chandoo_ Год назад
While it doesn't seem all the bad, I am sure people will discover some weird loopholes in this implementation.
@keylanoslokj1806
@keylanoslokj1806 Год назад
@@chandoo_ mr Chandoo, is there any AI tool that can upload an excel file in it. Or be integrated into excel. And analyze data and produce complex formulas? Thanks a lot for your answer.
@CaribouDataScience
@CaribouDataScience 11 месяцев назад
It all so use Anaconda...
@amitgurjar3014
@amitgurjar3014 Год назад
I hope Microsoft is not planning on buying out PSF.
@chandoo_
@chandoo_ Год назад
🤷‍♂️ They are investors in many of the tech we already use.
@leonardoalba9856
@leonardoalba9856 11 месяцев назад
I don't see the use of this in the real world yet. I would rather learn and use Phyton as it is.
@user-fv5xy3ww5q
@user-fv5xy3ww5q Год назад
Sir, Please don't get me wrong, I find some kind of disturbance in your voice compared to your previous videos, please check your doctor at once.
@chandoo_
@chandoo_ Год назад
That is expected as I have braces now.
@j3553hh
@j3553hh Год назад
@@chandoo_ Looking great with the orthodontics! I had mine redone as an adult as well. Well worth the investment.
Далее
10x your productivity with these AI tools in Excel 😲
18:42
iPhone 16 для НИЩЕБРОДОВ!
00:51
Просмотров 2,8 млн
50 things you didn't know Excel can DO 💡
30:03
Просмотров 276 тыс.
Python in Excel live demo!
18:55
Просмотров 3,3 тыс.
VBA vs. Python - Which is better?
13:17
Просмотров 130 тыс.
Introducing Python in Excel
19:01
Просмотров 1,5 млн
Python In Excel: Microsoft Changed EVERYTHING
14:37
Просмотров 447 тыс.
How to Move Data Automatically Between Excel Files
11:37
NEW Python in Excel - PYTHON + EXCEL + ChatGPT = Easy!
10:32