Create Excel Charts and Graphs in 2 hours! - with Excel 2013

Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included
4.3 (50 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.
1,875 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 54
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • 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 8/2015 English Closed captions available

Course Description

--- The course has been fully updated for October 2016 ---

*** This course is fully subtitled in English! ***

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Charts? What if you could learn how to make designer-quality Excel Charts and Graphs in 2 hours?

Think about what your Excel charts look like if you could follow a concise and practical go-to guide course for creating Advanced Graphs in Excel

While Excel offers dozens of chart types and hundreds of formatting options, making the right Chart is tough. The adage "A picture is worth a thousand words" is also related to Excel Charts. A good Chart can clearly tell the story in your data.

What this course is about:

In this course my goal is to give my students the practical knowledge, with real-world examples and step by step instructions, to create designer-quality Charts in Excel.

As a bonus I've included all the Excel Templates plus Sample Files plus Cheat Sheets for every section.

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 24 hours.

Here is what you'll get:

  • How to select the correct Excel chart type for your data.
  • The most important elements of a Microsoft Excel chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more
  • Modifying an Excel Graph visually: styles and colors, create a pictograph, shapes, effects, text etc.
  • Basic Excel Charts like Column charts, Bar charts, Pie charts, Line charts.
  • Advanced Excel Charts like Speedometer, Pareto, Gantt, Thermometer and Bullet Chart
  • Updating and printing charts
  • Bonus material: Excel templates + Sample files + cheat sheets
  • Bonus Lecture : Excel most useful shortcuts etc

Only basic prior experience in Microsoft Excel or Spreadsheets is required to get the most out of this Excel course.

At the end of this Microsoft Excel class you will be given a Certificate of Completion.

So what are you waiting for? Begin creating the kind of charts you want and enroll now!

Thank you and I'll see you inside the course.

What are the requirements?

  • This course was recorded with Excel 2013 but it's also compatible also with Excel 2007 and 2010
  • It is also compatible with Microsoft Office for Mac
  • Only basic prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel course

What am I going to get from this course?

  • Create designer-quality Charts in Microsoft Excel with real-world examples. BONUS: Excel Workbook files + Sample files included
  • Improve general Excel knowledge
  • Learn from an instructor with over 16 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
  • Learn the most current version of Microsoft Excel 2013
  • Learn through quizzes and exercises

What is the target audience?

  • Excel users who wants to learn how to create Excel Charts
  • Students with a willingness for learning
  • Business Professionals + Entrepreneurs

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!
Be a Great Student!
Preview
00:53
Introduce Yourself!
Article
Download the Excel Project Files + Course Study Tracker
Article
I need your help!
01:02
Section 2: CREATING, RESIZING AND MODIFYING CHARTS
04:09
Building charts and graphs is one of the best ways to visualize data in a clear, easily digestible manner. Here are the simple steps you need to select Data and build a Chart or Graph in Excel.
04:12

A simple chart in Excel can say more than a sheet full of numbers

Bar chart or Line? Scatter plot or box plot? These are the questions we ask ourselves when we set out to make a chart. Because, “Selecting right chart for our data” is very important to tell our story.

In this lecture, we will learn how to choose the best chart based on our data and situation.
04:04

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.

In this lecture we'll learn to use three different keyboard methods to resize a chart and to move it to any location.

03:37

Excel templates are great because they can be applied to different business scenarios and be reused time and time again. Sometimes, one of your business templates may need some minor tweaks to better suit your current purposes, but having a good template on hand will save you a lot of time and effort.

Excel also includes the Live Preview feature, which enables you to see how a new font, font size, table style, cell style, or number format would look on your selected data before you actually apply it. This feature saves tons of time that would otherwise be wasted applying format after format until you finally select the right one.

We'll learn all the above and many more!
02:13

After you create a chart, you can instantly change its look. Instead of manually adding or changing chart elements or formatting the chart, you can quickly apply a predefined layout and style to your chart. Excel provides a variety of useful predefined layouts and styles (or quick layouts and quick styles) that you can select from.

You can customize a layout or style of a chart further by manually changing the layout and style of the individual chart elements that are used in the chart.

in this lecture we'll learn many ways to change the whole appearance of a chart.

QUIZ 1: CREATING, RESIZING AND MODIFYING CHARTS
3 questions
4 pages
Cheat Sheet of the Lecture Feel free to share it of download it.
Section 3: FORMATTING & CUSTOMIZING CHARTS
03:27

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.

A chart has many elements. Some of these elements are displayed by default, others can be added as needed. You can change the display of the chart elements by moving them to other locations in the chart, resizing them, or by changing the format. You can also remove chart elements that you do not want to display.

After you create a chart, you can modify any one of its elements.

02:59

The Chart Tools Format tab in Excel contains command buttons that make it easy to format particular chart elements after you select them. Excel gives you a choice of methods for selecting individual chart elements

Add easily whatever chart element you want using manual or automatic methods.

04:29

To easily update a chart or axis title, label, or text box that you have added to a chart, you can link it to a worksheet cell. Changes that you make to the data in that worksheet cell will automatically appear in the chart.

Learn a bunch of ways to add and change the title of a chart.

05:56

To make chart data easier to understand you can display or hide chart axes. You can also make adjustments to the way that chart axes are displayed.

Can you have a secondary axis or more in your chart? Learn how to do that.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

05:30

Learn how to Customize Axis Labels and gridlines for a great-looking Excel Chart

The different layouts of a chart and the importance of elements, like labels and gridlines.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

QUIZ 2: FORMATTING & CUSTOMIZING CHARTS
3 questions
CHEAT SHEET ~ Select Layouts and learn to modify all the elements
1 page
CHEAT SHEET ~ Chart Titles and how to link them with a cell
1 page
Section 4: UPDATING & PRINTING CHARTS
02:59

Updating a Chart with new Data is extremely useful

in this lecture you'll learn how to add new data in the chart using mouse or keyboard. Also how to link a chart from multiple data sources

02:14
How to print a chart or a worksheet using page break preview.
02:57

In this video tutorial I’ll show you how to convert a word document with data into an excel worksheet. Our goal is to take a document with text laid out in paragraphs and turning it into a field of cells. This is not so difficult because both Word and Excel have certain feature sets that  can help you transition your document into a spreadsheet.

QUIZ 3: UPDATING & PRINTING CHARTS
2 questions
Section 5: WORKING WITH TEXT, PICTURES, SHAPES AND EFFECTS
03:23

Excel Chart provides a way to represent data visually, but by customizing chart we can convert it in to pictograph (graph with pictures). It is an ideogram which convey its meaning through depicting images which resembles real-world objects, eventually making chart self-explanatory.

Learn how to create a Pictograph and show your data with an impressive visual way.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

02:21

How can we make the charts pretty without loosing any effect?

Amazing shapes and effects for your chart, like shadow, glow and 3D rotation.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

03:25

A great way to add fancy text to your sheet is using the WordArt command. WordArt is a way to add creative text to your Worksheet.

Also learn how to add text anywhere in the chart, using various ways.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

QUIZ 4: WORKING WITH TEXT, PICTURES, SHAPES AND EFFECTS
3 questions
CHEAT SHEET ~ Using Text, Pictures, Shapes and Effects
1 page
Section 6: BASIC CHART TYPES
02:55

A column chart emphasizes variation over a period of time. In a column chart, categories appear horizontally and values appear vertically.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

01:33

Bar chart...a column chart rotated 90 degrees.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

03:15

A line chart shows the relationship of the changes in the data over a period of time. The line chart emphasizes trends rather than the amount of change.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

04:30

Pie charts contain just one chart data series. A pie chart shows the relationship of the parts to the whole.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

01:05
A doughnut chart is similar to a pie chart except for its ability to display more than one data series.
01:27

An area chart shows the relative importance of values over time.

02:22
Scatter charts are useful for showing a correlation among the data points that may not be easy to see from data alone. Ideal for scientific, statistical or engineering data.
00:47
Bubble charts compare sets of three values as kind of a combination of an Scatter chart with an Area chart.
01:06

A radar chart, also known as a spider chart or a star chart because of its appearance, plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring.

A surface chart shows a three-dimensional surface that connects a set of data points. A surface chart is useful when you want to find optimum combinations between two sets of data.

03:41
Stock charts show nearly any combination of a stock's highest and lowest values, its open and close values, and the volume of trade for that stock.
01:56

A combination chart is a chart that combines two or more chart types in a single chart.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

QUIZ 5: BASIC CHART TYPES
3 questions
Section 7: MASTER EXCEL CHARTS
03:17

Gantt charts make it easy to visualize project management timelines by transforming task names, start dates, durations, and end dates into cascading horizontal bar charts.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

06:45

In this lecture we will create an amazing workable speedometer or gauge graph.

Speedometers are often used in professional dashboard and provide key performance informations about current indicators.

Download the Excel workbook used in the video tutorial and try the lesson yourself.
03:40
Found in many dashboards, the bullet graph serves as a replacement for dashboard gauges and meters.
02:55
A Pareto chart combines a column chart and a line graph. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes. Download the Excel workbook used in the video tutorial and try the lesson yourself.
06:11
An Excel Waterfall chart shows the cumulative effect of positive and negative amounts, based on a starting value. Download the Excel workbook used in the video tutorial and try the lesson yourself.
04:24
Comparing values is one of the reasons why we make charts. A thermometer chart can help us to compare targets with actual values. So it's an excellent chart which help us to measure performance or the percentage of a task.
SPARKLINE CHARTS & GRAPHS
Preview
04:58
CLUSTERED STACKED COLUMN CHART
02:14
LINE CHART WITH KPI BANDS
04:41
HISTOGRAM ~ with Frequency Distribution
03:03
04:04
Have you ever seen a population pyramid chart? In this lecture you are going to learn how to create an age pyramid chart with simple step-by-step instructions.
03:21

There are times that we want to compare some data, for example product sales, for a specified period. A great choice is by creating and using bi-directional bar charts in Excel.

01:53

Tornado charts are a version of bar charts used by decision makers to show a financial analysis for a project.


09:31

In this video tutorial we are going to make a Box and Whisker Diagram.
Box and Whisker Charts (Box Plots) are commonly used in the display of
statistical analyses. Excel doesn’t offer a box-and-whisker chart, but
you can create your own custom Box and Whisker charts, using stacked bar
or column charts and error bars. the box-and-whisker plot
shows the minimum, first quartile, median, third quartile, and maximum
of a set of data. Statisticians refer to this set of statistics as a five-number summary.

How can I help you?
Article
My Final Thoughts & Thank you!
00:44
Section 8: BONUS SECTION
Amazing discount for my other courses!
Article
BONUS ~ 10 Top Powerful Excel Shortcuts
02:01
3 unknown methods to select an Excel Data Range
4 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andreas Exadaktylos, Teacher|Msc Computer Scientist

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.

I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.

I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.

I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.

I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.

Ready to start learning?
Take This Course