Get Ahead in Your Career: Charts in Microsoft Excel!
0.0 (0 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.
619 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Get Ahead in Your Career: Charts in Microsoft Excel! to your Wishlist.

Add to Wishlist

Get Ahead in Your Career: Charts in Microsoft Excel!

Charts in Excel are necessary skills in your professional career and learn charts to move ahead in your career.
0.0 (0 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.
619 students enrolled
Created by Gaurav Chauhan
Last updated 12/2014
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to Create Excel Charts from Basic to Advanced
  • How to Choose an Excel Chart, what category will suit what type of data
  • Various excel chart tricks and tips
  • Charting Techniques -Basic to Advanced
  • Why to prepare a excel chart at all
View Curriculum
Requirements
  • Windows/Mac with Microsoft Excel 2010 or higher
Description

At any given time, there are 120,000 Jobs in america alone asking for MICROSOFT EXCEL as an additional skill in your resume (Jobs only above $5000 Per Month).

All you need to do is spend 2+ hours of our course and you gain that knowledge which makes you eligible for those jobs, as Charts in Excel are most important topics. So Choice is Yours!!!

---------------------------------------------------------------------------------------------------------------------

Sign up for this course and learn Excel Charts in a simple and agreeable way!

Words usually can't do a picture justice! In Excel, such picture is a Chart/Graph/Outline. An Excel Chart is the thing that makes the information in your spreadsheet valuable and capable.

It gives significant data and imparts what is vital. Attempt to clarify something verbally, and after that attempt to present it with an Excel outline.

Feel the distinction? An Excel Chart presents information in such a path, to the point that elucidates everything and effectively expresses the idea. When you are agree with Excel Chart, you are agree with Excel data/information.

When you complete this course, you will rapidly figure out how to make Excel graphs and charts. You will make each and every Excel graph sort. After you select and complete this course, you will be capable in assorted types of graphs in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts, Pareto Charts, Gantt Chart, Thermometer Charts etc.

You will be capable to make these outlines in Excel, as well as to configuration them rapidly and effortlessly.

You will get to be open to working with complex Excel graph information runs and figure out how to work with and completely control the Excel outline information arrangement. You will be capable with each and every Excel graph component, for example, Excel diagram title, Excel outline pivot mark, outline information table, information names and all the others.

You will comprehend why and where one needs an optional hub in Excel outlines. As it were, you will fundamentally enhance your abilities in Excel graphs by taking this simple to-take after course.

This course is outlined to educate, demonstrate, and advice as well as to help you rapidly create effective abilities in Excel diagrams.

Who is the target audience?
  • Anyone with a computer will Microsoft Excel Installed on it
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 56 Lectures Collapse All 56 Lectures 02:55:58
+
Welcome!
1 Lecture 00:18
How to take this Course?
00:18
+
What is Charts and why do we need them?
2 Lectures 06:12

In Excel,its all about numerical data, analysis and control, charts are vital for speaking to that information graphically. You utilize diagrams as a part of MS exceed expectations so you can make outlines focused around the scores of your test,exams etc .

They can be utilized to make numerous various types of graphs, that are suited to distinctive specific circumstances, in the same way as outlines for plotting focuses, or indicating sums contrasted with different sums.

Preview 01:58

In this lecture, we try to answer following questions for you.

How do you read Charts in Excel?

How Microsoft Excel Makes a chart in the Back?

What are real working behind Worksheet and Excel Chart?

Preview 04:14
+
How to Make Column Charts?
8 Lectures 24:37

In this Lecture, we cover follow questions:

How to create Simple Bar Chart in Excel, which can also be called as a Histogram.

Why do we need to Simple Bar Chart?

What are the scenario when you would need to create a Simple Bar Chart in Excel?

Create Simple Bar Chart
04:10

In this Lecture, we cover follow questions:

How to create Column Chart in Excel, which can also be called as a Histogram.

Why do we need to Column Chart?

What are the scenario when you would need to create a column chart in Excel?

Column Chart in Excel
03:02

In this Lecture, we cover follow questions:

How to create Stacked Bar Column/Bar/Histogram Charts?

Why do we need a Stacked Bar Column Chart?

What are the scenario when you would need to create a stacked Bar Column chart in Excel?

Preview 03:42

In this Lecture, we cover follow questions:

How to create Percent Stacked Bar Charts?

Why do we need a Percent Stacked Bar Column Chart?

What are the scenario when you would need to create a Percent Stacked Bar Column chart in Excel?

Preview 03:01

In this Lecture, we cover follow questions:

How to 3D Column Charts in Excel?

Why do we need a 3D Column Chart?

What are the scenario when you would need to create a 3D Column Chart in Excel?

Preview 02:01

In this Lecture, we cover follow questions:

How to create 3D Conical Pyramidal Cylindrical Bar Chart in Excel?

Why do we need a 3D Conical Pyramidal Cylindrical Bar Chart?

What are the scenario when you would need to create a 3D Conical Pyramidal Cylindrical Bar Chart in Excel?

3D Conical Pyramidal Cylindrical Bar
04:03

In this Lecture, we cover follow questions:

How to Create Stacked Column Chart in Excel?

Why do we need a Stacked Column Chart?

What are the scenario when you would need to create a Stacked Column Chart in Excel?

Stacked Column Chart
02:00

What is a Percentage Stacked Column Chart and how do you create in Excel.

In this Lecture, we cover follow questions:

How to create Percentage Stacked Column Chart in Excel?

Why do we need a Percentage Stacked Column Chart?

What are the scenario when you would need to create a Percentage Stacked Column Chart in Excel?

Percentage Stacked Column Chart
02:38
+
How to Make Line Charts?
5 Lectures 13:18

Line charts are most valuable when following information over a time of time. The X-pivot speaks to the progression of time, and the Y-hub tracks the data point's .

In this lecture we will cover:

What are Line Charts?

When do we use line charts?

How to create a Line Chart in Microsoft Excel.

Line Charts in Excel
02:53

Line charts are most valuable when following information over a time of time. The X-pivot speaks to the progression of time, and the Y-hub tracks the data point's .

In this lecture we will cover:

What is a Stacked Line Chart ?

When do we use Stacked Line Chart?

How to create a Stacked Line Chart in Microsoft Excel.

StackedLine
02:07

Line charts are most valuable when following information over a time of time. The X-pivot speaks to the progression of time, and the Y-hub tracks the data point's .

In this lecture we will cover:

How to Create Line Charts with Markers and 3D Charts in Microsoft Excel?

When do we use Create Line Charts with Markers and 3D Charts?

Line Charts with Markers and 3D Charts
03:14

Line charts are most valuable when following information over a time of time. The X-pivot speaks to the progression of time, and the Y-hub tracks the data point's .

In this lecture we will cover:

How to Create Scattered Curved Line Charts in Microsoft Excel?

When do we use Scattered Curved Line Charts?

Scattered Curved Line Charts
02:39

Line charts are most valuable when following information over a time of time. The X-pivot speaks to the progression of time, and the Y-hub tracks the data point's .

In this lecture we will cover:

How to Create Scattered Line Charts with or without Dots in Microsoft Excel?

When do we use Scattered Line Charts with or without Dots?

Scattered Line Charts with or without Dots
02:25
+
Pie Charts
4 Lectures 06:54

Pie charts are utilized to show the contribution of each one quality (cut) to an aggregate (pie). Pie diagrams dependably utilize one information arrangement.

How to Create Pie Charts in Excel?

Why do we use Pie Charts in Excel?

Pie Charts in Excel
01:50

Pie charts are utilized to show the contribution of each one quality (cut) to an aggregate (pie). Pie diagrams dependably utilize one information arrangement.

How to Create Exploded Pie Charts in Excel?

Why do we use Exploded Pie Charts in Excel?

Exploded Pie Charts
01:17

Pie charts are utilized to show the contribution of each one quality (cut) to an aggregate (pie). Pie diagrams dependably utilize one information arrangement.

How to Create Pie chart on a Pie Chart?

Why do we use Pie Chart on a Pie Chart in Excel?

Pie on Pie Chart
01:40

Pie charts are utilized to show the contribution of each one quality (cut) to an aggregate (pie). Pie diagrams dependably utilize one information arrangement.

How to Create 3D Pie Chart in Excel?

Why do we use 3D Pie Chart in Excel?

3D Pie Chart
02:07
+
Area Charts
3 Lectures 07:56

Area Charts are much like line charts, however they show distinctive shades in the zones beneath the lines.

This beautiful and visual presentation recognizes the information all the more plainly. However unfortunately, information arrangement with littler values that are plotted in the once more of a territory graph may be totally or incompletely taken cover behind information arrangement with bigger values that are plotted before them.

In this lecture, we will learn :

What is Area Chart and how do you create them in excel?

Area Charts
02:33

Area Charts are much like line charts, however they show distinctive shades in the zones beneath the lines.

This beautiful and visual presentation recognizes the information all the more plainly. However unfortunately, information arrangement with littler values that are plotted in the once more of a territory graph may be totally or incompletely taken cover behind information arrangement with bigger values that are plotted before them.

In this lecture, we will learn :

What is Stacked Area Chart ?

How to create Stacked Area Chart in Excel?

Stacked Area Charts in Excel
02:10

Area Charts are much like line charts, however they show distinctive shades in the zones beneath the lines.

This beautiful and visual presentation recognizes the information all the more plainly. However unfortunately, information arrangement with littler values that are plotted in the once more of a territory graph may be totally or incompletely taken cover behind information arrangement with bigger values that are plotted before them.

In this lecture, we will learn :

What is 3D Area Chart ?

How to create 3D Area Charts in Excel?

3D Area Charts in Excel
03:13
+
Chart Options Explained
19 Lectures 01:07:53

By default, there is no title for a new built chart in Excel. To make the chart easily understand, you can add a title for it manually. Moreover, you can easily remove, position the chart title, and format the chart titles as well.

Chart Title 1
03:41

By default, there is no title for a new built chart in Excel. To make the chart easily understand, you can add a title for it manually. Moreover, you can easily remove, position the chart title, and format the chart titles as well.

Chart Title 2
03:46

Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts.

How do you work with them in excel?Lets Find out in the Video

Axis Titles 1
03:55

Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts.

How do you work with them in excel?Lets Find out in the Video continued from previous session.

Axis Titles 2
03:46

Excel uses some kind of legend to help readers decode the charted data. Excel charts have legends by default, and these legends have a great deal of flexibility.

So how do you work with Legends,lets find out?

Legend Options
03:36

Data Labels are basically markers which are used to quickly identify the data series which is used to make that particular Chart

So how do you work with Data Labels ,lets find out?

Data Labels
06:00

Data Tables in chart show a tabular representation of data which is used in that particular chart. So how do you work with Data Tables, lets find out?

Data Tables
03:51

Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts.

Find out more Axes Options in Chart Options.

Axes Options
02:53

Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts.

What is Horizontal Axes in Charts and how do you work with them?

Horizontal Axes Options
04:51

Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts.

What is Vertical Axes in Charts and how do you work with them?

Vertical Axes Options
03:21

What if you have selected a different chart and want to change the chart type. Learn how to change chart type and How to change chart from one graphical representation to another?

Change Chart Type Option
03:20

Learn how to interchange data between Rows and Columns in your charts?

Switch Row Column Option
01:46

How to do you select specific data in charts?How to play with specific data inside and outside charts?

Select Data
02:20

After you make a chart, you can in a split second transform its look. Rather than physically including or changing outline components or designing the diagram, you can rapidly apply a predefined layout and style to your graph. Microsoft Office Excel gives a mixture of valuable predefined formats and styles (or snappy designs and speedy styles) that you can choose from. On the other hand, you can tweak a layout or style of a diagram further by physically changing the format and style of the individual outline components that are utilized as a part of the graph.

You can't spare a custom design or organization layout, however in the event that you need to utilize the same format or configuration once more, you can saved the chart template for future use.

Chart Layouts Part 1
05:31

After you make a chart, you can in a split second transform its look. Rather than physically including or changing outline components or designing the diagram, you can rapidly apply a predefined layout and style to your graph. Microsoft Office Excel gives a mixture of valuable predefined formats and styles (or snappy designs and speedy styles) that you can choose from. On the other hand, you can tweak a layout or style of a diagram further by physically changing the format and style of the individual outline components that are utilized as a part of the graph.

You can't spare a custom design or organization layout, however in the event that you need to utilize the same format or configuration once more, you can saved the chart template for future use.

Chart Layouts Part 2
04:17

After you make a chart, you can in a split second transform its look. Rather than physically including or changing outline components or designing the diagram, you can rapidly apply a predefined layout and style to your graph. Microsoft Office Excel gives a mixture of valuable predefined formats and styles (or snappy designs and speedy styles) that you can choose from. On the other hand, you can tweak a layout or style of a diagram further by physically changing the format and style of the individual outline components that are utilized as a part of the graph.

You can't spare a custom design or organization layout, however in the event that you need to utilize the same format or configuration once more, you can saved the chart template for future use.

Chart Styles
03:02

You can move a chart to any location on a worksheet or to a new or existing worksheet. You can also change the size of the chart for a better fit.

By default, a chart is moved and sized with cells. When you change the size of cells on the worksheet, the size of the chart adjusts accordingly. You can change this positioning option if you don't want to move or resize the chart together with the worksheet cells.

Moving Charts
01:59

A chart template that you create is in reality a custom chart type that you can apply like any other chart type.

To reuse a favorite chart that you customized to meet your needs, you can save that chart as a chart template (*.crtx) in the charts template folder

Chart Templates
04:12

How do you Roll Back in Charts?

Rolling Back Changes in Charts
01:46
+
Chart Layout Options
2 Lectures 07:37

What is Drop Box in Excel Charts?

Drop Box
04:48

What is Drop Box in Excel Charts?

Drop Box Explained
02:49
+
Format Selection
8 Lectures 32:15

What is Format Selection Fill Option? How to use it in Excel Charts?

Fill Option
06:01

Change Border Color
03:31

Change Border Style
03:08

Change Shadow
04:22

Change Glow
04:01

How to Change 3D Format
04:30

Change Selection Size
02:07

Change Properties
04:35
+
Advanced Charts
3 Lectures 07:57

What is Scatter Chart and how do you create them in excel?

Create Scatter Charts
03:40

Doughnut charts are a good way to give birds-eye view of two or more sets of data.

Unlike a pie chart, a doughnut chart can contain multiple series.

What is a Doughnut Chart and how do you create them in excel?

Doughnut Charts
01:41

More Cylinderical,Conical and Pyramidal Charts in Excel

Cylinderical, Conical and Pyramidal Charts
02:36

Lets Check your knowledge about Charts in Excel.

Chart Fundamentals
2 questions
1 More Section
About the Instructor
Gaurav Chauhan
4.5 Average rating
2 Reviews
1,368 Students
3 Courses
Instructor

I am Lead IT professional for one of largest IT companies in the world. I have been trained and certified in various IT stream and analytics. I am ex- American Express, ex-Airtel. I have been working in IT domain for last 15 years and I have been a system administrator, Six Sigma expert & experienced project manager who has handled global projects on massive scale. 

I have software patents in my name and have been involved with IT industry for a long time.


Going forward, my courses would be based on cloud and analytics domain with new skills. I will start from basics and by the end of each courses you can become a proficient expert in that particular. Please add me on Linkedin or Follow me on Twitter.