Data Visualization with Python in Excel
Enhance strategic financial decision-making with Python.
What you'll learn—and how you can apply it
By the end of this hands-on course, you’ll understand:
Data visualization best practices. How to use Anaconda Toolbox for Excel to create compelling data visualizations without coding required. How to create advanced Python visualizations from scratch to effectively communicate data stories.
And you’ll be able to:
Write Python code to visualize data in Excel
Create Python visualizations without code using Anaconda Toolbox
Build interactive dashboards using Python in Excel
Description
Python in Excel offers an integrated Python experience within Microsoft Excel, the world’s leading business productivity application. Since its release, this game-changing feature has empowered analysts, data scientists, and knowledge workers to leverage Python’s full power directly in Excel. With its robust data visualization tools, Python in Excel opens new opportunities for impactful data storytelling—enabling those who master it to set themselves apart in the workplace and in today’s competitive job market.
This interactive course will teach you how to create effective data visualizations using Python in Excel, starting with foundational best practices and progressing to advanced, interactive charts. Starting with an overview of key principles for effective data visualization, the course progresses to hands-on experience with the Anaconda Toolbox for Excel, allowing you to quickly create and customize charts using Python without any coding. As the course advances, you will build more sophisticated, interactive visualizations that respond to data changes, including multi-plot charts tailored for financial analysis, process monitoring, and engineering calculations. Whether you're new to Python or experienced in Excel, this course provides practical techniques to elevate your data storytelling
This training is for you because...
- You’re a data analyst and need to create advanced charts to communicate your findings to stakeholders
- You’re a business professional looking to enhance your data storytelling skills with more impactful visualizations
- You’re a data scientist looking to streamline your data workflows by integrating Python’s capabilities within Excel
Prerequisites
- You must have an M365 license with Python in Excel. Please also install Anaconda Toolbox for Excel prior to taking this course.
- If you are new to Python in Excel, it is recommended you view the recording of this webinar, Introduction to Python in Excel, before taking this course.
- Basic to intermediate knowledge of Microsoft Excel
- Basic knowledge of Tables
- Basic knowledge of Power Query
- Knowledge of ranges, absolute and relative referencing
- Knowledge of named ranges
- Knowledge of data validation configuration
- Understand the basics of creating charts and why we create charts
- Should be comfortable with deriving meaningful insights from data
Instructor
Owen is a Senior Product Manager of PyExcel at Anaconda and Microsoft MVP for Excel, with 20+ years of experience in data and analytics.
Curriculum
21 Lessons
Course Preparation
Author Introduction
Introduction to Data Visualization
Visual Communication
Understanding Your Audience
Choosing the Right Chart Type
Exercise: Choosing the Right Chart Type
Avoiding Common Pitfalls
The Importance of Simplicity
Using Colors and Labels Effectively
Exercise: Spotting Chart Problems
Anaconda Toolbox for Excel
Exercise: Creating Charts with Anaconda Toolbox
Parameterized Plots
Multiple Subplots
Exercise: Using Spreadsheet Data to Change a Chart
Financial Charts
Exercise: Chart Annotations
Process Monitoring
Engineering Calculations
End of quiz survey
Instructor
Owen is a Senior Product Manager of PyExcel at Anaconda and Microsoft MVP for Excel, with 20+ years of experience in data and analytics.