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.
617 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 56
  • Length 3 hours
  • 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 11/2014 English

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

What are the requirements?

  • Windows/Mac with Microsoft Excel 2010 or higher

What am I going to get from this course?

  • 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

What is the target audience?

  • Anyone with a computer will Microsoft Excel Installed on it

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!
How to take this Course?
Article
Section 2: What is Charts and why do we need them?
01:58

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.

04:14

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?

Section 3: How to Make Column Charts?
04:10

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?

03:02

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?

03:42

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?

03:01

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?

02: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?

04:03

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?

02:00

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?

02:38

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?

Section 4: How to Make Line Charts?
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 are Line Charts?

When do we use line charts?

How to create a Line Chart in Microsoft Excel.

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:

What is a Stacked Line Chart ?

When do we use Stacked Line Chart?

How to create a Stacked Line Chart in Microsoft Excel.

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 Line Charts with Markers and 3D Charts in Microsoft Excel?

When do we use Create Line Charts with Markers and 3D 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 Curved Line Charts in Microsoft Excel?

When do we use Scattered Curved Line Charts?

02:25

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?

Section 5: Pie Charts
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 Pie Charts in Excel?

Why do we use Pie Charts in Excel?

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 Exploded Pie Charts in Excel?

Why do we use Exploded Pie Charts in Excel?

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 Pie chart on a Pie Chart?

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

02:07

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?

Section 6: 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 Area Chart and how do you create them 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 Stacked Area Chart ?

How to create Stacked Area Chart in Excel?

03:13

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?

Section 7: Chart Options Explained
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.

03:46

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.

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

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 continued from previous session.

03:36

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?

06:00

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?

03:51

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?

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.

Find out more Axes Options in Chart 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 Horizontal Axes in Charts and how do you work with them?

03:21

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?

03:20

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?

01:46

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

02:20

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

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.

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.

03:02

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.

01:59

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.

04:12

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

01:46

How do you Roll Back in Charts?

Section 8: Chart Layout Options
04:48

What is Drop Box in Excel Charts?

02:49

What is Drop Box in Excel Charts?

Section 9: Format Selection
06:01

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

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
Section 10: Advanced Charts
03:40

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

01:41

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?

02:36

More Cylinderical,Conical and Pyramidal Charts in Excel

2 questions

Lets Check your knowledge about Charts in Excel.

Section 11: Conclusion
Conclusion
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gaurav Chauhan, 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.

Ready to start learning?
Take This Course