Excel with Python: Constructing Data Visualizations
Python 3.7
| Intermediate
- 11 videos | 1h 55s
- Includes Assessment
- Earns a Badge
This course explores how to use Python's openpyxl library to build visualizations such as line, bar, and bubble charts in Excel. In its 11 videos, you will examine how Python and its ecosystem of libraries are fast emerging as a popular choice for easy spreadsheet automation, before learning how to create line and bar charts in Excel, and learning how to use Python to control several properties of those charts, including line weights and style, data for the reference axes, formatting, and the position of ticks on those axes. Learners will observe how to construct data visualizations in Excel using Python. This course then demonstrates common types of visualizations that are supported in Excel, and how to programmatically replicate those visualizations from within Python. Finally, learners will observe demonstrations of the use of bubble charts to display three dimensions on a two-dimensional chart as well as stock charts to represent the opening, high, low, and closing prices of stocks in a single data visualization for the financial markets.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this course
use Microsoft Excel to visualize data
use openpyxl to construct visualizations in Excel workbooks
tweak the title, formatting, and legend of a graph
alter the data displayed on the axes of a graph
alter the weight and line style of data series to customize the appearance of a visualization -
construct and modify bar chart visualizations in Excel
use openpyxl to build different types of bar charts programmatically
plot financial data containing open, high, low, close, and volume information about stock prices
use bubble charts to represent three dimensions of data in a two dimensional visualization
summarize the key concepts in this course
IN THIS COURSE
-
1m 30s
-
5m 25sFind out how to use Microsoft Excel to create visual representations of data. FREE ACCESS
-
3. Programmatically Constructing Line Charts5m 42sLearn how to use openpyxl to construct visualizations in Excel workbooks. FREE ACCESS
-
4. Customizing Chart Appearance4m 21sIn this video, you will change the title, formatting, and legend of a graph. FREE ACCESS
-
5. Customizing Chart Axes8m 25sIn this video, you will learn how to change the data displayed on the axes of a graph. FREE ACCESS
-
6. Using Line Styles6m 27sIn this video, you will learn how to change the weight and line style of data series to customize the appearance of a visualization. FREE ACCESS
-
7. Plotting Data with Bar Charts7m 18sIn this video, you will learn how to construct and modify bar chart visualizations in Excel. FREE ACCESS
-
8. Programmatically Constructing Bar Charts5m 48sFind out how to use openpyxl to build different types of bar charts. FREE ACCESS
-
9. Plotting Financial Data9m 14sLearn how to plot financial data containing open, high, low, close, and volume information about stock prices. FREE ACCESS
-
10. Plotting Bubble Charts5m 37sLearn how to use bubble charts to represent three dimensions of data in a two-dimensional visualization. FREE ACCESS
-
11. Course Summary1m 10s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
