Charting Data with Excel

Focused View

Carlos Gutierrez

1:39:13

37 View

01 - Course Overview

01 - Course Overview.mp4

01:22

02 - Choosing, Creating, and Changing Chart Types#

02 - Introduction and Module Overview.mp4

01:37

03 - Bar Chart.mp4

02:21

04 - Column Chart.mp4

02:21

05 - Line Chart.mp4

02:21

06 - Area Chart.mp4

01:39

07 - Pie Chart.mp4

02:27

08 - Summary.mp4

01:55

03 - Enhancing the Column Chart with Data Series#

09 - Introduction.mp4

01:48

10 - Clustered Column Chart.mp4

01:46

11 - Demo - Clustered Column Chart.mp4

02:10

12 - Stacked Column Chart.mp4

01:01

13 - Demo - Stacked Column Chart.mp4

02:42

14 - 100% Stacked Column Chart.mp4

01:16

15 - Demo - 100% Stacked Column Chart.mp4

03:21

16 - Column Chart Comparison.mp4

02:16

17 - Summary.mp4

01:38

04 - Extracting Insights from the Line Chart#

18 - Introduction.mp4

01:52

19 - Secondary Axis.mp4

02:09

20 - Demo - Secondary Axis & Combo Chart.mp4

04:57

21 - Linear Trendline.mp4

04:11

22 - Demo - Linear Trendline.mp4

01:53

23 - Additional Trendline Options.mp4

02:42

24 - Demo - Moving Average Trendline.mp4

02:05

25 - Summary.mp4

01:28

05 - Exploring Specialized Visuals for Categorical Data#

26 - Introduction.mp4

01:06

27 - Funnel Chart.mp4

03:34

28 - Waterfall Chart.mp4

03:51

29 - Radar Chart.mp4

02:05

30 - Hierarchical Charts.mp4

05:32

31 - Box and Whisker Chart.mp4

02:53

32 - Stock Chart.mp4

02:18

33 - Summary.mp4

01:29

06 - Exploring Specialized Visuals for Continuous Data#

34 - Introduction.mp4

00:59

35 - Histogram.mp4

04:30

36 - Scatter and Bubble Chart.mp4

06:02

37 - Map.mp4

03:19

38 - Summary.mp4

01:17

07 - Continue Learning Excel

39 - Key Concepts.mp4

02:03

40 - References.mp4

02:57

Description

It is often difficult to read and understand complex data by looking at a big table of numbers. Using Excel's rich charting tools, you will learn how to transform data into compelling visuals and uncover the important insights.

What You'll Learn?

Data is an increasingly important part of our organizations, and it's critical that you learn how to effectively communicate and visualize this information. In this course, Charting Data with Excel, you will gain the ability to work with several fundamental components of Excel's charting tools. First, you will learn how to create and change charts. Next, you will discover how to work with multiple data series. Finally, you will explore how to enhance your charts with features like trendlines and secondary axes. When you are finished with this course, you will have the skills and knowledge of Excel charts needed to build a dashboard full of interesting visuals for your data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Charts

Carlos Gutierrez

Instructor's Courses

Carlos Gutierrez is a Software Engineer working in the highly competitive world of professional motorsports. His career is focused on data analysis and application development for technical collaboration and decision making. Carlos uses SQL Server, .NET Framework, WPF, UWP, Office 365, R and Azure to build end-to-end solutions for a fast paced, dynamic industry.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.