Data Visualization with Excel

Focused View

Michael Watson

1:22:39

262 View

01. Introduction To Data Visualization

01_01-Overview of Data Visualization.mp4

03:50

01_02-Creating a Chart in Excel.mp4

04:51

01_03-Changing the Order of Your Bar Chart.mp4

02:28

01_04-Different Types of Charts in Excel.mp4

00:54

02. When To Use What Type of Chart

02_01-A Column or a Bar.mp4

01:36

02_02-Why A Column Instead of Bar.mp4

04:03

02_03-Line Charts.mp4

03:32

02_04-Area and Stacked Area Charts.mp4

05:23

02_05-Stacked Charts Continued and 100 Stacked Charts.mp4

03:11

02_06-Pie Charts.mp4

03:32

02_07-Scatter Plots.mp4

02:07

02_08-The CORREL Function.mp4

02:10

03. Chart Formatting and Layout

03_01-Chart Plot Area.mp4

03:41

03_02-Chart Title.mp4

01:09

03_03-Axis Labels.mp4

01:59

03_04-Data Tables.mp4

01:10

03_05-Data Labels.mp4

02:30

03_06-Lines.mp4

01:34

03_07-Legends.mp4

01:09

03_08-Trendlines.mp4

01:40

03_09-Chart Design.mp4

01:13

03_10-Changing Colors For a Data Series or Point.mp4

02:44

03_11-Line Markers.mp4

01:56

03_12-Create A Chart Format Template.mp4

03:09

04. Practicing Data Visualization in Excel

04_01-Practice_ Total Sales.mp4

01:23

04_02-Solution_ Total Sales.mp4

04:30

04_03-Practice_ Sales Details.mp4

00:23

04_04-Solution_ Sales Details.mp4

08:51

04_05-Practice_ Population Growth.mp4

00:51

04_06-Solution_ Population Growth.mp4

05:10

Data Visualization With Excel

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Visualization

Excel

Michael Watson

Instructor's Courses

Michael Watson is the former 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.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.