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.
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.
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.
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.
In this lesson we learn how to work with one of the Excel charts element - Excel Chart Title.
Excel chart Data Labels is a chart element that puts more precise information on your chart. We explore it in this lecture.
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.
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.
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.
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.
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.
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.
3D Column Charts in Excel. Are they useful? Let's create some and take a look at them before we decide.
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.
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 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.
There are 3D Pie Charts in Excel as well. We investigate them in this lecture and look at their pros and cons.
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.
Excel Bar Of Pie Chart? One more mystery solved in this lecture.
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.
After having so much "Pie", do we need a Doughnut chart in Excel? Doughnut Charts. Excel Charts include those too. Let's explore them.
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.
An Excel Area Chart is another Excel Chart type. We will scrutinize them in this lesson.
In this section we learn X Y Scatter Charts in Excel. This lesson is our first foray into this interesting Excel chart type.
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.
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 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.
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.
Let's play a little bit more with X Y Scatter charts in Excel. This lesson makes things even more clear about them.
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.
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.
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.