Introducing Python in Excel

[@LeilaGharani]

Download the file I used in the video from here 👉 pages.xelplus.com/python-excel-file Python in Excel is currently in preview. To use this feature, join the Microsoft 365 Insider Program and choose the Beta Channel Insider level.

[@dailyinspiration4164]

Wow This very cool feature Love to see it Thanks for sharing

[@jameslucas5590]

So is this an add-on to Excel or part of the Excel version? Do you have to install python on your computer? Trying to understand the install setup or dependencies.

[@jamesantonywhitehead2814]

Python don't actually offer extra functions that are not already available within Excel... You are now showing how to remove our jobs within the administration industry.. What you are not showing is the imagination needed to interpret the data to assume new conclusions. Please suggest I am wrong.

[@LeilaGharani]

Part of Excel - no setup will be required. No python installations.@@jameslucas5590

[@LeilaGharani]

These developments will free up more time so we can take more time to interpret the data and come up with ideas and action plans @@jamesantonywhitehead2814

[@MichaelGrantPhD]

Thank you so much for this great overview. I am super proud of what our team has been able to do for Microsoft. And the work that the Excel team has done is off the charts (heh). They put so much thought on how best to put Python in the grid. Of course, this is just the beginning-more will come. Thanks again! Michael Grant, SVP, Enterprise Anaconda, Inc.

[@LeilaGharani]

You guys did a great job! We now have many possibilities that go beyond Excel's standard capabilities. Looking forward to the future developments.

[@AnthonyNomakeo]

super amped about this - good job anaconda team!

[@analyticswithadam]

This is a game changer for functional teams in finance who were really resistant to notebooks . Thanks Michael.

[@jamiegatt5370]

Excel was already getting great updates lately but this is on another level! Really excited to start using this. Thanks Michael & your team for this. :)

[@RonaldDraxer-rb4qm]

Thank you. As a data analyst and a great fan of python and excel. This is a dream come true for me

[@ojaimark]

This is actually amazing. One thing you kind of touched on but didn't really dive into is that pandas can make pivot tables too. So basically this just solved one of the oldest most annoying limitations of excel for me which is making automatically/dynamically updating pivot tables. No more bodging to force the pivot table to refresh at strategic points. Just make a pandas pivot table and because it's a formula it's always up to date and dynamic.

[@caty863]

Funny the interview question I had for my current job was to make a pivot table that auto-updates. I achieved that by using a combination of UNIQUE() and xxxxIFS() functions. I agree Python constitutes a more robust solution here; but everything could be done already with a little bit of creativity.

[@tmb8807]

You can already do this with DA formulas if your source data is on worksheets, or CUBE formulas if it's in the Data Model.

[@Boomk27]

I am so glad I learned python this past year ! This is gonna be so helpful 🎉🎉🎉. To everyone who wants to learn how to code in python, please do not be afraid and do it. Python is way easier than VBA to learn within weeks you’ll be able to write your own code and within months write code with more complexity. Do not let yourself be your own obstacle. If I did it you can do it !

[@zaheer25]

Hi. I did something similar last year. I did the 100 days of Python by Angela Yu on Udemy but lost interest because the course was so outdated that a lot of the solutions don't even work anymore. What course or Bootcamp did you do?

[@Boomk27]

@@zaheer25 hi 👋, I did the same course you did. After day 50 or 60, I just flash forwarded to the more advanced course of data analysis and portfolio project with pandas. After that, I took real projects. What I mean by real projects I registered on freelance website such as Fiver and Upwork and comeup. People reached to me for doing some data analysis job. Taking project is really the hard part and the fun part. Because every single person will come to you with an unique request. I was able to manage multiple projects it was very educating for me as a développer. I really encourage you to do so, to me it’s the best way to learn and any développer will tell you the same

[@Boomk27]

Allow me to add that with ChatGPT and stakoverflow, you’ll be able to work way more faster and still need to put in application what you learned in Angela’s course

[@nathasyapramudita6312]

print("hello world!")

[@zhuzhu9599]

