Excel with Python: Constructing Data Visualizations

Python 3.7    |    Intermediate
  • 11 Videos | 1h 55s
  • Includes Assessment
  • Earns a Badge
Likes 31 Likes 31
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

  • Playable
    1. 
    Course Overview
    1m 30s
    UP NEXT
  • Playable
    2. 
    Plotting Data with Line Charts
    5m 25s
  • Locked
    3. 
    Programmatically Constructing Line Charts
    5m 42s
    FREE ACCESS
  • Locked
    4. 
    Customizing Chart Appearance
    4m 21s
    FREE ACCESS
  • Locked
    5. 
    Customizing Chart Axes
    8m 25s
    FREE ACCESS
  • Locked
    6. 
    Using Line Styles
    6m 27s
    FREE ACCESS
  • Locked
    7. 
    Plotting Data with Bar Charts
    7m 18s
    FREE ACCESS
  • Locked
    8. 
    Programmatically Constructing Bar Charts
    5m 48s
    FREE ACCESS
  • Locked
    9. 
    Plotting Financial Data
    9m 14s
    FREE ACCESS
  • Locked
    10. 
    Plotting Bubble Charts
    5m 37s
    FREE ACCESS
  • Locked
    11. 
    Course Summary
    1m 10s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

BOOK Data Science Bookcamp
COURSE Core Statistical Concepts: Statistics & Sampling with Python
COURSE Python - Using Pandas for Visualizations and Time-Series Data
Likes 66 Likes 66  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Functions in Python: Working with Advanced Features of Python Functions
Likes 274 Likes 274  
COURSE Excel with Python: Working with Excel Spreadsheets from Python
Likes 86 Likes 86  
COURSE Complex Data Types in Python: Working with Dictionaries & Sets in Python
Likes 747 Likes 747