Excel Charts & Graphs and SmartArt Graphics for Beginners

Learn to visualize data using Excel Charts and Graphs and SmartArt Graphics. Build 7 Charts that you use your daily work
4.4 (20 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.
6,028 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 40
  • Length 4 hours
  • Skill Level Beginner Level
  • 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 12/2015 English

Course Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Excel is probably the most commonly used software in the world for creating charts. And charts are the main tools to visualize the insights from some numbers. Welcome to this Excel Charts and Graphical Objects learning course.

Let’s discuss now what you will learn from this course.

Basics of Excel Charts: At first you will learn the basics of Excel charts: how to create them quickly and how to choose the right chart type for your data.

Advanced Chart Techniques: Then you will work with the advanced tools within different task panes to work with excel charts.

Build some useful Excel charts: Then I will show you how to build some useful excel charts like: Combo Chart, Picture Chart, Thermometer Chart, Gauge Chart, Comparative Chart and finally the Gantt chart.

Graphical Objects: Then we shall work with Graphical objects. Graphical objects have many uses when you will present your data for an audience.

Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel Charts and Graphical Objects.

By the completion of this training course, you will be fully versed in creating and using Excel charts. So, if you are interested to learn Charts and Graphical objects in Excel, then this course is for you. Thanks for reading. Enjoy the course!

What are the requirements?

  • Microsoft Office Software Installed.

What am I going to get from this course?

  • Learn Excel Charting Completely with this course.
  • Learn how to use Graphic Arts objects in Excel.
  • Learn how to create some real life charting with this course.

What is the target audience?

  • This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.

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 to the Course!
Welcome to the course
Preview
01:37
Download Working Files, Ongoing Support & How to Instantly Contact Me
Article
List of sites where you can practice Excel problems
Article
How to Best View This Course
06:58
How to Review this Course and Obtain Your Certificate of Completion
02:40
Section 2: Getting Started with Excel Charts
07:06

In this video lecture:

  1. You will learn how to create an Excel chart or graph selecting the data series manually.
  2. And you will be introduced with the “Insert” Chart dialog box.
04:54

In this video lecture:

  1. You will learn in details how to create an Excel chart using the Recommended Charts command.
  2. And you will learn how to apply Chart Styles on a chart.
09:35

In this video lecture, you will learn:

  1. How to create an Excel chart using the commands under the Charts group.
  2. How to change the color of a chart.
  3. How to change the Layout of a chart.
  4. How to switch between Row and Column.
  5. How to change Chart type.
  6. How to create default Excel chart using keyboard shortcut.
  7. How to create chart in Chart Sheet using keyboard shortcut.
  8. And how to change the default Excel chart.
06:18

In this video lecture:

  1. You will learn how to create a Combo Chart.
  2. And then you will be introduced with the different parts of a chart.
08:20

In this video lecture:

  1. You will work with the three icons that appear on the top-right corner when you select a chart. They are:
    1. Chart Elements
    2. Chart Styles
    3. And Chart Filters
  2. More or less you have worked with them in earlier videos, you will learn their uses in details in this video.
06:36

In this video lecture, you will learn how to:

  1. Resize a chart
  2. Move a chart from one location to another
  3. In the same worksheet
    1. From one worksheet to another
    2. From one workbook to another
    3. And even from a worksheet to a chart sheet.
  4. You will also learn how to delete a chart
  5. And how to Print only the chart, not the whole worksheet.
08:13

In this video lecture:

  1. You will learn how to create these three chart types:
    1. Column Chart
    2. Bar Chart
    3. And Line Chart
  2. You will see all these chart types have two major sub-categories: 2-D and 3-D.
06:51

In this video lecture:

  1. You will learn how to create and customize a Pie chart in details.
  2. You will learn how to create “Bar of Pie” chart and “Pie of Pie” chart.
  3. And you will be introduced with the “Format Data Labels” task pane.
08:28

In this video lecture:

  1. You will learn how to create and use of these three charts:
    1. XY or Scatter Chart
    2. Area Chart
    3. And Radar Chart.
Section 3: Advanced Chart Techniques
05:02

In this video lecture, you will learn how to select a chart element. You can select a chart element in three ways:

  1. Using your mouse pointer
  2. Using Chart Elements control
  3. And using your keyboard.
05:36

In this video lecture,

  • You will learn how to find out the tools that you will use to format chart elements.
10:06

In this video lecture, you will learn how to work with the features under the Fill & Line tab to format a chart element. You will get two sub categories under this tab:

  1. Fill
  2. And Border
08:58

In this video lecture,

  1. You will learn where to find out the Effects options.
  2. You will also learn how to work with the different options under the Effects tab.
05:49

In this video lecture, you will learn how to work with the different options under the Size & Properties tab. The options are:

  1. Size
  2. Properties
  3. Alt Text
  4. And Alignment
03:16

In this video lecture,

  1. You will learn how to format the data table of a chart.
  2. You will learn how to change the axis of a data series
  3. And you will also learn how to change the marker of a data series.
08:56

In this video lecture,

  1. You will learn how to work with
  2. Value Axis related Format Axis task pane options
  3. And Category Axis related Format Axis task pane options.
02:13

In this video lecture,

  1. You will learn two topics:
  2. The first topic is: how to handle missing data points in a chart
  3. And second topic is: how to show those data in a chart that are from hidden rows and columns.
06:53

In this video lecture,

  1. You will learn how to add Error Bars to a chart
  2. You will also learn how to show Trend-line in a chart.
02:21

In this video lecture,

  1. You will learn how to save a chart as a template.
  2. You will also learn how to apply and manage chart templates.
04:04

In this video lecture, you will learn about two controls of Format Data Series task pane. They are:

  1. Series Overlap
  2. Gap Width
Section 4: Build Some Charts that are Useful while Making Excel Dashboard
04:28

Combination charts are generally called Combo charts in Excel. These types of charts have so many uses. In this video lecture, I have talked about how to create a complex type Excel combo chart.

04:48

In this video lecture,

  1. You will learn how to use images as the background of a chart
  2. You will also learn how to use a shape as the columns of chart.
08:08

In this video lecture,

  • You will learn how to make a thermometer chart in Excel.
06:32

In this video lecture,

  • You will learn how to make a gauge chart in Excel.
04:21

In this video lecture,

  • You will learn how to create a comparative histogram chart.
05:29

In this video lecture:

  1. You will learn how to create a basic Gantt Chart using Stacked Bar chart.
  2. You will also learn how to reverse the Category axis and change the position of the Labels of Horizontal axis.
  3. And you will learn other topics like:
    1. Changing the value of Major Units
    2. And changing Gap Width between Data Series
Section 5: Graphics Objects - Using Pictures and Drawings in Excel
09:42

In this video lecture, you will learn how to use different tools to format a picture. The tools are:

  1. Corrections tool – this tool is used to soften, sharpen, increase brightness or contrast
  2. Color tool – this tool is used to do Color Saturation, Color Tone and Recolor
  3. Artistic Effects
  4. Picture border – this tool is used to add border to a picture
  5. Picture Effects – this tool is used to add effects to an image
  6. Picture Layout – you can change the layout of a picture using this tool.

I have also discussed about the commands under the Size group.

05:34

In this video lecture,

  1. You will learn how to remove background from an image using Excel
  2. And you have learned the use of the tools in the Background Removal tab that appears when you click on the Remove Background command in the Picture Tools Format contextual tab.
08:34

In this video lecture, you will learn how to work with SmartArt Graphics in details:

  1. How to insert,
  2. How to change the layout, color, styles of the SmartArt graphics,
  3. How to change the shape, color and other features of individual object in a SmartArt Graphic.
  4. How to add text, how to change direction
  5. And many more features.
05:44

In this video lecture,

  1. You will learn how stacking order works for Images, Shapes and Smart Arts,
  2. You will learn how to change the stacking order,
  3. And you will learn how to hide and unhide all of them using Selection task pane.
06:05

In this video lecture,

  1. You will learn how to group, ungroup and regroup the objects in a worksheet,
  2. You will also learn how to align objects in different ways.
04:46

In this video lecture,

  1. You will learn how to show the cell value as an object text,
  2. You will also learn about Excel PI and ROUND functions.
03:47

In this video lecture,

  1. You will learn how to change the styles of Drawing and SmartArt tools text objects.
07:48

In this video lecture,

  1. You will learn how to write mathematical equation in an Equation Editor.
  2. You will also learn how to design the editor.
Section 6: Learn More: A Special Offer!
Article

Want to get an in-depth knowledge of Microsoft Excel? Join my Advanced Excel 2013 Training + Build a Pro Excel Template course for 50% Off. Or join my Data Analysis in Excel with Statistics: Get Meanings of Data course for 50% Off.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kawser Ahmed, Founder ExcelDemy.com | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

  • 1. Corporate Budgeting, Planning & Forecasting
  • 2. Mission-critical financial processes
  • 3. Month-end close processes
  • 4. Big Data Analysis using Excel
  • 5. Company Reports (Sales, Marketing, Administrative)
  • 6. Large Projects using Excel VBA
  • 7. Dashboard Design using Excel
  • 8. And Basic Accounting


I am always around you to help and support! 

Just knock me!

Ready to start learning?
Take This Course