šŸ’ŽUnlock Premium Features
By - Kevin Stratvert

How to use Python in Excel - Beginner Tutorial

How to use Python in Excel - Beginner Tutorial

Kevin Stratvert

0 mins
167507+ students

šŸ“ About This Course

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 - Sample Excel workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whapuySXkDuvEcSyusQ?e=Omtgd3 - 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 - Pandas documentation: http://pandas.pydata.org/docs/ - Bing Chat: https://www.bing.com/chat ⌚ 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 - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY šŸ“© NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ šŸ”½ CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ šŸŽ’ MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ šŸ™ REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 šŸ”” SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 šŸ™Œ SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same) #stratvert #excel #python

šŸš€ What You'll Learn

āœ“

Complete understanding of the topic

āœ“

Hands-on practical knowledge

āœ“

Real-world examples and use cases

āœ“

Industry best practices

Premium

Get Full Course Access

Take your learning to the next level with premium features

Unlimited access to all chapters
Interactive quizzes & assessments
Downloadable certificate