A Comprehensive List of Python in Excel Resources

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. 

• Master Python in Excel with Anaconda’s Python in Excel Cheat Sheet
  Our free Python in Excel cheat sheet is your go-to guide for everything from creating Python cells and using Pandas DataFrames to crafting pivot tables and applying custom functions.

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!