Experience Python in Excel Now

The Versatility of Excel +
The Power of Anaconda

The world’s most popular data application meets the world’s most trusted Python distribution.

Do More with Your Data

Use popular Python libraries within Excel for complex data analysis and modeling.

Create Custom Visualizations

Explore, manipulate, and present data like never before.

Streamline Your Data Preparation

Simplify complex data transformations and boost productivity while minimizing manual effort.

Share Work Effortlessly

Your work becomes more accessible, easier to understand, and easier to reproduce.

Experience Python in Excel Now
Which best describes you?

I’m an Excel Analyst

I’m a Python User

Get Started with
Python in Excel

Discover how to leverage Python’s powerful libraries and scripting capabilities to supercharge your data manipulation, visualization, and analysis tasks within Excel.

Register for This Course
video background 1

Introduction to Data Visualization with Python

Derive insights from data using pandas .plot, seaborn, and Matplotlib.

Register for This Course

Get Anaconda Certified: Python Fundamentals for Data Analysis

Enhance your technical skills and unlock new opportunities with a certification from Anaconda. Learn to read, write, and solve real-life problems with Python, and build a foundation for using pandas for data analysis in Python.

By the end of this certification program, you’ll learn:

  • Foundations of Python
  • How to create pandas datasets from other Python data types
  • How to subset, filter, and combine DataFrames together
  • Application of descriptive statistics, aggregate functions, and “group by” to view different dimensions of data
Register for This Course
Experience Python in Excel Now

Discover Next-Level Capabilities with the Anaconda Toolbox

Unlock even more capabilities with the Anaconda add-in for Excel – for FREE!

Sign Up for Beta
Lean on our expertise
  • Anaconda Assistant: Your Personal Guide to write better code
  • Unlock the Value of Your Data: Streamline Access, Collaboration, and Insights with our Dynamic Data Catalog
  • Novice Users Wanting to Effectively Visualize Information
  • Individuals Who Want to Compute Results Quickly Without Coding Knowledge
  • Seaborn: Seamlessly Craft Stunning Visualizations that Inspire and Inform

Frequently Asked Questions

Why do I need Python in Excel?

Python in Excel lets you run Python code directly in the Excel formula bar. For Excel users, this enables new and powerful analysis and visualization capabilities. For Python users, this makes your Python code easier to share with your Excel-using colleagues, and you can avoid jumping back and forth between Excel and Jupyter notebooks.

Anaconda is integrating the Anaconda Distribution for Python within Excel. This provides not only the core Python functionality but also access to over 400 curated packages, enabling advanced data analysis and visualization directly within your Excel workbook.

Python is an ecosystem consisting of the core language and upwards of hundreds of thousands of third-party libraries, also referred to as packages, developed independently. A distribution, like the Anaconda Distribution for Python, is a subset of those third-party libraries collected into an installable software package.

In Python, the term ‘import’ is used to bring additional functionality into your code. It allows you to access methods and tools provided by third-party libraries or packages.

To get the most out of Python in Excel, start with these packages:

  • pandas for working with tables
  • Seaborn and Matplotlib for creating charts (Seaborn is more beginner friendly, while Matplotlib offers more customization)
  • statsmodels or SciPy for statistical analysis
  • scikit-learn for machine learning

These are a great starting point, with plenty of others to explore as you progress.

In the formula bar, you can click the Python button or type =PY( and start writing your Python code.

Python in Excel uses curated packages from the Anaconda Distribution, safeguarding against malicious packages that are commonly found in community-led repositories. Anaconda’s curation ensures that the packages are compatible and work seamlessly together, providing a trusted source for Python.

A DataFrame is a representation of tabular data organized by rows and columns. The pandas Python library reads tabular data in many formats like Excel or CSV and creates a DataFrame object. The DataFrame can then be used to perform exploratory analysis or data processing in Python.

See https://pandas.pydata.org/docs/getting_started/comparison/comparison_with_spreadsheets.html?highlight=excel for more information.

The VLOOKUP capability within Excel is used to merge two tables by at least one common column and under a specified condition in the pandas library you can perform similar operations using the merge() or join() methods.

The Anaconda Toolbox provides tools to supplement and assist your Python in Excel work. 

Visit Microsoft Website to Learn More