Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
66 Videos (4h 35m)
    • About this Class

      1:56
    • Be a Great Student! (NEW 2/17)

      0:53
    • Dashboards: Design Principles and 10 Golden Rules (NEW 2/17)

      3:49
    • Building an Effective Data Model (NEW 2/17)

      2:51
    • Select Data and Create a Chart with various ways

      9:31
    • Choosing a Chart Type, Chart Templates and Live Preview

      3:39
    • How to select the right Chart for your Data?

      4:12
    • Three ways to resize a Chart and move it to any location

      4:06
    • Change the Layout or Style of a Chart

      2:14
    • Getting to Know the Elements of a Chart

      3:33
    • Quick Layouts and learn to modify all the elements of a chart

      2:59
    • Chart Titles and how to link them with a cell

      4:29
    • How to link data with the graph and how to fill the gaps of a chart

      3:44
    • Learn Chart Axes in depth and add a Secondary Axis

      5:56
    • How to use dynamic labels, titles and make your chart interactive

      3:11
    • Displaying Data - Custom Axis Labels and Gridlines

      5:30
    • How to use Statistics with Line Chart - choose the best trendline

      5:10
    • Updating and adding new data in Chart with keyboard and mouse

      2:59
    • Add new Data to an existing Chart, from different worksheets

      2:31
    • Linking charts with Word and Powerpoint

      1:46
    • Printing a chart and the page break feature

      2:14
    • Use Pictures in Chart and how to create a Pictograph

      3:23
    • Unlinking a Chart and saving it as a picture - Static charts

      1:29
    • Excel’s Camera Tool and how we can use it

      1:34
    • Using Shapes and Effects to make prettier Charts

      2:21
    • Using Text and Wordart fancy Styles in a Chart

      3:25
    • What Are Sparklines

      6:16
    • In cell charting techniques using REPT function

      4:36
    • Create Data Bars with Conditional Formatting

      4:12
    • COLUMN CHART ~ the most widely used chart type

      2:55
    • DOUGHNUT CHART ~ a pie chart displaying more than one data series

      1:50
    • SCATTER (XY) CHART ~ ideal for scientific, statistical or engineering data

      3:06
    • LINE CHART ~ show me the trend!

      3:15
    • PIE CHART~ show proportions to a whole

      6:20
    • BAR CHART ~ and the main difference with Column Chart

      1:33
    • AREA CHART ~ useful for time periods

      2:11
    • STOCK CHART ~ ideal for stocks or temperatures

      5:58
    • BUBBLE CHART ~ a combination of Scatter and Area Chart

      1:21
    • (NEW 3/2017) BURN DOWN CHART

      5:43
    • CASE STUDY ~ Create a line chart with KPI Bands and track conversion rate

      6:50
    • RADAR (OR SPIDER) & SURFACE CHART

      2:02
    • COMBO CHART ~ a combination of different chart types

      3:26
    • GANTT CHART ~ for project management applications

      5:23
    • SPEEDOMETER - GAUGE CHART ~ learn how to create and use them in Dashboards

      10:54
    • PARETO CHART ~ the 80-20 chart - for business analysis

      4:12
    • WATERFALL - BRIDGE CHART ~ Use them and make awesome sales analysis

      8:11
    • BULLET CHART ~ a variation of a thermometer chart

      6:03
    • THERMOMETER CHART ~ Ideal for Measuring Performance

      4:24
    • HISTOGRAM ~ with Frequency Distribution

      4:36
    • VLOOKUP Function and Data Validation Case Study

      6:13
    • Dynamic Chart with Tables

      2:43
    • Dynamic Chart with Data Filters

      3:13
    • Dynamic Chart with OFFSET Function

      4:58
    • Dynamic Chart with INDEX function

      4:44
    • Dynamic Chart with Form Controls: Scroll Bar

      8:31
    • The Anatomy of a Pivot Table JULY15

      2:20
    • How to Create a Pivot Chart Using Different Methods JULY15

      3:12
    • Changing The Format Of A Pivot Chart And The Role Of Field Buttons

      4:47
    • Create a Dashboard using pivot tables and pivot charts - PART3

      7:45
    • Modifying Pivot Chart and Use Slicers to Filter Data JULY15

      3:43
    • Dashboards Design Principles and 10 golden rules

      3:32
    • Create a Dashboard using Sparklines

      6:14
    • Create a Dashboard using pivot tables and pivot charts - PART1

      6:10
    • Create a Dashboard using pivot tables and pivot charts - PART2

      7:06
    • 10 Top Excel Shortcuts by Mellon Training

      2:01
    • CASE STUDY ~ Analyze Facebook Ad Reports with Excel Pivot Tables and Charts

      3:33

