# Master Excel Dashboards and Excel Charts Premium class

## Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
62 Videos (4h 22m)

1:56
• 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
• 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

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

• Do you struggle drawing professional charts in Excel?
• Have you wasted your time searching countless hours for YouTube videos, trying to find useful content about Excel Charts?
• Do you want to learn how to make amazing Dynamic Excel Charts, Dashboards and Pivot Charts in a few weeks?

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 in Excel.

With over 70 Lectures, quizzes, assignments, real-life Excel projects 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 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!

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

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

Who is this course for?

• Entrepreneurs
• Students
• 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.

"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!"

<<...learning is more effective when it is an active rather than a passive process>> Euripides - Ancient Greek dramatist

Enrol now and enjoy

#### 17 of 17 students recommend

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

333

Students

--

Projects

Teacher | Expert Computer Scientist | Entrepreneur

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 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 love to create websites and optimizing 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