Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel Charts & Graphs and SmartArt Graphics for Beginners to your Wishlist.

Add to Wishlist

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 (19 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,107 students enrolled
Created by Kawser Ahmed
Last updated 6/2016
English
$15 $40 62% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 3 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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!

Who is the target audience?
  • This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.
Students Who Viewed This Course Also Viewed
What Will I Learn?
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.
View Curriculum
Requirements
  • Microsoft Office Software Installed.
Curriculum For This Course
Expand All 40 Lectures Collapse All 40 Lectures 03:49:59
+
Welcome to the Course!
5 Lectures 12:55

Download Working Files, Ongoing Support & How to Instantly Contact Me
00:51

List of sites where you can practice Excel problems
00:49

How to Best View This Course
06:58

How to Review this Course and Obtain Your Certificate of Completion
02:40
+
Getting Started with Excel Charts
9 Lectures 01:06:21

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.
0201 How to Make a Graph or Chart in Excel from Scratch
07:06

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.
0202 Make a Graph in Excel 2013 Using the Recommended Charts Tool
04:54

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.
0203 Creating and Customizing an Excel Chart in More than One Way
09:35

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.
0204 Creating a Combination Chart in Excel & Introducing with Chart Elements
06:18

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.
0205 Using Chart Elements, Chart Styles and Chart Filters - Excel 2013 New Tools
08:20

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.
0206 Resizing, Moving, Copying, Deleting, and Printing Charts in Excel
06:36

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.
0207 Chart Types: Column Charts, Bar Charts, and Line Charts
08:13

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.
Preview 06:51

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.
0209 Chart Types: XY(Scatter) Chart, Area Charts, and Radar Charts
08:28
+
Advanced Chart Techniques
11 Lectures 01:03:14

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.
0301 Chart Elements: The Ways to Select Chart Elements
05:02

In this video lecture,

  • You will learn how to find out the tools that you will use to format chart elements.
0302 The Tools That You Can Use to Format The Chart Elements
05:36

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
0303 Fill & Line: Modifying or Formatting Using Fill & Line Tools
10:06

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.
0304 Effects: Modifying and Filtering Using Different Types of Effects
08:58

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
0305 Size & Properties: Modifying and Formatting Using Sizes and Properties
05:49

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.
0306 Another Tools to Format: Series Options, Table Options and Marker Options
03:16

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.
Preview 08:56

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.
0310 Handling Missing Data in Excel Charts
02:13

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.
0311 Adding Error Bars and Trend Lines to a Chart
06:53

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.
0312 Chart Templates: How to Create and Use
02:21

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

  1. Series Overlap
  2. Gap Width
0313 Format Data Series Options: Series Overlap and Gap Width
04:04
+
Build Some Charts that are Useful while Making Excel Dashboard
6 Lectures 33:46

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.

0401 Creating Combination Charts: Deeper Analysis
04:28

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.
Preview 04:48

In this video lecture,

  • You will learn how to make a thermometer chart in Excel.
0403 Thermometer Chart: How to Create Thermometer Chart in Excel
08:08

In this video lecture,

  • You will learn how to make a gauge chart in Excel.
0404 Gauge Chart: How to Create a Gauge Chart in Excel
06:32

In this video lecture,

  • You will learn how to create a comparative histogram chart.
0406 Comparative Histogram: How to Create a Comparative Histogram
04:21

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
0407 Gantt Chart: How to Create a Gantt Chart in Excel
05:29
+
Graphics Objects - Using Pictures and Drawings in Excel
8 Lectures 52:00

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.

0502 Formatting Images in Excel
09:42

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.
0503 Removing Background from an Image
05: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.
0506 Working with SmartArt Objects
08:34

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.
0507 The Stacking Order - Stacking Objects in a Worksheet
05:44

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.
0508 Aligning, Spacing and Grouping Multiple Objects Together
06:05

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.
Preview 04:46

In this video lecture,

  1. You will learn how to change the styles of Drawing and SmartArt tools text objects.
0510 Working with WordArt
03:47

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.
0511 Working with Equation Editor
07:48
+
Learn More: A Special Offer!
1 Lecture 01:53

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.

Bonus Lecture: A Special Offer for You!
01:53
About the Instructor
4.3 Average rating
695 Reviews
26,945 Students
11 Courses
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!

Report Abuse