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.30 (1684 reviews)
Udemy
platform
English
language
Data & Analytics
category
149,247
students
4.5 hours
content
Jul 2022
last update
$19.99
regular price

What you will 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

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.


Screenshots

Data Visualization in Excel: All Excel Charts and Graphs - Screenshot_01Data Visualization in Excel: All Excel Charts and Graphs - Screenshot_02Data Visualization in Excel: All Excel Charts and Graphs - Screenshot_03Data Visualization in Excel: All Excel Charts and Graphs - Screenshot_04

Content

Introduction and basics

Welcome to the Course!
Why are charts used?
Course Resources
Categories of messages that can be conveyed
Elements of charts
The Easy way of creating charts
Quiz 1

Most important Charts & Best practices

Bar and column charts
Formating charts
Exercise 1: Bar and Column Charts
Best Practices: Bar Chart
Line Charts
Avoiding the Spaghetti plot
Exercise 2: Line Charts
Area Charts
Pie and Doughnut Charts
Why we should avoid Pie charts!
Exercise 3: Pie Charts
Scatter plot or XY chart
Exercise 4: Scatter plot
Frequency Distribution and Histograms
Exercise 5: Histogram
Waterfall chart
Exercise 6: Waterfall chart
Hierarchy Charts: Sunburst and Treemap
Exercise 7: Hierarchy charts
Combination charts
Exercise 8: Combination Charts
Quiz
Highlighting chart message
Eliminating Distractions from the Graph
Avoiding clutter
[Optional] Test for your general excel knowledge

Pivot charts

Pivot Charts
Pivot Table Basics
Exercise 9: Pivot charts
Quiz 2

Less used charts

Stock charts
Radar charts
Surface charts
Heatmaps

Sparklines

Mini charts: Sparklines
Exercise 10: Sparklines
Practice Test 1

Infographics using Excel charts

Creative Infographic 1
Creative Infographic 2

Bonus Section

Bonus Lecture

Appendix: Bonus Excel functionalities

How to solve transportation problem using Excel Goal-Seek
Income Tax calculation - Slabs based tax

Reviews

Maureencici
June 22, 2022
very detailed. but its a little difficult for me to understanding the tutor's speech. Makes me sleepy
Jason
June 1, 2022
Yes, this course was a good match for me. I had a hard time understanding some of the lecture because of the accent. Even the captioning did not match the dialog, but I was able to get enough out of the lessons to pass the quizzes and test. Thank you.
Riki
February 17, 2022
Very basic information about graphs. Shows how to create one, but does not go very deep. For beginners. If you need advanced, this is not the course.
K
December 9, 2021
Exactly what I needed: a straightforward, succinct overview of Excel's data visualization options so that I can jump in and explore the ones relevant to my work without struggling to find all the settings. The no-nonsense introduction to pivot charts and tables (surprisingly simple!) was an unexpected bonus. Excellent value.
Birat
November 27, 2021
Thankyou for providing this course specifically on visualization. my experience with the course was great. I would say I found the pacing a little off but that may be because of the accent. But, everything else was above from my expect specially the infographic part, I didn't expected that. Overall, I would say this is a great start if you want to learn more about graphs and plots.
Abosede
September 30, 2021
Yes this course is a good match for me in the sense that it is easy to comprehend. The categories of message that can be conveyed in section 5 is exceptionally useful for me.
Eva
August 25, 2021
Indisch-Englisch, aber gut zu verstehen. Einige interessante Anregungen zur gezielten Verwendung der Diagrammtypen aber bis auf eine Lektion nicht wirklich kreativ, eher eine Demonstration der xls Voreinstellungen. Ich hatte mir mehr versprochen, aber für andere mag der Kurs genau richtig sein, vor allem, wenn man noch nicht mit Diagrammen gearbeitet hat.
Parag
May 28, 2021
The explanation given by tutor from the using of Udemy platform to downloading the certificate was good. Learned some new functions in Excel which can be useful for presentations.
Sanjana
May 21, 2021
This course is beneficial if you want to enhance your knowledge of Graphs and other presentation skills backed with practice resources and quizes as well.
Soham
April 28, 2021
This course is so precise for every curious person who is willing to gain the insight of the MS-Excel. The course has provided a lot of examples for practice with the solutions which makes the entire learning experience a memorable one!
David
April 22, 2021
Enjoyable course - with some great working examples and advice on best practice. will defuse this in future. clear and concise and well paced from a knowledgeable teacher. Recommended to others without hesitation
andre
March 16, 2021
The instructor is honest, clearly define the goal of this course and put some motivations to us to continue learning.
Emmanuel
March 1, 2021
This course is loaded. I will recommend to anyone willing to learn about Data Visualization in Excel.
Carlos
February 21, 2021
Great course to learn all kinds of charts in excel. You must have a previous knowledge on Excel to take this course. Presentations and Excel files are not organised. Also, there are some exercises that are not clear enough. Leaving that aside it is a great course.
Raj
January 30, 2021
Good Course! Excel is a powerful tool. I am sure learning and exploring it with aid I got from this course will be quite helpful to me in future times.

Charts

Price

Data Visualization in Excel: All Excel Charts and Graphs - Price chart

Rating

Data Visualization in Excel: All Excel Charts and Graphs - Ratings chart

Enrollment distribution

Data Visualization in Excel: All Excel Charts and Graphs - Distribution chart

Coupons

DateDiscountStatus
11/16/2019100% OFF
expired
11/25/2019100% OFF
expired
2/25/2020100% OFF
expired
3/6/2020100% OFF
expired
3/13/2020100% OFF
expired
4/13/2020100% OFF
expired
4/21/2020100% OFF
expired
4/25/2020100% OFF
expired
5/2/2020100% OFF
expired
5/16/2020100% OFF
expired
5/21/202067% OFF
expired
6/2/2020100% OFF
expired
6/12/2020100% OFF
expired
9/16/202095% OFF
expired
11/4/2020100% OFF
expired
12/6/2020100% OFF
expired
12/24/2020100% OFF
expired
1/24/2021100% OFF
expired
1/30/2021100% OFF
expired
2/10/2021100% OFF
expired
3/14/2021100% OFF
expired
4/20/2021100% OFF
expired
5/11/2021100% OFF
expired
8/19/202150% OFF
expired
9/5/2021100% OFF
expired
9/25/2021100% OFF
expired
11/15/2021100% OFF
expired
11/22/2021100% OFF
expired
1/19/202250% OFF
expired
2/2/2022100% OFF
expired
2/21/2022100% OFF
expired
4/4/2022100% OFF
expired
4/15/2022100% OFF
expired
4/25/2022100% OFF
expired
5/14/2022100% OFF
expired
5/25/2022100% OFF
expired
6/16/2022100% OFF
expired
6/18/2022100% OFF
expired
7/1/2022100% OFF
expired
7/7/2022100% OFF
expired
7/16/2022100% OFF
expired
7/30/2022100% OFF
expired
2312766
udemy ID
4/8/2019
course created date
11/16/2019
course indexed date
Bot
course submited by