HOT

Data Visualization in Excel: All Excel Charts and Graphs

Business

Rating4.5
Enroll Now

Data Visualization in Excel: All Excel Charts and Graphs, available at $84.99, has an average rating of 4.47, with 54 lectures, 12 quizzes, based on 2085 reviews, and has 161484 subscribers.

You will learn about 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 This course is ideal for individuals who are Anyone curious to master charts in excel from beginner to advanced in short span of time It is particularly useful for Anyone curious to master charts in excel from beginner to advanced in short span of time.

Enroll now: Data Visualization in Excel: All Excel Charts and Graphs

Summary

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

Price: $84.99

Average Rating: 4.47

Number of Lectures: 54

Number of Quizzes: 12

Number of Published Lectures: 48

Number of Published Quizzes: 12

Number of Curriculum Items: 66

Number of Published Curriculum Objects: 60

Number of Practice Tests: 2

Number of Published Practice Tests: 2

Original Price: $19.99

Quality Status: approved

Status: Live

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

Who Should Attend

  • Anyone curious to master charts in excel from beginner to advanced in short span of time

Target Audiences

  • Anyone curious to master charts in excel from beginner to advanced in short span of time

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.

Course Curriculum

Chapter 1: Introduction and basics

Lecture 1: Welcome to the Course!

Lecture 2: Why are charts used?

Lecture 3: Course Resources

Lecture 4: This is a milestone!

Lecture 5: Categories of messages that can be conveyed

Lecture 6: Elements of charts

Lecture 7: The Easy way of creating charts

Chapter 2: Most important Charts & Best practices

Lecture 1: Bar and column charts

Lecture 2: Formating charts

Lecture 3: Exercise 1: Bar and Column Charts

Lecture 4: Best Practices: Bar Chart

Lecture 5: Line Charts

Lecture 6: Avoiding the Spaghetti plot

Lecture 7: Exercise 2: Line Charts

Lecture 8: Area Charts

Lecture 9: Pie and Doughnut Charts

Lecture 10: Why we should avoid Pie charts!

Lecture 11: Exercise 3: Pie Charts

Lecture 12: Scatter plot or XY chart

Lecture 13: Exercise 4: Scatter plot

Lecture 14: Frequency Distribution and Histograms

Lecture 15: Exercise 5: Histogram

Lecture 16: Waterfall chart

Lecture 17: Exercise 6: Waterfall chart

Lecture 18: Hierarchy Charts: Sunburst and Treemap

Lecture 19: Exercise 7: Hierarchy charts

Lecture 20: Combination charts

Lecture 21: Exercise 8: Combination Charts

Lecture 22: Highlighting chart message

Lecture 23: Eliminating Distractions from the Graph

Lecture 24: Avoiding clutter

Chapter 3: Pivot charts

Lecture 1: Pivot table

Lecture 2: Pivot Charts

Lecture 3: Exercise 9: Pivot charts

Chapter 4: Less used charts

Lecture 1: Stock charts

Lecture 2: Radar charts

Lecture 3: Surface charts

Lecture 4: Heatmaps

Chapter 5: Sparklines

Lecture 1: Mini charts: Sparklines

Lecture 2: Exercise 10: Sparklines

Chapter 6: Infographics using Excel charts

Lecture 1: Creative Infographic 1

Lecture 2: Creative Infographic 2

Chapter 7: New! Maps chart – Excel 2019 and above

Lecture 1: Maps chart

Chapter 8: Appendix: Bonus Excel functionalities

Lecture 1: Essential Excel functions

Lecture 2: How to solve transportation problem using Excel Goal-Seek

Chapter 9: Congratulations & about your certificate

Lecture 1: The final milestone!

Lecture 2: About your certificate

Lecture 3: Bonus Lecture

Instructors

Rating Distribution

  • 1 stars: 22 votes
  • 2 stars: 51 votes
  • 3 stars: 302 votes
  • 4 stars: 826 votes
  • 5 stars: 884 votes

Frequently Asked Questions


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!

You may also like

Master Lead Generation: Grow Subscribers & Sales with Popups

Create CONVERTING UGC Content So Brands Will Pay You More

TikTok Marketing Mastery: Learn to Grow & Go Viral