​@@zaheer25if you find the answer. Plz reply me

[@SeamusHarper1234]

This is going to change excel on a fundamental level. The way they integrated it makes it so easy to use for anyone with basic Python skills. Or even with basic Pandas skills.

[@ms3862]

Everything shown here can be done pretty easily without any python or vba. I suppose it gets more useful later on . The one benefit I do is that it can generate outputs with fewer risk of errors

[@SeamusHarper1234]

@@ms3862 Yes, the demo stuff can be done without. It doesn't take much creativity to imagine all the stuff that can be unlocked. I'm using Pandas on a regular basis because Excel has it's limits and I maintain a lot of sheets that are on the brink of breaking because of the load of data. It's so well integrated, that it seems much easier than VBA. I can't see how one cannot be hyped about this =)

[@thomasnielsen5580]

@@ms3862 It is way quicker with Python. You can scrap Pivot tables and visualisation tools from Excel. Now it's a matter of just writing a few words. If you just use excel to get average values, then of course Python is not a better option.

[@joelngige5776]

I have been learning python this year and most of the stuff you illustrated is relatable. It seems one does not need to use Jupyter notebooks or Vs code to import data from excel. You just work with your data straight from native excell. Mind blowing!!!!

[@LeilaGharani]

Yes! Straight from Excel or Power Query 💪

[@snipelite94]

Be interesting to know how many Python libraries are available to excel. You can already do a great deal of stuff in the video in excel; THE ORIGINAL DATAFRAME 😁 Let's see if the Spacy and Top2Vec data mining stuff can be pip installed...?

[@jayp5269]

this does not make much sense yet to me. Importing excel in python is one liner dude. And convert any big data to dataframe means eat up your ram... nah, already learning python or already know it, directly write script, and get most of power!

[@satunnainenkatselija4478]

@@jayp5269 Maybe it could be useful for setting up and troubleshooting. Excel doesn't go along with big data but it's good at presenting tabular data.

[@amoorinet..]

This comment, and the comment on it, answered me a big question

[@JoaoSantos-jb7ul]

Hi, Leila! This is fantastic: Excel (now) using Python! I began learning Python, and sometimes I use Pandas library to open .XLSX or .CSV files to a dataframe, exclude NaN values, etc., generally using Jupyter Notebook or PyCharm to write the programs. Now, these programs can also be written in an Excel sheet! Thanks for your explanation! Greetings from São Paulo, Brazil!

[@andrewcharlesmoss]

The news only just broke an hour ago. Clearly, you knew about this before the rest of us to get this video out! 😂 Very exciting possibilities await. Excel + Python = The Dream Combination.

[@LeilaGharani]

One of the advantages of being an MVP but emotionally I have to keep my feelings and excitement to myself until I can talk about it. It feels very freeing now 😇

[@mono65]

​@@LeilaGharaniIt's really amazing. I think a specific certification in this field should be useful for everyone. Thanks for sharing

[@maniktalwar6958]

​@@LeilaGharani😅

[@AhmedMohamed-br1kr]

Amazing as usual 👌👏👏

[@sambarajkanaveni7312]

Great... Explanation big fan of your videos🎉thank you

[@SkarTisu]

I’m glad this finally exists. I was looking for this about a month ago and figured out a different way to do what I needed at the time, but it’s nice to know this is available now.

[@Big-guy1981]

Finally? Python extensions have existed for years... free of charge!

[@mr.jaycasey4676]

While this is currently beyond me, I am glad to learn what is possible and what is coming down the pike. I am storing this away in my "I may need this sometime" file. When the need arises, I know I'll come back here to learn the details. Thanks Leila!

[@vikingthedude]

Learning python will open you up to the world of programming as well, so it’s a good investment

[@ennykraft]

