Data Visualization in Excel: All Excel Charts and Graphs
All LevelsBusinessExcel Charts

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

Created by Start-Tech Academy
4.5 hours
Video Content
52
Lectures
164,001
Students
4.4
Rating
4.4
(164,001 students enrolled)

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

Course Content

9 sections • 52 lectures • 04:30:07 total length

Introduction and basics

7 lectures • 22:02

Welcome to the Course!02:53
Why are charts used?02:11
Course Resources00:04
This is a milestone!03:31
Categories of messages that can be conveyed04:34
+4 more lectures

Most important Charts & Best practices

24 lectures • 02:29:50

Bar and column charts12:38
Formating charts15:13
Exercise 1: Bar and Column Charts00:12
Best Practices: Bar Chart10:07
Line Charts09:04
+24 more lectures

Pivot charts

3 lectures • 14:07

Pivot table08:53
Pivot Charts05:05
Exercise 9: Pivot charts00:09
Quiz2 questions

Less used charts

4 lectures • 26:28

Stock charts11:28
Quiz1 question
Radar charts04:51
Surface charts05:14
Heatmaps04:55
+1 more lectures

Sparklines

2 lectures • 05:54

Mini charts: Sparklines05:43
Exercise 10: Sparklines00:11
Practice Test 110 questions

Infographics using Excel charts

2 lectures • 21:03

Creative Infographic 114:12
Creative Infographic 206:51
Quiz1 question

New! Maps chart - Excel 2019 and above

1 lectures • 10:00

Maps chart10:00

Appendix: Bonus Excel functionalities

6 lectures • 17:31

Essential Excel functions00:12
How to solve transportation problem using Excel Goal-Seek12:17
Practical Task 101:45
Quiz4 questions
Practical Task 201:51
+3 more lectures

Congratulations & about your certificate

3 lectures • 03:10

The final milestone!01:33
About your certificate00:24
Bonus Lecture01:13

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

This course includes:

  • 4.5 hours on-demand video
  • 18 articles
  • 52 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructor

Start-Tech Academy

Students also download

Explore related courses to expand your learning journey.