Excel Dashboards Masterclass

Create Excel Dashboards, Interactive Excel Graphs and Pivot Charts with Microsoft Excel 2013 + Free Excel Templates
4.3 (163 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.
3,430 students enrolled
$195
Take This Course
  • Lectures 104
  • Contents Video: 4.5 hours
    Other: 2 hours
  • Skill Level All Levels
  • Languages English
  • 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 12/2014 English

Course Description

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.

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.

What are you waiting for? Enroll now! (it is 100% no risk deal)


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. Microsoft 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
  • I update the Excel class monthly with new lectures!
  • It has a quiz after section so to prove that you have learned the material.
  • You will learn the most current version of Microsoft Excel (2013) but the concepts are compatible with Excel 2010, Excel 2007 and the brand new Excel 2016
  • Compatible with Microsoft Office for Macintosh


What am I going to get from this course?

  • How to select the correct Excel chart type for your data.
  • How to create amazing data visualizations in a matter of seconds!
  • 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 chart visually: styles and colors, create a pictograph, Excel's camera tool, shapes, effects, text etc.
  • Basic Excel chart types like Column charts, Bar charts, Pie charts, Line charts, 3D charts, Scatter charts, Bubble charts, Stock charts, Surface charts and Radar Excel charts.
  • How to create mini charts like Sparklines and make data analysis fun!
  • Advanced Excel chart types like Combo charts, Pareto charts, Gantt charts, Gauge-Speedometer charts, Waterfall Charts, Bullet charts and Frequency charts.
  • How to create impressive Dynamic Professional Excel Charts with 5 different methods.
  • How to create Business Dashboards and Excel Reports.
  • How to create Excel Pivot Tables, Pivot Charts and how to add Slicers to help you filtering your data.
  • Create a Histogram in Excel, using Frequency Distribution.
  • How to create all types of Excel Sparklines.
  • The secrets of linking Excel Graphs with other programs and printing charts
  • Bonus material : Excel most useful shortcuts etc
  • How to create and use Functions-Formulas for Excel Charts.

Enrol now and enjoy the course!


Who is this course for?
  • Entrepreneurs
  • Students
  • Business Professionals
  • Everyone who wants to master Excel Graphs, Pivot Charts and Dashboards
  • Students with willingness for learning

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.


Testimonials for this Course

"I learned so many new excel tricks from this course. It covers almost everything. Andreas impressed me for updating his course so often! It worth every cent. Great job!" - Chris K

===================================================================

"Outstanding course! Very thorough and easy to understand. Sample spreadsheets make it very simple to follow along and provide hands on work. I would highly recommend this course." - Kelli Kellen

===================================================================

"A strongly recommend the course for all type of excel users. The lecturer follows a systematic and inspiring approach to present the most important techniques for data visualization with Excel." - Tommy Kalman

===================================================================

*** learning is more effective when it is an active rather than a passive process *** Euripides Ancient Greek dramatist

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 Professional Dynamic Excel Charts and Business Dashboards
  • Create amazing Interactive Charts in Microsoft Excel with real-world examples. BONUS: Excel Workbook files + Sample files included
  • Improve general Excel knowledge - Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
  • Create eye-catching visualizations
  • Follow along with included Excel project files
  • 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
  • Course updated regularly
  • An instructor ready to answer your questions in less than 24 hours
  • Watch high-quality video lectures with lifetime access
  • Quizzes and exercises
  • Certificate of completion

What is the target audience?

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

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: INTRODUCTION
Introduction
Preview
01:30
Article
  1. Please click on the download link on the right hand side of your panel (the second icon on the top) and download the .ZIP File. It has all the Excel Project Files + Samples & Templates. They are the same i use and they have descriptive names (so you can find them easy).
  2. Also download the Course Study Tracker. It will help you track your progress
  3. Finally, there is a file that has instructions on what to do if your language preferences is English (United States)

Enjoy!

Article
Please take one minute to introduce yourself to the rest of the course
How to view in HD
Article
03:49

Dashboards can be powerful tools in communicating your organization's important measurement data at a glance.

Here are 10 golden rules

Section 2: ANALYZING A DASHBOARD WITH FUNCTIONS
06:13

The VLOOKUP function is the king of all lookup functions in Excel.The VLOOKUP or vertical lookup function finds a specific value in the first column of a lookup table and returns the corresponding value in a specified table column.

Both VLOOKUP and data validation are essential for a Dashboard.

Download the Excel Project + Sample Files used in the video tutorial and try the lesson yourself.

HLOOKUP function
Preview
02:43
SUMPRODUCT Function
03:29
03:21

The Microsoft Excel CHOOSE function returns a value from a list of values based on a given position.

The CHOOSE formula is simple to write.

=CHOOSE(some number, value 1, value 2, value 3....)

and CHOOSE will pick a value based on some number.

Section 3: BEGINNERS: INTRODUCTION TO 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.

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

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.

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

04:06

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.

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

03:39

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!

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

02:14

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.

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

How can I help you?
Article
4 pages

Cheat Sheets of Section 2.

Feel free to share it of download it.

1 page

Cheat Sheet of the Section

Feel free to share it of download it.

4 questions

QUIZ 1

3 questions

QUIZ 2

3 questions

QUIZ 3

2 questions

QUIZ 4

Section 4: UPDATING, SHARING AND PRINTING A CHART
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

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

02:31

A common task on Excel is to have a chart and we need to update the data displayed by adding more data, from different worksheets.

Let's see how we can link different worksheets from different sources.

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

02:14

How to print a chart or a worksheet using page break preview.

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

01:46

How can we make a connection of a chart between Excel and Powerpoint or Word? Learn the methods in this lecture.

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

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.

Section 5: BEGINNERS: BASIC BUILD-IN 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.

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

01:27

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

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

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.

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

00:47
Bubble charts compare sets of three values as kind of a combination of an Scatter chart with an Area chart. Download the Excel workbook used in the video tutorial and try the lesson yourself.
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.

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

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.

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

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.

1 page

Cheat Sheet of the Lecture

Feel free to share it of download it.

1 page

Cheat Sheet of the Lecture

Feel free to share it of download it.

QUIZ
1 question
Section 6: 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.

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

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.

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

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.

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

03:11

Dynamic labels in Excel are labels that change according to the data you're viewing.

We can interactively change the labeling of data.

A common use for dynamic labels is labeling interactive charts.

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

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.

05:10

When you want to add a trendline to a chart in Microsoft Graph, you can choose any of the many different trend/regression types.

Linear, exponential or logarithmic trendlines?. Advanced statistical tools that you can learn in this lecture.

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

03:45

The most important function of a chart that is linked to an Excel workbook is the option to update the chart according to changes in the underlying data.We discuss in detail this subject and provide ways to link different ranges.

When you are build your Excel Charts, you may find that some of your data is not complete. Do you just present the data as is? Or do you fill in the gaps with interpolated values? Watch the video to learn!

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

5 pages

Cheat Sheet of the Section

Feel free to share it of download it.

4 questions

QUIZ

Section 7: GRAPHICS FOR CHARTS & DASHBOARDS
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.

01:29

Normally, an Excel chart stores data in a range. If you change the data in that range, the chart updates automatically. Sometimes you may want to unlink the chart from its data ranges and produce a static chart that remains unaffected by later changes in the data.

In this lecture you will learn how to convert your chart into a picture and use fantastic effects.

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

2 pages

Learn an easy and clever way to unlink a chart from its data by converting the SERIES formula range references to arrays with 5 quick steps

01:35

With Excel Camera tool, you will be able to take a snapshot of a selected datasheet portion. This enables you to place a live picture anywhere in the worksheet, you can apply different styles, colors, and designs over it. It also syncs the data with the image; whenever you make changes to the original data set, live image gets updated, showing you the latest cells values.

How that hidden powerful tool works?

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

Camera tool and 3 basic ways to enhance your Dashboard
Article
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.

1 page

Cheat Sheet of the Section

Feel free to share it of download it.

QUIZ 1
3 questions
QUIZ 2
1 question
Section 8: DASHBOARDS COMPONENTS: SPARKLINES - MINI CHARTS
04:18

Sparklines are small, simple charts that are easy to make, easy to understand, and small enough to fit in a single cell alongside your data.

Learn everything about sparklines and why they are useful for dashboards.

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

02:30

An in-cell chart is useful because it can instantly provide trending details.

Learn how to make an instant, in-cell bar graph.

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

Similar to sparklines, conditional formatting provides a way to visualize data and make worksheets easier to understand. Conditional formatting is more flexible, applying specified formatting only when certain conditions are met. By applying conditional formatting to your data, you can quickly identify variances in a range of values with a quick glance. It allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value.

Data Bars are horizontal bars added to each cell, much like a bar graph. Using the data bars conditional formatting option can sometimes serve as a quick alternative to creating a chart

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

Cheat Sheet of the Section

Feel free to share it of download it.

QUIZ
2 questions
Section 9: ADVANCED CHARTS & DASHBOARD COMPONENTS
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.


I need your help!
Article
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.

CLUSTERED STACKED COLUMN CHART
02:14
04:41

In this lecture we want to make a visual representation of the data, creating a line chart with four bands.

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

You can also download the SAMPLE file to see the final result.
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 information about current indicators.

Download the Excel workbook used in the video tutorial and try the lesson yourself.
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.
03:40

Found in many dashboards, the bullet graph serves as a replacement for dashboard gauges and meters.

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

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

In this video tutorial you'll learn how to make awesome thermometer charts.

03:03

A Histogram is a chart that displays frequency data.

Learn in this lecture to create a Histogram, showing specific data organized into breakpoints and using the function frequency properly.

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

CHEAT SHEET ~ Advanced Excel Chart Types
1 page
QUIZ
3 questions
Section 10: INTERACTIVE CHARTS & DASHBOARD CONTROLS
02:04

An easy and automatic way to create a chart that depends on a data set with a varying number of rows, using Table feature.

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

02:30

Did you know that your charts will dynamically adjust as you filter the underlying data? Learn how in this lecture.

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

03:57
If you cannot use data tables, you can use OFFSET formula to make dynamic ranges for chart data Download the Excel workbook used in the video tutorial and try the lesson yourself.
03:19

Learn how to create awesome dynamic charts with INDEX function.

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

05:36

Here is a dynamic way of presenting the information, for example month by month, based on your projections. A pretty effective way of presenting the information using form controls.

Learn all the steps to create a powerful dynamic chart and the usefuleness for the dashboards.

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

Dynamic Chart with Check Box (Form Control)
04:15
Dynamic Chart with List Box (Form Control)
06:12
CHEAT SHEET - PART:1 ~ Dynamic Charts - Learn how to create....
1 page
CHEAT SHEET - PART:2 ~ Dynamic Charts - Learn how to create....
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andreas Exadaktylos, Excel Instructor|Teacher|Msc Computer Scientist|Forex Trader

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