Introducing Python in Excel

You can use Python INSIDE Excel now 😱 In this video I'll introduce this game changing new functionality of working with Python inside Excel. Is Python in Excel for non-programmers? Can everyday data analysts make use of it? I'll answer these in the video.

🐍 What You'll Learn:
▪️ Entering Python Mode in Excel: Master the basics of switching to Python mode in your Excel environment.
▪️ Data Frame Creation: Understand how to create and manipulate Data Frames from Excel data, providing a robust structure for analysis.
▪️ Custom Python Formulas: Explore the power of custom Python formulas in Excel, expanding your analytical capabilities beyond traditional Excel functions.
▪️ Advanced Charting: Dive into creating dynamic charts within Excel cells using Python, offering enhanced data visualization options.

If you have this feature which is currently free to use in Microsoft 365 Insiders, you will find Python in the Insert tab in the Excel Ribbon. You get a few Python libraries already ready for you to use in Excel. These are the pandas, matplotlib, seaborn, statsmodels and NumPy. You can import other libraries as you need using the import statement - for example import re module for REGEX calculations. How can you use Python in Excel in practical terms? I share a few ideas in the videos. You can use the pandas library and turn your data into a dataframe which you can then use for more complex tasks, like query the data, unpivot the data with python, create charts using matplotlib - make a line, area or even small multiples. You can grab URLs from long text by using the regex library. You can also use python together with Power Query. We'll only scratch the surface and even that is pretty awesome.

00:00 Python in Excel
00:40 Enter Python Mode
01:32 Send Excel Data to Python - Create Data Frame
03:19 pandas Python Library
03:43 Python Describe Data
05:11 Assign Name to DataFrame
05:51 Referencing Headers Shortcut
06:26 Examples of pandas Functionalities
07:29 Create Series Python Object
09:35 Plot a Chart in an Excel Cell
10:51 pandas Documentation
11:16 Calculation Logic of Python Cells
12:07 Examples from Default Libraries
13:35 Plot Multiple Charts As Single Object
14:49 Importing Libraries & Referencing Tables
18:10 Python to Excel Power Query
18:35 Wrap Up

➡️ Join this channel to get access to perks:

🎬 LINKS to related videos:

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#python #excel

[LeilaGharani]

Python in Excel is currently in preview. To use this feature, join the Microsoft 365 Insider Program and choose the Beta Channel Insider level.

[JoaoSantos-jbul]

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!

[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.

[paulpurington]

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

[joelngige]

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!!!!

[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!

[swdthzw]

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!

[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.

[mr.jaycasey]

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!

[Boomk]

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 !

[ahmedaboumoslem]

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

[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!

[omar_]

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)

[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!

[aryan]

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.

[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.

[abal]

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

[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!

[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! 🙏

[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.