Python in Excel - Beginner Tutorial

In this step-by-step tutorial, learn how you can use Python in Microsoft Excel. If you've never heard of Python before, it's a powerful and popular programming language that has many libraries and packages that help you with data manipulation, statistical modeling, machine learning, and data visualization. By bringing Python into Excel, you now get all of these benefits directly in one place. We'll start with the absolute basics of how you even get started using Python in Excel and then we'll look at some of the additional power you get added on top of Excel.

📚 RESOURCES
- CTRL + Alt + Shift + P to insert Python code
- CTRL + Shift + U to expand formula editor
- CTRL + Alt + Shift + M to toggle between Python object and Excel value

⌚ TIMESTAMPS
00:00 Introduction
00:40 How to insert Python code
01:57 Multi-line editor
02:38 Hello World example
04:01 Assign value to variables
05:07 Reference variables
06:01 Row major order
07:42 xl function
09:10 Python output in Excel calculations
09:39 Calculation options
10:56 Python object vs. Excel value
13:39 Import data with Power Query
14:15 Libraries
15:10 Pandas describe method
16:48 Matplotlib library and charting
19:32 Wrap up

📺 RELATED VIDEOS

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

#stratvert #excel #python

[napsec]

I am a web dev that happens to be working as a middle manager and this has sparked an interest for my actual job!

[DannyHusky]

I was wondering when something like this would come out from Kevin! Thanks again for being the go-to for getting started with apps/programs that somebody would possibly hardly know anything about. Your guides are always so beginner friendly and motivating.

[SamirHabib]

Dear Kevin! You opened my eyes for using python in excel. Yo do good things bro, carry on ❤! Thank you very much! Greetings from Azerbaijan, Baku!

[antonynganga]

Absolutely brilliant way of navigating through excel using Python, you've made it so easy to understand, good job Kevin😊, Dubai

[Fredjoe]

Just updated by Excel 2019 - No Python option. Kevin should really have mentioned that this may or may not be available in your specific Excel version.

[ahmedskullab]

This is great! I pay attention to this in the coming few weeks, this is a great video! I have been using python for automating workflows and this is really helpful.

[hlangananimdibi]

Thank you brother. You're helping me prepare for a post-interview assessment. God bless you.

[dianadiazak]

Hey kelvin, you're the only one who makes me understand things in my computer.. would you kindly tutorial on how to design a website please please please 🙏🏽🥺

[superspak]

Another amazing video. The describe method just changed my life. Looking to more programming videos! I am a Mechanical Engineer trying to branch out into more skills 😁

[snvxvry]

Great stuff @Kevin I learnt so much in one evening following your videos. I've also subscribed to more videos to never miss any more of your juicy posts!

[kenkenwelch]

Thank you so much. Looking forward to them releasing to the public so I can play with it at work.

[tanjiaqi]

Awesome 🎉🎉🎉 I can't spell my gratitude toward you man. You are the hero of my day.

[bqjpmex]

Could you please use a simple machine-learning model as an example to get familiarized with the features? This is life-changing for someone who cannot code as fluent as a software engineer but understands the code and data

[orangeklay]

You're a hero!!!! I learned a lot from you today.

[infoseeker]

Thanks Kevin. Highly informative. I signed up but was placed on a waiting list with no ETA.

[Alban.Bytyqi]

My Excel does not show the python buttons like in your example. What do I do for it to show in the formula tab? Thank you

[wahsky]

Thanks, I want to know which version of Excel directly supports the Python functions?

[galitmilo.grafix]

Hi Kevin, do you have a video about Microsoft Copilot?

[MathesonMykal]

I currently use excel (VBA and analytics) for analyzing industrial data. It currently sits behind firewalls …. By running the same analysis using python.. on the cloud, how can I be assured that all our sensitive data (and analysis) is not being see/sold to competitors?

[jerrydellasala]

Would have been useful if you had provided the code for the Gantt Chart. I got a different response and the data is displayed in the reverse order you have, and the date is from 40 to 90 with other scientific notation.