About This Class

Note: This course is regularly updated with new lectures, guides and projects.

Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates

Excel dashboards are a powerful way to leverage Excel functionality, build and manage better presentations and improve your Excel and data visualization skills. In this course I’ll show you how you can turn Excel into your own, personal Business Intelligence tool and create Interactive Charts and awesome Dashboards in Microsoft Excel.

Learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks

Content and Overview

Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Graphs and Dashboards?

While Excel offers dozens of chart types and hundreds of formatting options, making the right chart is the trickiest part. In order to use charts effectively, you'll need to understand how different charts are used.

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

With over 90 Lectures, quizzes, assignments, real-life Excel projects+SAMPLES and weekly updates, learning advanced Excel techniques has never been easier. This course is a concise and practical go-to guide for creating Interactive Charts and awesome Dashboards in Microsoft Excel. It also expands in to Pivot Tables, Pivot Charts, Conditional Formatting, Functions, Formulas and Macros.

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

What are you waiting for? Enroll now and make your charts look amazing!

3278fb4a

----------------------------------------------------------------------------------------------------------------

Why is this course different?

  • It’s super practical. Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.
  • It’s comprehensive and fast. Excel charts are complex, that’s why the course is broken down into bite-sized pieces
  • The course also expands in to Conditional Formatting and Functions-Formulas
  • You will learn the most current version of Microsoft Excel (2013) but the concepts are compatible with Excel 2010 and Excel 2007
  • Compatible with Microsoft Office for Macintosh

What you’ll learn:

  • How to select the correct chart type for your data.
  • How to create amazing data visualizations in a matter of seconds!
  • The most important elements of a chart, like chart and plot area, Design and Format tab, data labels, gridlines, legends, titles, axes, layouts and much more
  • Modifying a chart visually: styles and colors, create a pictograph, Excel’s camera tool, shapes, effects, text etc.
  • Basic chart types like Column charts, Bar charts, Pie charts, Line charts, 3D charts, Scatter charts, Bubble charts, Stock charts, Surface charts and Radar charts.
  • How to create mini charts like Sparklines and make data analysis fun!
  • Advanced chart types like Combo charts, Pareto charts, Gantt charts, Gauge-Speedometer charts, Bullet charts and Frequency charts.
  • How to create impressive Dynamic Professional Charts with 5 different methods
  • How to create Business Dashboards and Reports
  • How to create Pivot Tables, Pivot Charts and how to add Slicers to help you filtering your data.
  • How to create mini charts like Sparklines and make data analysis fun!
  • Create a Histogram using Frequency Distribution.
  • How to create all types of Sparklines.
  • The secrets of linking charts with other programs and printing charts
  • Bonus material : Excel most useful shortcuts etc

c28d6dec

c21dabce

Who is this course for?

  • Entrepreneurs
  • Students
  • Business Professionals
  • Everyone who wants to master Excel Charts
  • Students with willingness for learning

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

About the instructor

"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. 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 passion for software products that make people's lives easier.

Thank you and I'll see you inside!"

<> Euripides - Ancient Greek dramatist

Enrol now and enjoy

29a0b725

22 of 22 students recommendSee All

Very useful class! Highly recommended!
Very comprehensive class , covers everything. Clean instructions , professional instructor. Very pleased!
Very comprehensive and easy to follow class. The instructor is great and professional. I'll take more classes from him. Well done!

459

Students

--

Projects

Andreas Exadaktylos

Teacher | Expert Computer Scientist | Entrepreneur

LinkedIn: https://www.linkedin.com/in/andreasexadaktylos

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. 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 Masters Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to...

See full profile