Excel Advanced Charts
4.5 (66 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,958 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Advanced Charts to your Wishlist.

Add to Wishlist

Excel Advanced Charts

Learn from scratch professional Advanced Excel Charts with Microsoft Excel 2013 - Excel Templates included
4.5 (66 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,958 students enrolled
Last updated 3/2017
English
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 4 Articles
  • 53 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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.

Who is the target audience?
  • Excel users who wants to learn how to create Excel Charts
  • Students with a willingness for learning
  • Business Professionals + Entrepreneurs
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 55 Lectures Collapse All 55 Lectures 02:47:14
+
WELCOME!
4 Lectures 02:50

Introduce Yourself!
00:28

Download the Excel Project Files + Course Study Tracker
00:26

I need your help!
01:02
+
CREATING, RESIZING AND MODIFYING CHARTS
6 Lectures 18:15
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.
Preview 04:09

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

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.

Preview 04:04

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!
Choosing a Chart Type, Chart Templates and Live Preview
03:37

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.

Change the Layout or Style of a Chart
02:13

QUIZ 1: CREATING, RESIZING AND MODIFYING CHARTS
3 questions

Cheat Sheet of the Lecture Feel free to share it of download it.
CHEAT SHEET
4 pages
+
FORMATTING & CUSTOMIZING CHARTS
7 Lectures 22:21

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.

Getting to Know the Elements and Types of a Chart
03:27

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.

Quick Layouts and learn to modify all the elements of a chart
02:59

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.

Chart Titles and how to link them with a cell
04:29

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.

Learn Chart Axes in depth and add a Secondary Axis
05:56

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.

Displaying Data - Custom Axis Labels and Gridlines
05:30

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
+
UPDATING & PRINTING CHARTS
3 Lectures 08:10

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

Updating and adding new data in Chart with keyboard and mouse
02:59

How to print a chart or a worksheet using page break preview.
Printing a chart and the page break feature
02:14

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.

How to import data from word document into excel worksheet
02:57

QUIZ 3: UPDATING & PRINTING CHARTS
2 questions
+
WORKING WITH TEXT, PICTURES, SHAPES AND EFFECTS
4 Lectures 09:09

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.

Preview 03:23

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.

Using Shapes and Effects to make prettier Charts
02:21

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.

Using Text and Wordart fancy Styles in a Chart
03:25

QUIZ 4: WORKING WITH TEXT, PICTURES, SHAPES AND EFFECTS
3 questions

CHEAT SHEET ~ Using Text, Pictures, Shapes and Effects
1 page
+
BASIC CHART TYPES
11 Lectures 24:37

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.

COLUMN CHART ~ the most widely used chart type
02:55

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

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

BAR CHART ~ and the main difference with Column Chart
01:33

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.

LINE CHART ~ show me the trend!
03:15

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.

PIE CHART~ show proportions to a whole
04:30

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

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

AREA CHART ~ useful for time periods
01:27

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.
SCATTER (XY) CHART ~ ideal for scientific, statistical or engineering data
02:22

Bubble charts compare sets of three values as kind of a combination of an Scatter chart with an Area chart.
BUBBLE CHART ~ a combination of Scatter and Area Chart
00:47

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.

RADAR (OR SPIDER) & SURFACE CHART
01:06

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.
STOCK CHART ~ ideal for stocks or temperatures
03:41

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.

COMBO CHART ~ a combination of different chart types
01:56

QUIZ 5: BASIC CHART TYPES
3 questions
+
MASTER EXCEL CHARTS
17 Lectures 01:07:50

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

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.

GANTT CHART ~ for project management applications
03:17

Hello Excel Funs, 

in this video tutorial we are going to build a Burndown Chart in Excel. Until now we learned how to create a Gantt Chart, helpful for a project progress. 

But a Burndown chart is a great project management tool which shows if a set of tasks are completed ahead of or behind schedule.

(NEW 3/2017) BURN DOWN CHART
05:43

Found in many dashboards, the bullet graph serves as a replacement for dashboard gauges and meters.
BULLET CHART ~ a variation of a thermometer chart
03:40

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.
PARETO CHART ~ the 80-20 chart - for business analysis
02:55

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.
WATERFALL - BRIDGE CHART ~ Use them and make awesome sales analysis
06:11

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


CLUSTERED STACKED COLUMN CHART
02:14

LINE CHART WITH KPI BANDS
04:41

HISTOGRAM ~ with Frequency Distribution
03:03

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.
POPULATION PYRAMID CHART
04:04

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.

BI-DIRECTIONAL BAR CHART - Ideal for comparing data
03:21

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


TORNADO CHART - Ideal for Showing Financial Analysis
01:53

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.

BOX AND WHISKER DIAGRAM
09:31

How can I help you?
00:26

My Final Thoughts & Thank you!
00:44
+
BONUS SECTION
3 Lectures 03:30
Amazing discount for my other courses!
01:29

BONUS ~ 10 Top Powerful Excel Shortcuts
02:01

3 unknown methods to select an Excel Data Range
4 pages
About the Instructor
Andreas Exadaktylos
4.5 Average rating
836 Reviews
10,992 Students
7 Courses
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.