Microsoft Excel Charts Master Class
4.5 (11 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.
443 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel Charts Master Class to your Wishlist.

Add to Wishlist

Microsoft Excel Charts Master Class

Learn Excel Charts in an easy and comfortable way and present your data in an actionable form for profit and success
4.5 (11 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.
443 students enrolled
Created by Igor Ovchinnikov
Last updated 4/2016
English
Current price: $10 Original price: $75 Discount: 87% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Develop a skill in Excel Charts
  • Learn how to create powerful charts in Excel
  • Improve general Excel knowledge and skills
View Curriculum
Requirements
  • Open mind and willingness to learn.
  • A computer with Excel 2013 installed.
Description

Sign up for this Excel course and learn Excel Charts in an easy and comfortable way!

A picture is worth a thousand words! In Excel, such picture is a chart. An Excel chart is what makes the data in your spreadsheet useful and powerful. It provides actionable information and communicates what is important. Try to explain something verbally, and then try to present it with an Excel chart. Feel the difference? An Excel chart presents data in such a way that clarifies everything and drives the point home. When you are comfortable with Excel charts, you are comfortable with Excel data. Excel charts allow you to create eureka moments based on dry numbers that you have in your spreadsheet.

This Excel course is your Excel charts tutorial. When you take it, you will quickly learn how to create Excel charts and graphs. You will create every single Excel chart type. After you enroll and complete this course, you will be proficient in all kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts, as well as the somewhat esoteric Surface Charts, Radar Charts, Stock Charts, You will be able not only to create these charts in Excel, but also to format them quickly and easily. You will become comfortable working with complex Excel chart data ranges and learn how to work with and fully control the Excel chart data series. You will be proficient with every single Excel chart element, such as Excel chart title, Excel chart axis label, chart data table, data labels and all the others. You will be able to create combination charts, and charts with two Y-axes. You will understand why and where one needs a secondary axis in Excel charts. In other words, you will significantly improve your skills in Excel charts by taking this easy-to-follow course.

During the course you will watch high-quality video lectures on various Excel charts topics and follow the instructor, working on the same files that are used in demonstrations. Gradually, but very quickly you will begin to realize that you are getting more and more comfortable with charts and get to understand them better and better.

This course is designed not only to inform, show, and tell but also to help you quickly develop powerful skills in Excel charts.

During lectures in this Excel charts course, we will be using Microsoft Excel 2013.

This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:

"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;

"Data Manipulation In Excel" allowing you to save up to 90% of time when using Excel for certain data management tasks;

"Excel Conditional Formatting Master Class" where you can learn how to improve your spreadsheets using conditional formatting in Excel;

"Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering pivot tables data crunching skills.

Who is the target audience?
  • Everyone who wants to be good at Excel Charts.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
58 Lectures
05:35:20
+
Welcome
3 Lectures 09:55


What is the best way to learn Excel charts in this course? Get some tips and tricks in this lecture.

Preview 01:51
+
Chart Anatomy
8 Lectures 38:27

In this lesson we begin our Excel charts tutorial. You will learn the fundamental Excel charts concepts and terms. Such as data series and labels. We will begin to create Excel charts here and explore them.

Preview 06:38

Here we move closer to understanding the anatomy of Excel charts and explore the elements of an Excel chart. Of course, we continue to learn how to create Excel charts here as well.

Preview 07:48

Now let's explore the difference in how to create Excel charts from contiguous data range versus non-contiguous data range. We will create Excel charts with complex data ranges.

Charts Based On Non Contiguous Ranges
05:59

In this lesson we learn how to work with one of the Excel charts element - Excel Chart Title.

Preview 05:28

Excel chart Data Labels is a chart element that puts more precise information on your chart. We explore it in this lecture.

Data Labels
02:51

Let's see how we can benefit from using Axis Titles in Excel Charts. It is one more Excel chart element that you want to be comfortable with.

Axis Titles
02:52

An Excel chart data table is a chart element that displays all of your data right on the chart object. Very useful when you want to display the Excel chart itself and present the complete data series right in front of you. Let's learn how we can benefit from it.

Data Table
03:52

Error Bars is an Excel chart element that add some dynamism to your picture. It displays the possible error range on the chart, or the possible deviations of your data points. Let's use Excel chart error bars in this lecture.

Error Bars
02:59
+
Excel Column Charts
4 Lectures 25:39

In this section we begin to learn the various Excel chart types. We begin with the Clustered Column Excel chart type. We have already created it before, but let's formally review it.

Clustered Columns
07:26

Stacked Column chart is another Excel chart type that we have at our disposal. Let's take a closer look at it in this lecture and see how and when we can benefit from it.

Stacked Columns Charts
05:22

100 Percent Stacked Column Excel chart is another Excel chart sub-type. It is a column chart, that shows data series as 100%. Let's take a look at it here.

100% Stacked Columns Charts
04:28

3D Column Charts in Excel. Are they useful? Let's create some and take a look at them before we decide.

3D Column Charts
08:23
+
Excel Line Charts
2 Lectures 14:46

Now we learn Line Charts in Excel. They are very common and useful indeed. We also create a line chart with markers and discuss them.

Line And Line With Markers Charts
08:29

Let us keep learning about Excel Line Charts, there are different sub-types. In this lecture we take a closer look at some that are not that straight forward. For example Stacked Line Charts, 100% Stacked etc.

The Other Line Charts
06:17
+
Excel Pie Charts
6 Lectures 32:24

The ubiquitous Excel Pie Charts! Some love them, some do not. Whatever your take on them, we need to know how to work with them in Excel. Let's play with them a bit in this section.

Pie Chart
09:33

There are 3D Pie Charts in Excel as well. We investigate them in this lecture and look at their pros and cons.

3D Pie Chart
05:48

Excel Pie Of Pie Chart? What is that? Curious? Come on, let's check it out. This is your Excel Pie Of Pie chart tutorial.

Pie Of Pie Chart
05:27

Excel Bar Of Pie Chart? One more mystery solved in this lecture.

Bar Of Pie Chart
05:10

Oh, ubiquitous Excel Pie Charts! To be or not to be, that is the question. We try to answer that question here and discuss some pros and cons - pluses and minuses of Pie Charts.

Problem Of Pie Charts
02:59

After having so much "Pie", do we need a Doughnut chart in Excel? Doughnut Charts. Excel Charts include those too. Let's explore them.

Doughnut Charts
03:27
+
Excel Bar Charts
1 Lecture 10:05

Excel Bar Charts. It is like a Column Chart in Excel, but flipped 90 degrees. In this lesson we take a closer look at them.

Bar Charts
10:05
+
Excel Area Charts
1 Lecture 11:33

An Excel Area Chart is another Excel Chart type. We will scrutinize them in this lesson.

Area Charts
11:33
+
X Y Scatter Charts In Excel
6 Lectures 32:16

In this section we learn X Y Scatter Charts in Excel. This lesson is our first foray into this interesting Excel chart type.

X Y Scatter Charts Introduction
04:49

Excel X Y Scatter With Lines chart. We do not only scatter, we also connect what we scattered with lines. Let's learn how to create them.

X Y Scatter With Lines
06:58

In this lesson we will take a look at an example of an Excel X Y Scatter chart presenting data that has no correlation. We also add a trend line to it.

X Y Scatter Without Correlation
03:14

X Y Scatter chart in Excel shows you if the data is correlated. This lesson is using an example of negative correlation in an X Y Scatter chart. We add a trendline to it too.

X Y Scatter With Negative Correlation
03:40

A Bubble Chart in Excel is type of an X Y Scatter chart, but with additional data series plotted as a bubble. Let me show you what I mean. It will be clear once you complete this lesson.

Bubble Charts In Excel
08:13

Let's play a little bit more with X Y Scatter charts in Excel. This lesson makes things even more clear about them.

Geometry
05:22
+
Excel Stock Charts
1 Lecture 11:29

Money never sleeps. Excel Stock charts are an interesting Excel chart type. We explore how to create Stock Charts in Excel in this lecture. They are common on Wall Street, but useful not only there.

Stock Charts
11:29
+
Excel Surface Charts
1 Lecture 06:50

Excel Surface Charts seem very esoteric to most people. We create Surface Charts in this Lesson. They should be easy or at least easier after this lesson.

Surface Charts In Excel
06:50
9 More Sections
About the Instructor
Igor Ovchinnikov
4.5 Average rating
355 Reviews
5,478 Students
10 Courses
Helping you learn fast, so you can do your job well.

Hi, I am Igor Ovchinnikov.

Welcome to my profile page. This is where you normally get to learn about me and read something like this:

“Igor Ovchinnikov is a corporate trainer with over 10 years of experience. He lives in San Francisco and provides excellent training-delivery services to clients all over the Bay Area. He has delivered training for Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others. 

Mr. Ovchinnikov holds an MBA from the Ohio State University.”

Well, frankly, I always have some serious cognitive dissonance whenever I have to write about myself in the third person like this. It’s a bit silly - don’t you agree? So, enough of this out-of-body talk!

First of all, you probably don’t care about me that much. Second, you are probably more interested in why you should buy my courses and what’s in them for you? You may be more interested in how my teaching is different compared to the other great instructors out there?

I have to confess, it is something I've been wondering about too. You know, when someone asks you what you are good at, it’s tough to answer that. Especially, because when you are really good at something, you don’t really perceive it as a big deal. Don’t you agree? Think of something you do really well. Now, do you really work hard on it, or does it come kind of naturally?

So, to answer this question to myself, I recently decided to ask my students. Most of the ones I polled are employees of just one organization where I teach - Stanford University, so the research sample may not be fully scientific. Anyway, I asked a few dozens of my students what they liked best about my teaching style. It was really surprising, that most of them told me that their favorite part was how clear things became after I explained it to them. One of them said literally: “You are a great explainer. It was so confusing before, and now I finally understand it!” 

I think, here’s what I can promise you when you enroll in my courses. I promise you clear explanations, so that things will be no longer confusing.

So, here’s my value proposition to you:

When you enroll in my courses and go through the material, you should expect clear explanations that will help you learn and build your skills fast, so you can succeed at your job. 

If that is the experience that you are interested in, simply enroll in my courses below.