I've watched several videos about this now and this is the first one that got me excited about Python in Excel. The other ones focused too much on the "cool" charts you could create. When it comes to charts, I'm team "simple is best" so I knew I wouldn't need this much. One definite exception are the geoplot libraries. But your examples showed examples that will be actually useful for data analysis and when you said that we can link to Power Query, I got REALLY excited. When analyzing large sets of data, I don't want them in the workbook and no longer having to rely on Pivot tables is wonderful since people tend to forget they have to update. I can see this replacing Power Pivot. I'm definitely looking forward to you posting more videos about Python. Thank you very much!

[@tedbadje3430]

You don’t have to be a Data Scientist to see how quick Python in Excel does summaries of tables. This is fantastic!

[@Oscar-bo6ox]

yes, for quick and easy calculations, great, but for large database processing, definitely a specialised IDE for Python or R, you still have Excel's big problem, working with large databases.

[@aniketwanjari2624]

Any ide or python software setup required here Or is it possible in built

[@blzr]

For several dozen rows, it's below measurement error. Test on several millions

[@AbhinavKumar-uv1ww]

For small data set, yes. You don’t have to be a DS. However, in this digital age large data is so common, this will demand the data science/big data skills … so both will co-exist…

[@someguycalledcerberus9805]

Years of -aca- udemy training, wasted!

[@paulpurington8637]

Great introduction to Python in Excel! You started with the basics and got more complex in a very logical and easy to follow manner.

[@munemu82]

As Data Engineer/Analyst this is so powerful, I cant wait to work with it

[@AlvinRyellPrada]

This is truly amazing! can't wait for the the full deployment of Python in Excel for data science. Big fan of Excel - always relevant!! Thank you for sharing this, Leila!!! I am truly screaming as I watch your video!! Embracing Data Science in Excel!!!

[@apositron84]

Haha, it's cool, but screaming with excitement? Maybe not 😆

[@brendangully]

This is a great way of creating spreadsheets that no one else in your company can understand, thus ensuring you retain your job! Thank you!🎉

[@washingtonalto]

This is really cool!! I happen to know both Excel and Python including pandas, matplotlib among others. Am so excited and can’t wait for this to be released from beta 😊

[@LeilaGharani]

Perfect! You'll have a head start

[@vik914]

would excel row limits be an issue for large datasets?

[@LeilaGharani]

Not as long as it stays in the dataframe and you don't spill the whole thing on the grid @@vik914

[@vik914]

wow, didn't expect a response. Thank you so much!@@LeilaGharani

[@kubev]

Really useful video. I've always wanted to get more into data analysis, but the software we use at work generates the absolute worst reports, and finding creative ways to scrape for the data I need in Excel always feels like such a chore and changes from year to year. What little you showed in this video already has me really excited for how much more intuitive it's going to be for me to get the data I need quickly. Thanks!

[@lucbloom]

Let me tell you that, as a programmer, this looks way more sensible and enticing than the “user friendly” (=restrictive) environments like Tableau or Sisense/Periscope.

[@mar4kl]

Thank you for showing us this, Leila. This is the first time I can remember seeing a popular programming language incorporated into an already popular but proprietary application. (I'm not counting SQL being integrated into the various PC database management systems, because the result of that was too many new flavors of SQL.) A lot of students nowadays are graduating high school and college with Python experience, and Microsoft clearly wants them as customers. If Python had been integrated into Excel 13 years ago, when I had a contract job with a major corporation to work on an excruciatingly complex Excel model (multiple workbooks on multiple network shares with charts, tables and code all over the place and daily mainframe data feeds), I would have been able to accomplish a lot more. I've never programmed in Python, but I've learned a number of programming languages, and those Python libraries' straightforward commands are refreshing to me after dealing with all the noodling around I've needed to do in the Excel interface when I need to do any sort of analysis or regrouping. Of course, your videos help me out a lot with that as well.

[@yash1152]

pandas initial release 2008-01-11; hmm, was pandas that powerful 13 yrs ago in 2010 too 🤔?? > _"If Python had been integrated into Excel 13 years ago"_

[@simonebelfiore5269]

You are opening a totally new world on using Excel and Python! This is mindblowing to me. Only amazing!

[@ahmedaboumoslem3017]

So grateful to you Leila, you are usually keeping us updated with these valuable information Thank you from Egypt 🇪🇬

[@abal2048]

Leila, just 6 minutes into your teaching, and I'm already incredibly impressed. I'll definitely be exploring more of your content.

[@omar_5622]

For years, I used to switch back and forth between Python and Excel depending on the case. Finally seems I would be able to do the work within one environment. Aside from the pandas and dataframe stuff, i am hoping we can use Python to replace VBA (at least partially)

[@aryan6536]

Very useful for an ex-python developer who ended up having to learn Excel since most users were not comfortable in using a web front end. Easy Peasy stuff, love it.

[@queenbey6678]

This is great. I've used pythonto in excel for years so it's great they officially include it

[@Based-Pharaoh]

Please do not let this woman fool you. This lease do not let this woman fool you. While useful, this functionality involves pandas, not python

[@dagordon1]

Besides the Python library called pandas, she also demonstrated the Python library called matplotlib and hinted that seaborn and numpy will be available.

[@funk44]

​@@Based-Pharaohwtf are you talking about!? Pandas is a python library???

[@Based-Pharaoh]

@@funk44 Correct hence why it makes more sense to have named this function 'pd' instead of 'py'

[@BhaktiParajuli-x9m]

Leila, you're really good in excel-- Your information is so simple and clear - which is what people will be looking at from any tutorials out there! It's Clear, concise and perfect. Thank you so much!

[@amolnwagh]

We want a whole Udemy course on this. This is what I had always wanted. Wondering if python in excel can take inputs for python variables directly from cell values in excel?

[@blzr]

xl("A1")

[@keylanoslokj1806]

It definitely can.

[@katrinabryce]

@@blzr Would that return a single-cell dataframe or a scalar value?

[@blzr]

depends on your range: scalar, vector or martix@@katrinabryce

[@philosophicsblog]

Better late than never. I've been using Excel and developing for decades. I'm glad this was recommended to me. Thanks.

[@MarkCassano]

I've always wanted Matlab/Octave integration where cells can refer to matrices or even 3D arrays (without having to see the contents). This is probably even better (though I'm not a python pro). Exciting!

[@wirechair]

YASSSSSS!!! REGULAR FREAKING EXPRESSIONS!!!!!!! IVE WANTED THIS IN EXCEL SINCE 2020!!!! YESSSSSSS!!!!!!! THIS IS THE BEESSSTTTTT!!!!!

[@Datalata]

This is brilliant, thanks. Superbly explained so you don’t have to be a data scientist to understand it - but it introduces the main terms and processes that data scientists use. Can’t wait to use it myself!

[@ReadyPlayerOn3]

This is great for Excel users. Google Sheets has had a different way to add Python for awhile now. It's cool how Microsoft has implemented Python.

[@WesleyJeftha]

Hey bro, dont like Excel too much but this update from MS is sick, as a matter of interest, do you have links for the Google sheets equivalent of this PY integration?

[@systembreaker4651]

Yes we need full course from you for python and excel ❤thanks

[@dominicknights4339]

Agreed

[@karinamatvejeva3164]

Agreed too

[@LeilaGharani]

Thank you for the trust. I would love to make one at some point 😍

[@amolnwagh]

@@LeilaGharani eagerly waiting for your course on Udemy

[@MaiMai-eo7zk]

@@amolnwaghthis!!

[@carolpruett9741]

Great news! I am super excited about Matplotlib and Seaborn being in Excel. Game-changer!

[@jimiclapton]

Fantastic demonstration of the functionality. I can see the use for quick adhoc aggregations and transformations, however Excel is a sub-optimal environment in which to use Python, especially so if you're a beginner. If you're going to go the effort of learning Python simply import your .xlsx or .csv into an IDE like PyCharm or Jupyter Notebook that is designed for the purpose of iteratively developing your code and creating visualisations etc. This way your code can be structured, sequential and clearly legible to you and others, not just bunched up in the formula bar with you having to resize cells to view a chart.

[@jayp5269]

exactly

[@Javy2Wallz]

