Uploaded August 2023 | Updated September 2026, 1 hour ago
🔥 Learn Python inside Excel 👉 xelplus.com/course/python-in-excel
Type =PY in Excel to run Python directly in your spreadsheet. No installation, no separate app. This video shows you exactly how.
Python in Excel lets you build DataFrames, run pandas calculations, and create charts Excel can't build on its own, all inside a normal cell.
⬇️ Download the free Python Excel workbook: xelplus.com/python-in-excel/#download
🐍 What you'll learn in this video:
▪️ How to enter Python mode in Excel and create your first DataFrame from existing data
▪️ How to run custom Python formulas that go beyond standard Excel functions
▪️ How to build dynamic charts inside Excel cells using pandas and matplotlib
▪️ How to extract data with regex, describe datasets, and reference DataFrames by name
Want results you can see? Join 400,000+ professionals upgrading their skills today 👉 link.xelplus.com/yt-d-all-courses
Python in Excel runs in a secure Microsoft cloud container and comes with several libraries pre-loaded: pandas, matplotlib, seaborn, statsmodels, and NumPy. Need something else? Import it directly with a standard import statement, for example import re for regex-based text extraction.
A few practical use cases covered in this video: turning a range into a pandas DataFrame for advanced querying, unpivoting data with Python instead of Power Query, building line and area charts (including small multiples) with matplotlib, and pulling URLs out of long text strings with regex. Python also works alongside Power Query, not instead of it.
Full announcement from Microsoft: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
00:00 Python in Excel
00:40 Enter Python Mode
01:32 Send Excel Data to Python - Create a DataFrame
03:19 pandas Python Library
03:43 Describe Data with Python
05:11 Assign a Name to Your DataFrame
05:51 Referencing Headers Shortcut
06:26 Examples of pandas Functionality
07:29 Create a 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 a Single Object
14:49 Importing Libraries and Referencing Tables
18:10 Python to Excel with Power Query
18:35 Wrap Up
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
Introduction to Office Scripts: ► youtu.be/fny4zUycp_w
How to Create & Use Excel Macros: ► youtu.be/An-2Nxf_Dms
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
👉 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!
#PythonInExcel #ExcelTutorial #DataAnalysis
🔥 Learn Python inside Excel 👉 xelplus.com/course/python-in-excel
Type =PY in Excel to run Python directly in your spreadsheet. No installation, no separate app. This video shows you exactly how.
Python in Excel lets you build DataFrames, run pandas calculations, and create charts Excel can't build on its own, all inside a normal cell.
⬇️ Download the free Python Excel workbook: xelplus.com/python-in-excel/#download
🐍 What you'll learn in this video:
▪️ How to enter Python mode in Excel and create your first DataFrame from existing data
▪️ How to run custom Python formulas that go beyond standard Excel functions
▪️ How to build dynamic charts inside Excel cells using pandas and matplotlib
▪️ How to extract data with regex, describe datasets, and reference DataFrames by name
Want results you can see? Join 400,000+ professionals upgrading their skills today 👉 link.xelplus.com/yt-d-all-courses
Python in Excel runs in a secure Microsoft cloud container and comes with several libraries pre-loaded: pandas, matplotlib, seaborn, statsmodels, and NumPy. Need something else? Import it directly with a standard import statement, for example import re for regex-based text extraction.
A few practical use cases covered in this video: turning a range into a pandas DataFrame for advanced querying, unpivoting data with Python instead of Power Query, building line and area charts (including small multiples) with matplotlib, and pulling URLs out of long text strings with regex. Python also works alongside Power Query, not instead of it.
Full announcement from Microsoft: techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439
00:00 Python in Excel
00:40 Enter Python Mode
01:32 Send Excel Data to Python - Create a DataFrame
03:19 pandas Python Library
03:43 Describe Data with Python
05:11 Assign a Name to Your DataFrame
05:51 Referencing Headers Shortcut
06:26 Examples of pandas Functionality
07:29 Create a 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 a Single Object
14:49 Importing Libraries and Referencing Tables
18:10 Python to Excel with Power Query
18:35 Wrap Up
➡️ Join this channel to get access to perks:
youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
🎬 LINKS to related videos:
Introduction to Office Scripts: ► youtu.be/fny4zUycp_w
How to Create & Use Excel Macros: ► youtu.be/An-2Nxf_Dms
➡️ Join this channel to get access to perks: youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz
🎥 RESOURCES I recommend: xelplus.com/resources
🚩Let’s connect on social:
Instagram: instagram.com/lgharani
LinkedIn: linkedin.com/company/xelplus
👉 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!
#PythonInExcel #ExcelTutorial #DataAnalysis
