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.
Get Started with Python in Excel
Use Python to process and analyze data without leaving your spreadsheet.
Introduction to Data Visualization with Python
Derive insights from data using pandas .plot, seaborn, and Matplotlib.
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
Discover Next-Level Capabilities with the Anaconda Toolbox
Unlock even more capabilities with the Anaconda add-in for Excel – for FREE!
- 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
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.
The Anaconda Toolbox provides tools to supplement and assist your Python in Excel work.