I hate to be negative, but I agree as well. The great thing about Pandas is automation and being able to work with massive datasets, Excel is really weak in this aspect.

[@frankchythlook152]

I've looked at Excel and taken a class or two, but wasn't too excited to learn much beyond how to get some pretty print out of it - now that Python is involved I can see this as being something in this century!

[@MateuszAdamowski-k8b]

That's a great thing. People will quickly learn Python and realize they don't need Excel anymore, they can just switch to using more reliable tools like versioned Jupyter Notebooks + versioned CSV data files + versioned source code

[@StephenDix]

Glad someone said this out loud.

[@alanpowell24]

What a lovely lady. So many tutors are very hard / painful to listen to but she is a pleasure...................

[@katrinabryce]

One type of chart you can do in Python, but can't really do in Excel is heatmaps. Useful if you want to visualise data in two dimensions. For example, during the pandemic, I created a chart that had age in the y axis, date in the x axis, and the infection rate for each date/age pair displayed as a shade of colour from white for 0 to a fully saturated dark colour for highest value. You can put the numbers in a pivot table and do conditional formatting to get something similar, but it doesn't work so well. Also, when you are dealing with millions of rows of data, Python, especially if you use the Numpy library, can be a lot faster. In one example I had, calculation time went from 6 hours on Excel to 10 seconds on Python/Pandas to 0.1 seconds on Python/Numpy.

[@EddieOtool]

That's a good beginning. Now when we can natively code in straight Python instead of VBA I will be thrilled. VBA syntax hurts my feelings.

[@alanwilson175]

Looks very interesting. I use python a lot for scientific calculations. The most used modules are numpy, scipy, and matplotlib. By now I probably have more than 1000 functions that I have written. It will be interesting to see how this works with XL.

[@moondevonyt]

this excel integrating python stuff is next level for real but honestly, think it might be a bit overkill for the everyday excel user who's just crunching numbers not everyone's ready to dive deep into python, even if it's just a few formulas still, props to the creator for breaking it down and making it digestible if you're looking to level up your excel game, this is the sauce but it ain't for everyone. keep it 100!

[@123rockstar2010]

This is one of my biggest regrets growing up. I should have learned to code. This is so exciting for new Excel users. I am still learning VBA for macros as it has helped me in my work for alot of times. I am hoping to learn more on how Python will be useful in my job. Thank you Leila!

[@LeilaGharani]

No regrets. It's never too late to start. If you know some VBA, learning Python will be really easy for you.

[@sultanhanga]

Python is so easy just start

[@medasbabu]

relatable, i have been VBA guy for long time, despite learning Python I could never code it, but with ChatGPT, I'm able to create python codes easily and have the script running in minutes, so you should also be able to code in Python soon, Good Luck!

[@ferggill9461]

Python is so easy for things that were awkward in Excel, I found that even just putting an average line in a plot was easier in Python than Excel. I always used py for sourcing and cleaning data. I'm happy about this upcoming feature.

[@vijayarjunwadkar]

Wow! I know R language and have used it with Excel, but Python right inside Excel is something amazing! This will surely be a game changer as combining these two powerful tools will double the power and open up so many possibilities! Thank you Leila, for this wonderful and informative introductory video! BTW, expecting a series on Python from you now, to help us do the magic! 🙂

[@nathasyapramudita6312]

I ditch Python and dedicated myself to be R advance lvl. Somehow I felt betrayed 😥

[@Matthew-sh1ln]

@@nathasyapramudita6312 Python is great to learn alongside R, native Microsoft intergration will exponentially increase the want for it in the job field in the future.

[@vijayarjunwadkar]

