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!!
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.
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.
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
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.
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.
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.
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
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!!
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.
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.
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.
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.
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) .
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.
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...
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
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?
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 ?
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.
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
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).
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/
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. 😅
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.
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.
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.
@@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.