How to use Python in Excel - Demo + My Review @chandoo_
How to use Python in Excel - Demo + My Review  @chandoo_
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. ๐Ÿคฃ
How to use Python in Excel - Demo + My ReviewBuilt- in AI features of Excel (no need for ChatGPT)MAX IF Formula HACK to Find TOP Sales in SECONDSIf you work in finance, here are the top 10 Excel functions for you ๐Ÿ’ธSQL Joins - Beginner to PRO Masterclass with 10 ExamplesLET and SCAN Just Did This #excel #formulasFREE Power Query Materclass with 5 Advanced Tips to SPEED UP your work ๐Ÿš€How to Self-Join Tables in Power Query [Step-by-step Tutorial]Using WRAPROWS to Reshape Data (NEW Function ๐Ÿคฏ) #excelHow I Use AI To Work Smarter Every Day as a Data AnalystStop making boring column charts in Power BI - Do this instead ๐Ÿ’กHonest review of Excel CoPilot - What it can and cannot do ๐Ÿค–
Chandoo |

How to use Python in Excel - Demo + My Review

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER