Excel Charts – Excel Charts and Graphs Basic Training

Excel Charts – Excel Charts and Graphs Basic Training , available at $59.99, has an average rating of 4.55, with 30 lectures, 1 quizzes, based on 1654 reviews, and has 7987 subscribers.

You will learn about 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 This course is ideal for individuals who are Everybody interested in data visualization or Everybody willing to try out the material at home and solve the exercises or Everybody starting out to work with Excel or Everybody needing charts for work or study purposes It is particularly useful for Everybody interested in data visualization or Everybody willing to try out the material at home and solve the exercises or Everybody starting out to work with Excel or Everybody needing charts for work or study purposes.

Enroll now: Excel Charts – Excel Charts and Graphs Basic Training

Summary

Title: Excel Charts – Excel Charts and Graphs Basic Training

Price: $59.99

Average Rating: 4.55

Number of Lectures: 30

Number of Quizzes: 1

Number of Published Lectures: 30

Number of Published Quizzes: 1

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Chart Types – Which chart should I use?

Lecture 3: Chart Types – Which chart should I use?

Lecture 4: Course Datasets

Chapter 2: General Tools

Lecture 1: Excel Basic Tools – Insert Tab

Lecture 2: Our First Chart – Pie Charts

Lecture 3: Excel Basic Tools – Design Tab

Lecture 4: Excel Basic Tools – Chart Buttons

Lecture 5: Chart Axes

Lecture 6: Exercise – Editing Tools

Chapter 3: Chart Types in Detail

Lecture 1: Pie of a Pie Chart

Lecture 2: Doughnut Charts

Lecture 3: Scatterplots

Lecture 4: Bubble Charts

Lecture 5: Line Charts

Lecture 6: Area Charts

Lecture 7: Exercise – Lynx Trappings

Lecture 8: Column or Bar Charts – Paired Data

Lecture 9: Dynamic Charts with Tables

Chapter 4: Bonus Lectures: New Chart Types in Excel 2016

Lecture 1: Introduction to New Charts

Lecture 2: Statistical Charts 1: Histogram

Lecture 3: Histogram – alternative method

Lecture 4: Statistical Charts 2: Pareto Chart

Lecture 5: Pareto Chart – alternative method

Lecture 6: Statistical Charts 3: Box and Whisker Plot

Lecture 7: Hierarchical Charts 1: Treemap

Lecture 8: Hierarchical Charts 2: Sunburst

Lecture 9: Which one should I choose? Treemap vs. Sunburst

Lecture 10: Finance: Waterfall Chart

Lecture 11: Waterfall Chart – alternative method

Instructors

R-Tutorials Training
Data Science Education

Rating Distribution

1 stars: 14 votes
2 stars: 19 votes
3 stars: 203 votes
4 stars: 622 votes
5 stars: 796 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!

Menu