Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel Charts - Excel Charts and Graphs Basic Training to your Wishlist.

Add to Wishlist

Excel Charts - Excel Charts and Graphs Basic Training

Learn how to use Excel 2013 to create impressive data visualizations - ExcelChart and Graphs Basic Training
4.3 (29 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,351 students enrolled
Last updated 11/2015
$10 $20 50% off
2 days left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
create the most common type of charts in Excel
know which chart to use for a given dataset
perform standard format changes in charts
use Excel 2013 confidently for charts and graphs
View Curriculum
  • Excel 2013 is required - but the previous Excel version has similar features so you might also use your knowledge with the 2010 version
  • interest in data visualization
  • a basic understanding of charts and graphs

Do you work with charts but struggle to identify which chart to use?

Are you new to data analysis?

Do you want to learn about the charting options Excel 2013/2010 offers?

Are you looking for a structured way to learn about the Excel charting tools?

If your answer was YES to some of the questions, this course might be of interest to you.

When I created this course I put full emphasis on a structured and didactically sound way to gently show you how data visualization in Excel 2013 works. This course is especially suited towards a beginners audience to data visualization with Excel.

Most of the concepts of this course also apply to Excel 2010, so you might also consider this course if you are on 2010.

Beginners to data analysis often need a clear understanding of which chart type is suitable for a given dataset. I will give you this important knowledge right at the beginning so that you know from the start what you are dealing with and how you can utilize that knowledge.

I will also show you step by step all you need to know about the basic chart formatting tools. You will learn how to add elements, format axes, change colors and so on.

There is also a section about the frequently used types of charts and how you can easily create them in Excel.

At the end of this beginners course you should be confident in using Excel for standard charts. You will be also able to format already existing charts and tailor them in accordance with your needs.

I highly recommend to take a close look at the introductory videos on which type of chart to use for a given circumstance. Only if you know which chart type is suitable for a dataset will you be able to make full use of the many options Excel has to offer.

Who is the target audience?
  • Everybody interested in data visualization
  • Everybody willing to try out the material at home and solve the exercises
  • Everybody starting out to work with Excel
  • Everybody needing charts for work or study purposes
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 30 Lectures Collapse All 30 Lectures 02:50:24
4 Lectures 28:55

Learn about the types of charts and the underlying datasets. Part 1

Preview 14:52

Learn about the types of charts and the underlying datasets. Part 2

Chart Types - Which chart should I use?

Chart Types
4 questions

Course Datasets
General Tools
6 Lectures 41:21

Learn about the basic features of the insert tab.

Excel Basic Tools - Insert Tab

Step by step I will guid you through our first plot - a pie chart.

Our First Chart - Pie Charts

In this video I will guide you through all the features of the Excel Design tab.

Excel Basic Tools - Design Tab

Learn about the 3 buttons on the right side of your chart.

Excel Basic Tools - Chart Buttons

Learn how to format chart axes.

Chart Axes

Try to resemble the graph I created in this exercise. You can find the dataset in the course file.

Exercise - Editing Tools
Chart Types in Detail
9 Lectures 43:52

In this video you will learn about an advanced Pie Chart type.

Pie of a Pie Chart

You will learn about the Doughnut chart - a variety of the Pie chart.

Doughnut Charts

Learn about scatterplots with Excel.


Bubble charts are related to scatterplots but an extra variable can be incorporated.

Bubble Charts

Line charts are a perfect way to display time series data.

Line Charts

How to create area charts in Excel 2013.

Area Charts

Try to solve the exercise in this lecture. You can also find the solution to it at the end of the video. The dataset is in the course file.

Exercise - Lynx Trappings

You will learn how you can create charts with paired data.

Column or Bar Charts - Paired Data

Learn about dynamic charts which enable you to auto update your charts.

Dynamic Charts with Tables
Bonus Lectures: New Chart Types in Excel 2016
11 Lectures 56:14
Introduction to New Charts

Statistical Charts 1: Histogram

Histogram - alternative method

Statistical Charts 2: Pareto Chart

Pareto Chart - alternative method

Statistical Charts 3: Box and Whisker Plot

Hierarchical Charts 1: Treemap

Hierarchical Charts 2: Sunburst

Which one should I choose? Treemap vs. Sunburst

Finance: Waterfall Chart

Waterfall Chart - alternative method
About the Instructor
4.4 Average rating
3,469 Reviews
46,030 Students
15 Courses
Data Science Education

R-Tutorials is your provider of choice when it comes to analytics training courses! Try it out – our 30,000+ students love it.

We focus on Data Science tutorials. Offering several R courses for every skill level, we are Udemy's number one R training provider. On top of that courses on Tableau, Excel and a Data Science career guide are available.

All of our courses contain exercises to give you the opportunity to try out the material on your own. You will also get downloadable script pdfs to recap the lessons.

The courses are taught by our main instructor Martin – trained biostatistician and enthusiastic data scientist / R user.

Should you have any questions, you are invited to check out our website, you can open a discussion in the course or you can simply drop us a pm.

We are there to help you boost your career with analytics training – Just learn and enjoy.

Report Abuse