Udemy

Platform

English

Language

Data & Analytics

Category

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.33 (1041 reviews)

86340

Students

4.5 hours

Content

Nov 2020

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
Data Visualization in Excel: All Excel Charts and Graphs
Data Visualization in Excel: All Excel Charts and Graphs
Data Visualization in Excel: All Excel Charts and Graphs

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

A
Asif2 October 2020

The course was good. Though I read that other people that took the course that the accent was hard to understand, it was not much of a problem for me. The only feedback that I have was that the background music was a little bit distracting but not too bad. Also, I noticed that the entire course had no notes from other users that would write notes at certain parts of the section. And lastly, very few of the sections had the wrong file. Other that that, It was a good course.

A
Alline24 July 2020

Agora me adaptei ao inglês e estou adorando o curso. O professor é super didático e o conteúdo muito rico. Parabéns professor!

R
Rajkumar5 July 2020

The trainer was very patient in explaining, few places slides are running differently and topics is about general.

S
SK.MD.IKRAM3 July 2020

AMAZING COURSE . I LEARNT A LOT OF THINGS ABOUT EXCEL IN THIS COURSE . ITS WORTH FOR PAYING . THE COURSE COORDINATOR IS VERY KNOWLEDGEABLE .

A
Ashik-Uz-Zaman27 June 2020

It was an amazing experience. Sufficient amount of topics have been covered here. A great deal of learning has been achieved.

P
Piyush14 June 2020

A smooth learning experience. One negative feedback will be the voice of lecturer is too low, can work on that!

U
Usman13 June 2020

Yes this course was very useful for me. I learned this basic chart nomenclature and purpose of data charting using excel

T
TANU3 June 2020

I just feel that these type of courses are somewhat of difficult. But, it's not correct. These lectures made it easy to me

A
Aashu3 June 2020

course content is not up to the mark. it seems like that course content is made in hurry. Except Few lecture most of the lecture's content is not covered in detail. Very poor explanation about topic and it seems like that Tutor is not in mood to share more knowledge regarding topic. Very disappointing.

S
Sultanul27 May 2020

Even though I know Excel charts, I learned about Waterfall and Sunburst charts which is a good thing. Learning is always good.

R
Reddy25 May 2020

Nice explanations. Exercises are the best part where we can learn practically. Thank you for providing an opportunity to improve my skill.

D
Devendra22 May 2020

Its a good use of time. In such short duration i understand all about charts which i totally unaware. Thanks.

A
Ajaykumar19 May 2020

The course was simple to understand and very effectively delivered. The content was precise and with case studies and examples. The test and practice sessions were also good.

K
Kirti17 May 2020

It was awesome to have knowledge about different types of charts that we could use in our professional life.

H
HP17 December 2019

Learnt a lot from this course. And this is actually helping me in my office work. Thanks for this course


Coupons

StatusDateDiscount
Expired11/16/2019100% OFF
Expired11/25/2019100% OFF
Expired2/25/2020100% OFF
Expired3/6/2020100% OFF
Expired3/13/2020100% OFF
Expired4/13/2020100% OFF
Expired4/21/2020100% OFF
Expired4/25/2020100% OFF
Expired5/2/2020100% OFF
Expired5/16/2020100% OFF
Expired5/21/202067% OFF
Expired6/2/2020100% OFF
Expired6/12/2020100% OFF
Expired9/16/202095% OFF
Expired11/4/2020100% OFF
Expired12/6/2020100% OFF
Expired12/24/2020100% OFF


2312766

Udemy ID

4/8/2019

Course created date

11/16/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore