Get Started with Python in Excel

Python in Excel seamlessly integrates the power of Python analytics into the Excel environment, enabling you to harness Python code to manipulate and analyze data within Excel. In this course, you will learn how to integrate Python, one of the most versatile and in-demand programming languages, with Microsoft Excel, the industry-standard spreadsheet tool. 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.

By the end of this hands-on course, you’ll understand:

• How to embed Python code in your Excel sheet
• What Python packages are and how they work in Excel
• Data manipulation, analysis and visualization techniques with Python
• Current limitations of the Beta version of Python in Excel
• How to import data

And you’ll be able to:

• Leverage pandas, a popular Python package for data manipulation
• Utilize Python functionality to clean and transform messy data
• Gain insight into the most recent Python in Excel capabilities to explore how they can be leveraged for generating visualizations and conducting analyses within an Excel workbook

This training is for you because…

• You’re someone who enjoys studying data
• You work with data in any form, but mostly tabular.
• You want to become a skilled data analyst using Python.

Prerequisites  

• Basic familiarity with Python or completion of these Introduction to Python Programming Learning Path courses: 
• Strings
• Numbers
• Bools
• Collections
• Imports
  
  
• Access to Python in Excel features on Windows. (Note: Python features are not yet available on Mac.)

Recommended preparation

The following will be helpful to review prior to the course, but are not required:

• Introduction to pandas for Data Analysis on-demand course
• Introduction to Data Visualization on-demand course

About the instructor

Albert DeFusco is a data scientist working to improve the tools used by data scientists and does some development, analytics, DevOps, and predictive modeling and MLOps. He specializes in scientific and high performance computing and has taught Data Science topics such as machine learning and big data processing. Prior to joining Anaconda, he completed his Ph.D. in theoretical chemistry at the University of Pittsburgh in 2008 on quantum mechanic interactions between water molecules. Afterwards, Albert was a Research Professor in the Center for Simulation and Modeling at the University of Pittsburgh where he oversaw the administration of the high-performance computing cluster and assisted researchers in its utilization.

Cost: $49. Anaconda Learning subscription is not required.

You may cancel your registration at any time before the course airs. Once the course is live, there are no refunds or credits. All registered users will receive a Zoom recording of the live course one day after the course airs.

Important info:

The tutorial will be conducted using Zoom Meetings. It is important that the name you used to register for the event is the same as the name you use when you login to Zoom. If this will not be the case, please email [email protected] to let us know.

All participants will have their microphones muted and cameras off upon entry to help minimize distractions during the live event. Support and Q&A will be conducted via the Chat function within Zoom.

Questions? Issues? Contact [email protected].