Data Visualization with Excel Course (How To)

Introduction To Data Visualization

Learn why data visualization is important, and get started creating charts in Excel right away.

• Overview of Data Visualization

  3:50

• Creating a Chart in Excel

  4:51

• Changing the Order of Your Bar Chart

  2:28

• Different Types of Charts in Excel

  0:54

• Introduction to Data Visualization Review

  5 questions

When To Use What Type of Chart

Learn about some of the different types of charts in Excel, and how to chose which chart to use.

• A Column or a Bar

  1:36

• Why A Column Instead of Bar

  4:03

• Line Charts

  3:32

• Area and Stacked Area Charts

  5:23

• Stacked Charts Continued and 100% Stacked Charts

  3:11

• Pie Charts

  3:31

• Scatter Plots

  2:07

• The CORREL Function

  2:10

• Different Types of Charts Review

  5 questions

Chart Formatting and Layout

Learn about the layout, formatting, and different elements of charts in Excel.

• Chart & Plot Area

  3:41

• Chart Title

  1:09

• Axis Labels

  1:59

• Data Tables

  1:10

• Data Labels

  2:30

• Lines

  1:34

• Legends

  1:09

• Trendlines

  1:39

• Chart Design

  1:13

• Changing Colors For a Data Series or Point

  2:44

• Line Markers

  1:56

• Create A Chart Format Template

  3:09

• Chart Formatting and Layout Review

  5 questions

Practicing Data Visualization in Excel

Put the lessons learned in earlier stages to the test by solving these practice problems.

• Practice: Total Sales

  1:23

• Solution: Total Sales

  4:30

• Practice: Sales Details

  0:23

• Solution: Sales Details

  8:51

• Practice: Population Growth

  0:51

• Solution: Population Growth

  5:10

• Data Visualization Final Review

  7 questions