@@nathasyapramudita6312 No worries, you can still learn Python (it's lot easier than R) and you will have tripled your skill set, that will fetch better opportunities and returns. Good luck! 🙂

[@Javy2Wallz]

Unfortunately, this is pretty useless. Better to just learn python with juypyter notebooks, that way you can automate these excel tasks with any size datasets.

[@pestnocturne]

I am grateful for your videos. I have literally learnt excel from you over the years. I always ask anyone willing to learn excel to look for your videos for the easy explanations.

[@LeilaGharani]

I appreciate that!

[@finansowyexcel1966]

I am impatiently waiting for Python to appear in my version of Excel 365

[@MrRhainer]

Python integrated on Excel is amazing

[@bryanb3352]

How so?

[@trevordennis]

So, Excel now has FIVE languages in it to learn. Formulas, VBA, Power Query (M), DAX, and now Python. When are they finally going to add C#?

[@tigerbojiteol]

Just stick with DAX and Python. No more hassle.

[@MichaelDennis-y9g]

Oh no, not C#! The only thing in worse condition than MS Office (re: bolt-ons) are Windows Development Tools (and all it's manifestations).

[@Chris.Brisson]

VBA 8.1 will rule them all.

[@allenklingsporn6993]

I'm not sure how useful I'll find this feature. The primary use cases for Python with data for most people is that the data wont fit into the "memory" available for Excel. Adding Python on top doesn't change that reality, and in fact, it might hurt Excel performance even further.

[@andrzejb4370]

Really great news. Personally, I'm especially interested of working with matplotlib in Excel as this would give possibilities of chartings not available directly in Excel (at least without addins ). Working with connections only seems also to be a big 'yes'. I'm a bit curious though od three are plans to bring It to Excel online as well (or if It will be at least compatible even if code is prepared in desktop version)

[@franklobe]

What I think is really cool about this is that it makes it possible to do machine learning in Excel. Python has had the ability to create Excel files for a long time with a library like openpyxl, but now instead of sending a .csv file to a machine learning engineer, it would seem that it's possible to import the .py file directly into Excel and pass a Panda dataframe directly into a function in the .py file. This opens up the possibility of doing things like; clustering, classification, and multivariable regression on the fly. I can see data analysts loving this.

[@veeramanigudiyan]

The start was epic😂

[@govindsinghbhandari5522]

Soon I'll start to learn python now this amazing video added one more strong reason and excitement to use in excel.

[@Microman6502]

I remember being excited about Excel 5 because it had VBA macros. Great to see this all modernised!

[@spilledgraphics]

Fantastic, fantastic, fantastic, Leila! glad to be back on your channel, watching your content and your contribution. Finally, I got the chance to go through the whole video! - loving everything you shared, and for certain, I will emulate your small multiples example. Thank you, thank you! 🙏

[@chadmace3355]

I've been using python for a while. It started because excel just couldn't handle large data sets. I find this interesting and somewhat useful. Now that I am in python a lot, not sure how often I will jump back to excel. Thank you for sharing!

[@mohammedaman6315]

You made me understand python … thanks Leila.. can you come up with more such examples please? Loved this video ❤

Will they call it Pyxcel?

[@XrollhaX]

Actually is Excelthon

[@LisaDonat-t1z]

Grand Maester.

[@LFPXX]

Pexcel

[@nikolaimikuszeit3204]

Super exciting. Life-changing for someone who really loves to work with Python.

[@XLGuy]

It's absolutely amazing. Thank you Leila for wonderful yet simple explanation. Hoping to deep dive into it, obviously, with the help of your videos.😊

[@PriteshRPatel-lr5uh]

@Leilegharani. This is a fantastic overview of python in Excel. I've used python via jupyter notebooks for the past 7 years, but now to have this in Excel....potential game changer and cost saver when coupled with power query and even power automate.

[@Haessige]

As a programmer working in IT Security, I am horrified 😂

[@lanceandangelamendoza3744]

My thoughts exactly, why with about macros when you can just have the python feature

[@bobgreenfield9158]

Why?

[@crapphone7744]

I wonder if there's a panda library for bass 64 encoding/decoding. That way you can put your code in and make it with entropy so it looks like data and gets ignored by EDRs like crowdstrike

[@crapphone7744]

If you can find a base 64 encoder decoder in Pandas you can then put your code in as high entropy data that will be ignored by EDR. This is only going to get worse.

[@WorkoutLoverOfficial]

Absolutely Amazing Python transforms the way of calculation in Excel. Thank you Miss Leila Gharani. You taught very well.

[@maci6990]

The horror! Imagine Dataframes and different excel-files and versions all over the place. No source control, hard to audit and really every code junkie can create stuff. I was so happy that Power BI was finally stopping the excel-based-data architecture you find in so many companies. I think this will make everything worse. Don't misunderstand me here: yes it is powerful to put Python in Excel. But it will create tons of poorly managed technical debt. Add the monkey code of chat-GPT to that and the chaos is complete.

[@TheJimtanker]

This is AWESOME! I can think of all kinds of ways I can use this at work to update a lot off our old Excel VBA scripts.

[@TheChugnut]

This is excellent!!!! I love Pandas and Python, and hate M Formulas, so that last tidbit has me very excited indeed. The only thing that could top this is replacing VBA with Python, or proper integration into VS Code! We can only dream.

[@rodnyg7952]

have absolutely no use for Python or Excel, but it has been entertaining to watch and read many spreadsheet nerds get so excited about it :)

