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.3 (6 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.
414 students enrolled
$45
Take This Course
  • Lectures 58
  • Contents Video: 5.5 hours
    Other: 1 min
  • Skill Level All Levels
  • 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 7/2014 English

Course 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.

What are the requirements?

  • Open mind and willingness to learn.
  • A computer with Excel 2013 installed.

What am I going to get from this course?

  • Develop a skill in Excel Charts
  • Learn how to create powerful charts in Excel
  • Improve general Excel knowledge and skills

What is the target audience?

  • Everyone who wants to be good at Excel Charts.

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: Welcome
Welcome To Excel Charts!
Preview
02:07
Navigating Udemy Course Interface
Preview
05:57
01:51

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

Section 2: Chart Anatomy
06:38

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.

07:48

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.

05:59

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.

05:28

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

02:51

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

02:52

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.

03: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.

02:59

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.

Section 3: Excel Column Charts
07:26

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.

05:22

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.

04:28

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.

08:23

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

Section 4: Excel Line Charts
08:29

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.

06:17

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.

Section 5: Excel Pie Charts
09:33

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.

05:48

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

05:27

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.

05:10

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

02:59

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.

03:27

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

Section 6: Excel Bar Charts
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.

Section 7: Excel Area Charts
11:33

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

Section 8: X Y Scatter Charts In Excel
04:49

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

06:58

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.

03:14

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.

03:40

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.

08:13

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.

05:22

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

Section 9: Excel Stock Charts
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.

Section 10: Excel Surface Charts
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.

Section 11: Excel Radar Charts
07:47

Radar Charts in Excel seem tricky, but they do not have to be. We we create Excel Radar Charts in this video lecture and learn a few things about them.

Section 12: Excel Combination Charts
04:22

Combination Charts or Combo Charts in Excel, is when you have several data series plotted as different chart types on the same chart object. They used to be kind of esoteric, and one really needed to know how to create them. With Excel 2013 a new intuitive tool was introduced to create combination charts. This is one area where there is a significant difference in Excel 2013 compared to the previous versions of Excel. We create and begin to explore Combination Charts in this lecture.

05:49

Combination Charts in Excel are frequently used in concert with a secondary Y axis. We take a look at one such scenario in this lecture. We explore a situation when Excel chart data series plotted on the same chart are very different in scale. You will create a combination chart and add a secondary axis. I am sure, you have seen a chart with two axes before.

01:39

A Pareto Chart is one common example when an Excel combination chart is needed. We need to create a combo chart in Excel first and then format it as a Pareto Chart. This is an quick introduction to Pareto Charts.

10:16

Now let us create a Pareto Chart in Excel. This first example teaches you how to create it when the data is already grouped and ready to go. First, we create a combination chart, then we turn it into a Pareto Chart.

05:27

In this lesson you will learn how to create a Pareto Chart in Excel from raw data, using Excel Pivot Tables. Pivot Tables is a big topic and a powerful tool. If you want to really learn Pivot Tables, check my "Excel Pivot Tables Data Analysis" course. The example in this lesson, however, should be easy enough for you to follow.

Section 13: Disconnected Charts
05:47

You already know that an Excel Chart is a dynamic object and that it depends on its data. Sometimes, however, it is necessary to create an Excel chart and then to disconnect it from the data series. We learn how to do just that in this lesson. You will see, it is easy!

Section 14: Working With Data Series
05:18

You have created quite a few Excel charts by now and do know most of the ways to work with Excel chart data series. In this section you will enjoy some reinforcement of this knowledge. This lesson is about the situation, when your Excel data is contiguous. The easiest!

03:21

When the data that we need for our Excel chart is not contiguous, or when you encounter complex data ranges., we need to specify precisely what data series we want to use in Excel charts. Non-contiguous selection technique is handy in such case. Let's take a look at it again.

03:19

One option to create Excel charts from non-contiguous Excel data series is to use the Copy-Paste method. I have already mentioned it before. This is not my favorite method, but it is a nice option to keep in mind. Let's take a look at it one more time.

06:42

The Select-Data command in Excel charts gives you the ultimate control and power over your Excel charts. Once you learn this method, everything else is easy. You are in charge! Let's dive into this approach again. It is easy to use, once you get the hang of it.

Section 15: Interactive Charts - Using Excel Tables
08:16

You create an Excel chart and would like to add data to it later. And... your new data is not on the chart. You need to change the data source for your chart. There are ways to make it easier. In this lecture we take a look at using an Excel Table object as the source for the data series for Excel charts, to make your charts interactive.

Section 16: Interactive Charts - Using Named Formulas
07:28

In this section we take a look at a famous legacy method of creating an interactive Excel chart by using named formulas. First, we need to prepare for that. In this lecture we begin to prepare by learning about named formulas in Excel.

09:13

In this lecture we review the Excel COUNTA and OFFSET functions that we will need in the next lesson when we will create an interactive chart using named formulas.

13:07

And, finally, we put it all together here and learn the method of creating interactive Excel charts by using named formulas. This is a really interesting approach. A very nice creative building block to have in your Excel toolbox.

Section 17: Sparklines
05:54

Sparklines in Excel is a term for tiny charts that fit into a single cell. Here we learn how to create sparklines. A great feature of the newer versions of Excel.

04:38

Here we continue to create and modify sparklines and learn how to put one into a merged cell. As always, learn by doing!

03:10

Sparklines can reflect a timeline. Let's learn what I mean by that in this lecture. We will learn about the Date Axis Type in Sparklines.

07:36

Let's begin exploring some sparkline tools available to us. You have full control over your sparklines. The "Edit Data" command is one powerful tool. Let's learn how it works.

06:47

Let's learn about the powerful Excel Sparklines formatting options.

05:58

Excel Sparkline axis options provide important flexibility and let you get what you want from your beautiful sparklines. Let's review them here.

05:34

Let's put a few finishing touches on our Excel sparkline skills. A very quick review of the Sparklines clearing and grouping-ungrouping commands.

Section 18: Using Conditional Formatting As A Chart Engine - extra material
02:03

This is part of a lecture from my Excel Conditional Formatting course. It gives an idea, how to use conditional formatting to create a chart-like effect in Excel. Something extra in your tool kit.

Section 19: Next Steps
01:40

A few points about how you can keep benefiting from this course and keep improving your Excel Charting skills.

Bonus Lecture: Special Offers
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Learn It Your Way!

I love creating on-line courses. It has been my favorite pastime since 2013. I love the independent nature of this activity. There is so much to learn!

Independence is what I value most. I am an independent instructor – a free-lance instructor. My on-line courses are not the only thing that I do. I also teach in a classroom setting. My corporate clients hire me to conduct training for their employees. It is my main job: classroom and face-to-face training – as a free-lance of course. I have been in the training business for over 10 years.

I live in San Francisco and, naturally, most of my clients come from the Silicon Valley and from the Bay Area but not only from here. My corporate clients often ask me to travel to conduct training for them.

I have done training for many organizations for over 10 years. Among the more prominent are: 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. There are too many to list all of them here.

I am also a faculty of the American Management Association and conduct many of their training seminars – both public and private, or on-site. When I am not creating my on-line courses, I teach for one of these, or other fine companies.

I teach a broad range of topics. Such as Software, Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. I do hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

Ready to start learning?
Take This Course