Excel | Anaconda

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

Resources

Get Started

What is Anaconda? Take the course

What is Python?

What are Python Packages in Excel?

Helpful Resources

Python for Excel Analysis: The Basics

Data Analysis with Excel & Python: Take the course

Excel Template: Visualization Examples (Download)

Best Practices

Introduction to Data Visualization with Python

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

Register for This Course

Resources

Get Started

Why Data Scientists Should be Excited About Python in Excel

Data Visualization with Python

From Notebooks to Workbooks: Data Reporting in Excel with Python

Helpful Resources

Create Your First Machine Learning Experiment in Excel with Python

Introduction to Machine Learning: Take the Course

Data Cleaning with pandas: Take the Course

Best Practices

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 while in Beta!

Get It Now!

Lean on our expertise

Anaconda Assistant: Your Personal Guide to write better code

Share your data easily

Unlock the Value of Your Data: Streamline Access, Collaboration, and Insights with our Dynamic Data Catalog

Drag & Drop Formula Builder

Novice Users Wanting to Effectively Visualize Information
Individuals Who Want to Compute Results Quickly Without Coding Knowledge

Tell a story with your data

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.

How is Anaconda contributing to Python in Excel?

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.

What is a package/library/distribution?

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.

What does “import” mean?

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.

Which Python packages should I use in Excel?

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.

How do I write Python in the grid?

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

Is Python in Excel safe?

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.

What is a DataFrame?

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.

How can I do VLOOKUP operations with Python and pandas?

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.

Is the Anaconda Toolbox the same as Python in Excel?

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

Visit Microsoft Website to Learn More