Excel Charts - Excel Charts and Graphs Basic Training

Learn how to use Excel 2013 to create impressive data visualizations - ExcelChart and Graphs Basic Training
3.7 (25 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,316 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 30
  • Length 3 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2015 English

Course Description

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.

What are the requirements?

  • 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

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
02:39
14:52

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

11:11

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

Chart Types
4 questions
Course Datasets
Article
Section 2: General Tools
05:42

Learn about the basic features of the insert tab.

08:17

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

06:00

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

03:13

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

10:17

Learn how to format chart axes.

07:52

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

Section 3: Chart Types in Detail
09:29

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

07:49

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

03:57

Learn about scatterplots with Excel.

05:05

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

04:07

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

03:26

How to create area charts in Excel 2013.

04:51

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.

02:57

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

02:11

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

Section 4: Bonus Lectures: New Chart Types in Excel 2016
Introduction to New Charts
01:23
Statistical Charts 1: Histogram
05:05
Histogram - alternative method
07:20
Statistical Charts 2: Pareto Chart
04:16
Pareto Chart - alternative method
06:22
Statistical Charts 3: Box and Whisker Plot
05:21
Hierarchical Charts 1: Treemap
04:19
Hierarchical Charts 2: Sunburst
02:37
Which one should I choose? Treemap vs. Sunburst
02:03
Finance: Waterfall Chart
06:46
Waterfall Chart - alternative method
10:42

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

R-Tutorials Training, 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.

Ready to start learning?
Take This Course