Data Visualization in Excel: All Excel Charts and Graphs
4.2 (622 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
51,175 students enrolled

Data Visualization in Excel: All Excel Charts and Graphs

25+ Excel charts and graphs - Data Visualization in Microsoft Excel - visualizing data with Excel 2007- Excel 2019
4.2 (626 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
51,175 students enrolled
Last updated 5/2020
English
English [Auto-generated]
Current price: $17.99 Original price: $29.99 Discount: 40% off
23 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 12 articles
  • 49 downloadable resources
  • 2 Practice Tests
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn the techniques to communicate clear and concise message through your charts
  • Learn how to create 25+ chart types in Excel
  • Learn by Doing. Course comes with numerous exerises sheets to practice learnt concepts
  • Master the art of creating impactful Excel charts
  • Get familiar with all the elements of charts in Excel
  • Become proficient in using powerful tools such as pivot tables and pivot charts
  • Master newly introduced chart types such as sunburst, treemap and waterfall chart
  • Learn how to create cool infographics to represent data
Requirements
  • You will need a PC with any version of Excel installed in it
  • Basic understanding of Excel operations like opening, closing and saving a file
Description

What are the chart types I will learn in this course?

Excel offers the following major chart types. All of these are covered in this course

  •     Column Chart

  •     Line Chart

  •     Pie Chart

  •     Doughnut Chart

  •     Bar Chart

  •     Area Chart

  •     XY (Scatter) Chart

  •     Bubble Chart

  •     Stock Chart

  •     Surface Chart

  •     Radar Chart

  •     Combo Chart

  •     Pivot Chart

  •     Sparklines

And many other creative ones :)


How are charts useful in Excel?

A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.


What are the benefits of using charts in Excel?

Excel charts allow spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, users can easily create various types of charts in which the data is displayed in a graphical way.


This course will answer all the questions that would pop up while you set to visualize your data using Excel charts such as:

How do you make Excel charts look better?

How do you format a chart in Excel?

What are the different elements of charts?

How do I make those awesome infographics that I see in fancy magazines and TV reports?

How do I create a comparison chart in Excel?

What is the best chart to use for comparison?

And many more...


How is this course different from other resources available online?

Most courses cover only teach how to draw different types of charts in Excel. The main point is missed. The main point of creating a chart is that you want to convey a message or tell a story using the chart. In this course, once you have learnt all the charting tools, you will also learn how you should create a chart. How you can highlight your message and avoid clutter in the chart, so that when your audience looks at the chart, the message is clearly conveyed to them.


Who this course is for:
  • Anyone curious to master charts in excel from beginner to advanced in short span of time
Course content
Expand all 44 lectures 04:28:19
+ Introduction and basics
6 lectures 18:31

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will discuss the content of this course. We will also discuss about the course prerequisites.

Preview 02:53

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about

Why are charts used?
02:11
Course Resources
00:04

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about

Categories of messages that can be conveyed
04:34
Quiz
1 question

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the different elements of Excel charts. Understanding of these elements will helps us in formatting in later part of the course.

Preview 05:32

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about creating the excel charts using just one mouse click.

The Easy way of creating charts
03:17
Quiz 1
2 questions
+ Most important Charts & Best practices
24 lectures 02:29:50

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the most common chart type. Column chart displays each data point

as a vertical column, the height of which corresponds to the value.

Preview 12:38

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the different chart formatting options available in Excel

Formating charts
15:13

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Bar and column Charts.

Exercise 1: Bar and Column Charts
00:12

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the best practices of using bar charts.

Best Practices: Bar Chart
10:07

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Line Charts. Line charts are often used to plot continuous data and are useful for identifying trends.

Line Charts
09:04
Quiz
1 question

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Speghetti plot (a type of line chart) and how to replace that with more informative charts.

Avoiding the Spaghetti plot
05:27

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Line Charts.

Exercise 2: Line Charts
00:11

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Area Charts. Area charts are line chart in which the area below the line has been colored in.

Area Charts
06:04

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Pie and Doughnut Charts. A pie chart is useful when you want to show relative proportions or contributions to a whole.

Pie and Doughnut Charts
13:04

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about why we should avoid Pie charts.

Why we should avoid Pie charts!
04:05

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Pie Charts.

Exercise 3: Pie Charts
00:13
Quiz
1 question

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Scatter (XY) plots. This type of chart often is used to show the relationship between two variables.

Scatter plot or XY chart
16:17

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Scatter Charts.

Exercise 4: Scatter plot
00:09

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn aboutFrequency distribution and Histograms. A histogram displays the count of data items in each of several discrete bins.

Frequency Distribution and Histograms
13:03

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Histogram Charts.

Exercise 5: Histogram
00:09

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Waterfall Charts. A waterfall chart is used to show the cumulative effect of a series of numbers, usually both positive and negative numbers.

Waterfall chart
12:00

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Waterfall Charts.

Exercise 6: Waterfall chart
00:12

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Sunburst and Treemap charts. A sunburst chart is like a pie chart with multiple concentric layers. In a treemap chart the data is represented as rectangles. These chart types are most useful for data that’s organized hierarchically.

Hierarchy Charts: Sunburst and Treemap
07:57

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Hierarchy Charts.

Exercise 7: Hierarchy charts
00:09

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about how to combine two or more chart types in a single chart.

Combination charts
07:32

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Combine Charts.

Exercise 8: Combination Charts
00:08
Quiz
1 question

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the advanced techniques of highlighting message in charts.

Highlighting chart message
03:25

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the best practices of using Line Charts

Eliminating Distractions from the Graph
06:54

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about how to avoid clutter from our charts.

Avoiding clutter
05:35
[Optional] Test for your general excel knowledge
18 questions
+ Pivot charts
3 lectures 16:22

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the Pivot Charts.

Pivot Charts
07:48

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the basics of Pivot Table.

Pivot Table Basics
08:25
Exercise 9: Pivot charts
00:09
Quiz 2
2 questions
+ Less used charts
4 lectures 26:28

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Stock Charts. Stock charts are most useful for displaying stock-market information.

Stock charts
11:28

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about the Radar chart. A radar chart is a specialized chart that has a separate axis for each category,

Radar charts
04:51

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Surface Charts. Surface charts display two or more data series on a surface.

Surface charts
05:14

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Heatmaps. Heatmap are not a chart but it can used as an substitute to the surface charts.

Heatmaps
04:55
+ Sparklines
2 lectures 05:54

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn about Sparklines. Sparklines are like mini charts which resides inside a cell.

Mini charts: Sparklines
05:43

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

Try this exercise to gauge your knowledge of Sparklines.

Exercise 10: Sparklines
00:11
Practice Test 1
10 questions
+ Infographics using Excel charts
2 lectures 21:03

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn how to draw cool info-graphs in excel

Creative Infographic 1
14:12

Welcome to the data visualization course using excel : 'Excel charts: Converting Data into Impactful Charts'

In this lecture we will learn how to draw cool info-graphs in excel.

Creative Infographic 2
06:51
+ Appendix: Bonus Excel functionalities
2 lectures 29:41
How to solve transportation problem using Excel Goal-Seek
12:17
Income Tax calculation - Slabs based tax
17:24