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

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.

Welcome To Excel Charts!
Tips On How To Learn Excel Charts
Fundamental Concepts Of Excel Charts
Elements Of Excel Charts
Charts Based On Non Contiguous Ranges
Chart Title
Data Labels
Axis Titles
Data Table
Error Bars
Clustered Columns
Stacked Columns Charts
100% Stacked Columns Charts
3D Column Charts
Line And Line With Markers Charts
The Other Line Charts
Pie Chart
3D Pie Chart
Pie Of Pie Chart
Bar Of Pie Chart
Problem Of Pie Charts
Doughnut Charts
Bar Charts
Area Charts
X Y Scatter Charts Introduction
X Y Scatter With Lines
X Y Scatter Without Correlation
X Y Scatter With Negative Correlation
Bubble Charts In Excel
Geometry
Stock Charts
Surface Charts In Excel
Radar Charts
Combination Charts Introduction
Off-Scale Data Series
Pareto Chart - Introduction
Creating Pareto Charts From Grouped Data
Pareto Chart From Raw Data - Using Pivot Tables
Disconnecting A Chart From Data
Contiguous Range - The Easiest Situation
Non-Contiguous Selection Approach
Copy-Paste Approach
Select Data Command - Pack Your Own Parachute
Interactive Charts Using An Excel Table
Excel Named Ranges and Named Formulas - Review
COUNTA and OFFSET Functions In Excel
Interactive Charts Using Named Formulas
Creating Excel Sparklines
Excel Sparklines In Merged Cells
Sparklines With Date Axis Type
The "Edit Data" Command
Sparklines - Formatting Options
Sparklines - Axis Options
Sparklines - Clearing And Grouping
Conditional Formatting To Create A Chart Effect
Next Steps

What's included

  • 56 Video Lessons

  • Works on all devices
  • Certificate of completion

Igor Ovchinnikov

Instructor