Are you new to Python in Excel or looking to take your skills to the next level? We’ve created this Resource Guide to help you make the most out of Python in Excel and take advantage of all it has to offer. From certification courses, to video tutorials, to Python in Excel communities you can be a part of, these resources help you no matter where you are on your Python in Excel journey.
We will be updating this blog post as new resources become available so be sure to bookmark this page!
Courses and Certifications
Anaconda Certified: Data Analysis with Python in Excel
This program will leverage your Excel knowledge to jumpstart your data analysis skills using pandas, one of the most popular Python packages for working with data.
Anaconda’s Get Started with Python in Excel Course
In this course, you will discover how to leverage Python’s powerful libraries and scripting capabilities to supercharge your data manipulation, visualization, and analysis tasks within Excel. Whether you’re a data analyst, financial professional, or business enthusiast, this course empowers you to harness the power of Python in Excel for more efficient and impactful data analysis.
Anaconda’s Machine Learning with Python in Excel Course
In this hands-on course, you’ll learn how to use Python in Excel to create simple machine-learning experiments by working on coding examples in a live-coding environment.
LinkedIn’s Python in Excel
Learn how to manage your entire data workflow directly inside an Excel worksheet. The content covered includes referencing Excel values in Python, using pandas to analyze data in an Excel worksheet, using Python plotting modules, and more.
LinkedIn’s Python in Excel: Getting Started with Data Analysis
This hands-on course covers the basics of working with data using Python in Excel including data structures, DataFrames, functions, and more. Throughout the course a handful of practical Python-in-Excel examples such as fixing dates with dateutil, generating a random sequence, creating a scatter plot with Seaborn, creating a Gantt chart, and extracting data using regular expressions will be highlighted.
LinkedIn’s Python in Excel: Working with pandas DataFrames
Discover how to work with pandas DataFrames in Excel. Learn how to turn different sources—such as an Excel range, an Excel table, or a Power Query—into a DataFrame and find out why and when it makes sense to use a DataFrame, as opposed to native Excel features like Power Query, Pivot Tables, or VLOOKUP formulas.
LinkedIn’s Python in Excel for Financial Professionals
Uncover ways to use data analytics to enhance your analytical and modeling abilities and ways to improve your work by using Python in Excel.
Tutorials and How-To’s
Anaconda’s Python Tips Video Series
Tips and tricks to help develop and boost your Python skills, whether you are a beginner or an experienced Python enthusiast.
Python in Excel YouTube Videos by David Langer
David Langer, the creator of Dave on Data, shows you how to get started with Python in Excel, use cases for when to use Python in Excel, and tutorials on common functions.
Anaconda Blog
Tutorials and how-to guides on common Python in Excel functions like analyzing time series data, visual data analysis, text analysis, and stock data analysis.
Guides
Microsoft’s Introduction to Python in Excel
A 101 guide on how to get started with Python in Excel, common functions to use, keyboard shortcuts, and troubleshooting errors.
Communities
Microsoft 365 Insider Excel Community
Anaconda Python in Excel Community
r/excel Community on Reddit
r/Python Community on Reddit
Python in Excel LinkedIn Group
Microsoft Excel Users LinkedIn Group
Python in Excel (how-to) LinkedIn Group
Additional Resources
Anaconda Toolbox for Excel
Anaconda Toolbox for Excel is a suite of tools to help you maximize all of Python in Excel’s capabilities. Tools in Anaconda Toolbox include the ability to carry your code between workbooks, a visualization builder, and more. To learn more about Anaconda Toolbox for Microsoft Excel, check out this blog post.
_____________
Do you have a great Python in Excel resource that you think should be added to this guide? Send us a message on X or LinkedIn and we will take a look!
