Data Visualization in Excel: All Excel Charts and Graphs

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.

Most important Charts & Best practices

Pivot charts

Less used charts

Sparklines

Infographics using Excel charts

New! Maps chart - Excel 2019 and above

Appendix: Bonus Excel functionalities

55

Maps chart

Video lesson

Congratulations & about your certificate

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!

4.39

2078 reviews

Please, login to leave a review

Stars 5

880

Stars 4

823

Stars 3

302

Stars 2

Stars 1