Excel Charts - Excel Charts and Graphs Basic Training
4.1 (31 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,378 students enrolled
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.1 (31 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,378 students enrolled
Last updated 6/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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
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.

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
+
Introduction
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?
11:11

Chart Types
4 questions

Course Datasets
00:13
+
General Tools
6 Lectures 41:21

Learn about the basic features of the insert tab.

Excel Basic Tools - Insert Tab
05:42

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

Our First Chart - Pie Charts
08:17

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

Excel Basic Tools - Design Tab
06:00

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

Excel Basic Tools - Chart Buttons
03:13

Learn how to format chart axes.

Chart Axes
10:17

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

Exercise - Editing Tools
07:52
+
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
09:29

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

Doughnut Charts
07:49

Learn about scatterplots with Excel.

Scatterplots
03:57

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

Bubble Charts
05:05

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

Line Charts
04:07

How to create area charts in Excel 2013.

Area Charts
03:26

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
04:51

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

Column or Bar Charts - Paired Data
02:57

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

Dynamic Charts with Tables
02:11
+
Bonus Lectures: New Chart Types in Excel 2016
11 Lectures 56:14
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
About the Instructor
R-Tutorials Training
4.4 Average rating
4,423 Reviews
52,920 Students
16 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.