Data Visualization with Excel

Treehouse

Course Summary

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.

+
Course Description
About this Course 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
About the Teacher
Michael Watson is the CFO & COO of Treehouse. Before joining Treehouse he worked in private equity in Asia. He is a graduate of Tufts University and has an MBA from INSEAD. He loves sports and the great outdoors.

Course Description

About this Course 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

About the Teacher
Michael Watson is the CFO & COO of Treehouse. Before joining Treehouse he worked in private equity in Asia. He is a graduate of Tufts University and has an MBA from INSEAD. He loves sports and the great outdoors.

+
Course Syllabus
Introduction To Data Visualization
Learn why data visualization is important, and get started creating charts in Excel right away. 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. 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. 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. 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