[@piggybankaccountant]

Anyone else feels like this is overwhelming ?

[@Sadigziggi]

Let's explore this feeling. Because Excel as a whole is overwhelming for a lot of people.

[@cesarrodrigues9763]

I'm a Rookie programmer in Excel and these utilities are super useful.... First time I saw it....

[@MichaelDennis-y9g]

Microsoft leadership has no coherent vision. They are slapping everything they can into Office with no real plan. Let's see: we can program in the original Excel Macro language, or VBA (whose development ended years ago), a dodgy API, or JavaScript (never really implemented). We also have Array functions (of {old} and new types--with the same functionality), Lambda functions (still sorta kludgy), and now Python. If they would just completely FINISH the features they already had, we probably wouldn't need many of these bolt-ons. The Excel object model is a nightmare of half-started ideas. The number of bugs that have persisted for 30+ years is truly staggering. Adding Python in cells is not bad in and of itself, but HOW MANY different languages do people have to learn to use this thing anymore? MS is doing this across ALL of their product lines and it's truly a mess--especially for developers!

[@MahmudYuldashev]

Totally agree. If Ms continues to improve existing functions like pivot table, you don't need all these mess.

[@bryancamareno2831]

This is amazing! Especially the Regex example. I can’t wait for this functionality to be rolled out in Excel at my company!

[@cherise715-s5k]

Amazing video as always❤. Being a loyal student to lots of Xelplus courses, would you consider developing a course for Python in Excel? Really loves the way you teach new concepts and integrate real-world examples.

[@aronlilland7638]

the problem with businesses building with excel is not that it isnt a powerful or even useful tool. The problem is maintainability. One user gets super powers at low cost and starts making large sweeping changes that break business processes downstream. We made almost 300 million dollars off of eliminating excel from business processes where groups within our departments worked off shared spreadsheets. it was ridiculous with the amount of pain excel causes. we just started building our own web platforms instead.

[@resresres1]

Still not entirely sold on using Excel at all. I use Python to automatically read/parse excel files and automatically output the data to custom built Python user interface. Opening Excel and selecting the data to use, is just an extra step not needed. yes... not everyone knows how to building custom UI's with Python....but if you know how

[@renatocorreaarrieche]

I'm so glad I'm alive at the time Excel integrates itself with Python. Thank you people for this awesome nice work!

[@antonynganga7868]

You've actually made it much easier to understand how python works not just in excel but generally,thanks Leila🎉❤,Dubai.

[@Based-Pharaoh]

Please do not let this woman fool you. This lease do not let this woman fool you. While useful, this functionality involves pandas, not python

[@samvan7787]

This opens up a lot of possibiilties for those who know python and leverage its powerful library in Excel. Thanks for this tutorial

[@Bruh-vp6qf]

I am genuinely excited for this. I've been wishing this exists for ages. Finally!

[@LeilaGharani]

You and me both!

[@sahilsinghal9472]

