Data Visualization with Excel Course: Free Online Course from Treehouse

This overview of Data Visualization in Excel is designed for absolute beginners, but can also benefit people who have already been using Excel to create charts. You will learn about the fundamentals of data visualization, how create types of charts in Excel, and tips on how to get the most of the charts you make.

What you'll learn
- Data visualization fundamentals
- Excel chart creation
- Excel chart vocabulary
- When to use what type of chart
- Formatting charts

Syllabus

Introduction To Data Visualization

Learn why data visualization is important, and get started creating charts in Excel right away.
Chevron 5 steps
- 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.
Chevron 9 steps
- 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.
Chevron 13 steps
- 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.
Chevron 7 steps
- 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

Data Visualization with Excel Course

What you'll learn

Introduction To Data Visualization

Overview of Data Visualization

Creating a Chart in Excel

Changing the Order of Your Bar Chart

Different Types of Charts in Excel

Introduction to Data Visualization Review

When To Use What Type of Chart

A Column or a Bar

Why A Column Instead of Bar

Line Charts

Area and Stacked Area Charts

Stacked Charts Continued and 100% Stacked Charts

Pie Charts

Scatter Plots

The CORREL Function

Different Types of Charts Review

Chart Formatting and Layout

Chart & Plot Area

Chart Title

Axis Labels

Data Tables

Data Labels

Lines

Legends

Trendlines

Chart Design

Changing Colors For a Data Series or Point

Line Markers

Create A Chart Format Template

Chart Formatting and Layout Review

Practicing Data Visualization in Excel

Practice: Total Sales

Solution: Total Sales

Practice: Sales Details

Solution: Sales Details

Practice: Population Growth

Solution: Population Growth

Data Visualization Final Review

3D Wooden Textiles for Beginners

Digital Brand Strategy: Elevate The User Experience

Flavorful Food Illustration with Watercolor

FPGA computing systems: Background knowledge and introductory materials

Freehand Sketching with Acrylic and Watercolor

Fundamentals of the Chinese character writing. Part 2