Uploaded September 2023 | Updated November 2026, 1 day ago
Not exactly a snakes on a plane situation, but your spreadsheets are going to get a lot more hissy, thanks to introduction of Python for Excel.
So, in this video, I take the new "Python for Excel" feature for a test drive and share my thoughts. We are going to look at some practical examples of what you can do with Python in Excel, how it works, what I like and dislike about this feature and how to learn more about Python. So put on your strongest gumboots and jump in.
๐ฅ DOWNLOAD FREE PYTHON FOR EXCEL GUIDE
chandoo.org/wp/download-free-python-for-excel-book
๐ Topics covered in this video:
What is Python for Excel feature and how to use it?
Loading your data and building a dataframe in Python
Basic data analysis with Python in Excel
Creating a pivot table with Python
Libraries used by Excel Python (Pandas, Seaborn etc.)
What happens when there is an error or problem
Behind scenes - how your python code runs
Creating a chart with Python in Excel (using Seaborn library)
3 problems with Excel's python implementation
Resources to learn how to code with Python
โฑ Timestamps:
==============
0:00 - Introduction to Python in Excel
0:45 - Loading your data to Python and creating a dataframe
2:44 - Data analysis with Python in Excel
4:32 - Creating a pivot report with Python (groupby operation)
6:08 - Data Changes and Errors
7:16 - Data Visualization with Seaborn in Excel
8:43 - The good & bad of Python in Excel
10:26 - Excel python is not full python!
11:15 - Licensing of Python is going to be a pain
12:00 - Too many languages in Excel
13:02 - Next steps - how to learn Python properly
~ R E S O U R C E S ~
๐ Python for Excel - FREE BOOK:
chandoo.org/wp/download-free-python-for-excel-book
๐ป Get Office 365:
Use my Amazon link to get Office and support the channel.
amzn.to/3sA7DUJ
๐ฐ Python for Excel - Detailed Introduction + 10 code samples
chandoo.org/wp/introduction-to-python-in-excel
๐จโ๐ป Learn to code with Python (3 simple projects)
Article + Code: chandoo.org/wp/python-for-excel-people
Video: youtu.be/uoC48wrJ-yM
๐บ Python vs. VBA - Which is better?
youtu.be/l0o7VMEf0yc
๐ผ Using Pandas Library - 10 examples
youtu.be/mkYBJwX_dMs
~
#python #excel
My for loop in python doesn't want to run any more.
It just needs some space. ๐คฃ
Not exactly a snakes on a plane situation, but your spreadsheets are going to get a lot more hissy, thanks to introduction of Python for Excel.
So, in this video, I take the new "Python for Excel" feature for a test drive and share my thoughts. We are going to look at some practical examples of what you can do with Python in Excel, how it works, what I like and dislike about this feature and how to learn more about Python. So put on your strongest gumboots and jump in.
๐ฅ DOWNLOAD FREE PYTHON FOR EXCEL GUIDE
chandoo.org/wp/download-free-python-for-excel-book
๐ Topics covered in this video:
What is Python for Excel feature and how to use it?
Loading your data and building a dataframe in Python
Basic data analysis with Python in Excel
Creating a pivot table with Python
Libraries used by Excel Python (Pandas, Seaborn etc.)
What happens when there is an error or problem
Behind scenes - how your python code runs
Creating a chart with Python in Excel (using Seaborn library)
3 problems with Excel's python implementation
Resources to learn how to code with Python
โฑ Timestamps:
==============
0:00 - Introduction to Python in Excel
0:45 - Loading your data to Python and creating a dataframe
2:44 - Data analysis with Python in Excel
4:32 - Creating a pivot report with Python (groupby operation)
6:08 - Data Changes and Errors
7:16 - Data Visualization with Seaborn in Excel
8:43 - The good & bad of Python in Excel
10:26 - Excel python is not full python!
11:15 - Licensing of Python is going to be a pain
12:00 - Too many languages in Excel
13:02 - Next steps - how to learn Python properly
~ R E S O U R C E S ~
๐ Python for Excel - FREE BOOK:
chandoo.org/wp/download-free-python-for-excel-book
๐ป Get Office 365:
Use my Amazon link to get Office and support the channel.
amzn.to/3sA7DUJ
๐ฐ Python for Excel - Detailed Introduction + 10 code samples
chandoo.org/wp/introduction-to-python-in-excel
๐จโ๐ป Learn to code with Python (3 simple projects)
Article + Code: chandoo.org/wp/python-for-excel-people
Video: youtu.be/uoC48wrJ-yM
๐บ Python vs. VBA - Which is better?
youtu.be/l0o7VMEf0yc
๐ผ Using Pandas Library - 10 examples
youtu.be/mkYBJwX_dMs
~
#python #excel
My for loop in python doesn't want to run any more.
It just needs some space. ๐คฃ






![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. ๐
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)