This is so exciting. Just recently i developed a very complex financial plan which can be sinplified with Python. Now I'll be able to do it within Excel

[@johnsmith1953x]

*The Finance industry has BILLIONS of lines of VBA code in Excel/Word* This is crazy.

[@EEBPioneer]

This announcement is awesome! Python in Excel is a thing everyone really has waited for a long time. This feature is Jupyter Notebook killer.

[@JaydenX]

Thank you, this is crazy helpful. Sometimes I forget how new these functionalities are, and it amazes me what we can do now compared to a year ago.

[@dominiquedabolczi-fekete6679]

Wow. Wonderful video for accountants, bookkeeper, and financial managers. You make it so easy.

[@tmb8807]

Having played around with it a bit, I have to admit I really don't get this implementation. To me, probably the biggest up-side of using Python for data analysis is the speed with which you can both read and perform transformations on very large data sets. Power Query reads data from flat files very slowly compared to pandas (and especially compared to something like Polars, which natively parallelises operations and has explicit methods for lazy execution). But with the way Python in Excel has been implemented, not only are you still bottlenecked by Power Query in actually getting data, but that data then has to be sent to the cloud to be utilised. Even with smaller data you'll take a performance hit because of this, but for bigger data sets I can't see how it can be practicably performant at all. There are probably still going to be some reasons you might use Python in a worksheet (e.g. a particular visualisation you can't get in Excel) but I can't see it being extremely common. For the most part I see it being much more efficient to either just use native Excel functions, or forget Excel and use a notebook. One or the other. Combining them in the way MS has done, with cloud-based execution, doesn't make any sense to me. It seems like you're getting the worst of both (and paying for the privilege).

[@dragon3602010]

OMG here we are❤❤ Grist was already using Python and it's freaking aaaawesome🎉🎉

[@samsschool3639]

Excel has put more food on my table than any other software. This is GREAT!!!

[@reng7777]

This is music for my ears!!!! i 've been waiting for this so long! actually i was thinking that due to MS has already embended TYPE SCRIP in excel .....I thougth that this could be its official languague for excel ( replacing vba) ...but now comes out with this great surprise! and obviously Leila the 1rst one to lunch it to all excel lovers!! Excellent video amiga!!! and the cherry on the top of the Pie was that can interct directly with Power Query OMG !!!!!

[@FastbreaKHere]

the fact that created dfs update themselves can come very useful. Usually when you construct a dataframe starting from some datas if you change those datas after creating the df you dont see the df updating accordingly unless you run again the pd.DataFrame( ---) constructor. Here you have the df you create with the xl function updating accordingly.. really REALLY useful.

[@Tum_Tum_]

Python in excel will definitely chane the life of data analysts ❤

[@LeilaGharani]

Agreed. Thanks for watching!

[@Harpoika]

This is great! I can now literally get rid of Jupyter notebooks. SQL server>Power Query>DataModel/Excel>Python! 😁

[@garydunken7934]

I love Excel AND Python. This news is very exciting indeed.

[@emilbek_isaev]

Great. Now, in addition to Excel functions, M language, Dax language, I've to learn Python either. Anyway, thanks for video detailed as for dummies in Python.

[@bobbyyankey5967]

Thank you, Leila, for your lesson. You are so admirable with your Excel teaching. I salute you

[@LeilaGharani]

Thank you! 😃

[@jasong9774]

I've been wanting this for decades. Adding in integration with pandas and scipy... Awww, yeah. Browser next, please.

[@rulf007]

From the beginning of the video I kept thinking that Python in Excel is a cool gadget, but the real value comes when combined with Power Query. And then boom! That's going to be really exciting.

[@2logj]

Super Leila we are now having two great tools for doing data analysis.This will be exciting .

[@duncanwallace7760]

This is going to be very helpful. Excel is such a useful tool, to have python in it is amazing.

[@2bczar4u]

Thank you for your very understandable explanation! I had to go back a forth a few times to catch on but that was 'me' and not 'you'. Super excited about this as well.

[@charljoubert7908]

I hope libre office will also build python into the game