4.54 out of 5
4.54
1009 reviews on Udemy

Excel Dashboards and Data Analysis Masterclass

Create 4 Eye-Catching Dynamic Microsoft Excel Dashboards from Scratch (Excel Dashboard Templates + Workbooks Included)
Instructor:
Andreas Exadaktylos
7,751 students enrolled
English
Create 4 Professional Interactive Excel Dashboards from scratch
Create over 10 Amazing Interactive Non-Standard Charts in Microsoft Excel. BONUS: Excel Workbook files + Sample files included
Improve general Excel knowledge - Pivot Tables and Pivot Charts, Conditional Formatting, Functions, Formulas and Macros
Understand and Identify the Principles of Data Analysis
Build Interactive Dashboard Reports with Buttons and Drop Down Menus
Learn from an instructor with over 18 years of experience with Microsoft Excel, teaching thousands of students in his own computer learning school
Analyze Excel data using Excels based Functions
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

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 4 well-designed Dashboards from Scratch!

Content and Overview

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

With over 100 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!

  • You will learn the latest versions of Microsoft Excel (2019,2016 and 2013) but the concepts are compatible with Excel 2010 and 2007.

  • Compatible with Microsoft Office for Macintosh

What am I going to get from this course?

  • Learn the Dashboard Creation Process from start to finish

  • Create 4 complete Professional Dashboards: Business Sales Dashboard, KPI Dashboard, Pivot/Slicer Dashboard and Traffic lights Dashboards

  • How to create amazing data visualizations in a matter of seconds!

  • How to import and work with Externel Data in Excel

  • Modifying an Excel chart visually: styles and colors, create a pictograph, Excel’s camera tool, shapes, effects, text etc.

  • Learn useful functions like VLOOKUP, INDEX, MATCH, HLOOKUP, SUMPRODUCT, CHOOSE etc

  • How to create mini charts like Sparklines and make data analysis fun!

  • Advanced Excel chart types like Pyramid charts, Pareto charts, Gantt charts, Gauge-Speedometer charts, Waterfall Charts, Bullet charts and Waterfall charts.

  • How to create Form Controls like Combo Box, Scroll Bar, List Box, Check Box etc

  • How to Protect your  Dashboard

  • Bonus material : Excel most useful shortcuts 

Enrol now and enjoy the course!   

Who is this course for?

  • Students

  • Entrepreneurs

  • 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

INTRODUCTION

1
Introduction & Course Outline

Hi, I’m Andreas and I want to thank you for taking this course on Excel Dashboards and Charts. In this course, I’ll teach you how to create stunning dashboards and advanced charts.

2
DOWNLOAD: Project Files & Course Study Tracker &Important Notes for New Students

DASHBOARD DESIGN PRINCIPLES

1
Design Principles & Tips
2
Dashboard Creation Process
3
Color Tips & Layouts
4
Building an Effective Data Model

An effective data model provides the foundation upon which your dashboard or report is built

5
Understanding the Dashboard Design Principles

CHARTING TECHNIQUES

1
Making the Right Chart
2
Introducing Excel Charts
3
Formatting Charts
4
Advanced Charting and Formatting Tips
5
Camera Tool
6
Useful Keyboard Shortcuts and Tips
7
How to Make a Dynamic Chart with Drop-Down Lists and Filters
8
Practicing Charting Techniques

DASHBOARD SOURCE DATA

1
Importing External Data
2
Importing External Data from Text File
3
Importing Data From Excel Spreadsheet
4
Importing Data from Microsoft Access

DASHBOARD FUNCTION TOOLBOX

1
INDEX and MATCH Functions
2
OFFSET Function

In this lecture we are going to learn about the OFFSET Function. We’ll talk about what the formula is, learn some examples and how to use the OFFSET function to build dynamic named ranges.

3
ROWS and COLUMNS Functions

Hello everyone!

In this video tutorial, we are going to talk about Excel ROWS and COLUMNS Formulas. So let’s dive in!

4
Text Functions: LEFT, RIGHT, MID, LEN, TEXT, TRIM, LOWER, UPPER, PROPER, REPT
5
SMALL and LARGE Functions
6
VLOOKUP Function
7
SUMPRODUCT Function

The SUMPRODUCT function multiply values from two or more ranges of data, add the results and return the sum of the products.

8
SUMIFs and COUNTIFs Functions
9
CHOOSE Function

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.

10
Create a Timesheet using INT and MOD Functions
11
DASHBOARD FUNCTION QUIZ
DASHBOARD FUNCTION TOOLBOX

DASHBOARDS COMPONENTS & ADVANCED CHARTS

1
TOP and BOTTOM Ranking Chart
2
Sparklines and Win/Loss Charts

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.

3
Create a Dashboard using Sparklines

Sparklines are one of the best chart types to include in dashboards

Sparklines were first introduced by Edward Tufte in his book Beautiful Evidence. Tufte says: “A sparkline is a small intense, simple, word-sized graphic with typographic resolution.” Stephen Few expands Tufte's definition in his book Information Dashboard Design: “Their whole purpose is to provide a quick sense of historical context to enrich the meaning of the measure. This is exactly what's required in a dashboard.”

In this Dashboard each item of information is displayed in a way that can be quickly examined to assess performance.

4
In-Cell Charts & REPT Function

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

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

5
Comparisons & In-Cell Charts with Conditional Formatting

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

6
Highlight Comparisons

In this Lecture we will create a combination of Data Bars , Icon Sets and special fonts to emphasize key metrics visually.

7
Symbols in Formulas & Charts - IF Function

In this lecture, we are going to learn how to use symbols in formulas and insert them into our chart. The symbols are also known as Unicode characters. Especially we are going to use up and down arrows.

8
Conditional Formatting: Build a Heat Map
9
Rollover Method-how to create a 5-star rating system with Excel Dynamic On-Deman

Hi everyone, in this lesson, I am going to talk about the rollover method and how we can use it to show us dynamically on-demand chart details.

Specifically, we will create a table of these products and a dynamic chart showing us the rating of each product. To do that, I will use formulas, with the help of INDEX, MATCH, AVERAGEIF, COUNTIFS, IFERROR and HYPERLINK functions. Also, I will use the Rollover Method, User Defined Functions or UDF, Macros, VBA code, Advanced Filter and conditional formatting.

You will learn a lot of new staff in this video tutorial, so pay attention because it’s a crafty tutorial.

Let’s dive in!

10
Excel Animated Chart using VBA Code
11
Excel Infographics: How to Create a People Graph
12
Dot Plot Chart & Dumbbell Chart
13
Top 5 ways to create a Funnel Chart
14
Excel Small Multiples
15
PANEL CHART
16
BULLET CHART ~ Ideal for Dashboards

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

17
POPULATION PYRAMID CHART

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.

18
BI-DIRECTIONAL BAR CHART - Comparing Data

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.


19
THERMOMETER CHART ~ Measuring Performance
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.

20
WATERFALL or BRIDGE CHART ~ For Sales Analysis

An Excel Waterfall chart shows the cumulative effect of positive and negative amounts, based on a starting value. 

21
BOX AND WHISKER DIAGRAM ~ STDEV, QUARTILE & MEDIAN Function

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.

22
DASHBOARDS COMPONENTS: SPARKLINES - MINI CHARTS

Quiz of Section:8

FORM CONTROLS & DYNAMIC CHARTS

1
Combo Box & INDEX Function

Learn how to create awesome dynamic charts with INDEX function.

2
Option Buttons
3
Scroll Bar

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.

4
Scroll Bar Example: Create a Dynamic Heat Map
5
Scroll and Sort Table with Formulas & Conditional Formatting
6
Check Box

In this lecture we are going to learn how to make a check box and how we can use it for a dashboard. A check box turns on or off a value that indicates an opposite and unambiguous choice. Check boxes are one of the simplest yet effective form controls to use them in a Dashboard

7
List Box - INDEX & COLUMN Function

List boxes are another great tool for creating Dashboards. With a list box you can control a chart or a bunch of charts.

8
Dynamic Data Range & OFFSET Function

If you cannot use data tables, you can use OFFSET formula to make dynamic ranges for chart data.

9
Dynamic Chart with Tables

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

10
Dynamic Chart with Data Filters

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

PIVOT TABLES & CHARTS TECHNIQUES

1
The anatomy of a Pivot Table

Pivot tables allow you to manipulate report output for ad hoc and interactive analysis.

The Pivot table is composed of the following areas:

  • Filters
  • Rows
  • Columns
  • values

Learn how to create a Pivot Table easy.

2
Variances in Pivot Table & Filtering

In this lecture, we are going to learn how to create and modify a Pivot Table

3
How to use the GETPIVOTDATA function
4
Create a Pivot Chart

A PivotChart can help you make sense of this data. While a PivotChart shows data series, categories, and chart axes the same way a standard chart does, it also gives you interactive filtering controls right on the chart so you can quickly analyze a subset of your data.

Learn the two main methods to create a Pivot Chart.

5
Pivot Slicers as Buttons to Filter Data

Slicers provide buttons that you can click to filter PivotTable data. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable report.

Learn how to present Pivot Charts in an interactive way using Slicers and various ways to modify a Pivot Chart.

6
Formating Pivot Chart & Field Buttons

You can filter the data in a pivot chart directly using field buttons.

How can we change the colors, elements and layout of a chart? Also learn an easy way to filter the data inside the chart, using field buttons.

7
PIVOT TABLES & CHARTS TECHNIQUES

PIVOT TABLES & CHARTS TECHNIQUES

BUSINESS SALES DASHBOARD

1
Prepare a Mock-Up of your Dashboard

In this Lecture we are going to learn how to make a mock-up of the dashboard

2
Setup of Calculation Worksheet
3
Complex Lookup Calculations with +SUMPRODUCT Function
4
Preparing Data for Bullet and Clustered Stacked Chart
5
Create Metrics with Sparklines & Conditional Formatting
6
Starting to Build your Dashboard
7
Dashboard-Final Touches
8
Create Beautiful Background and Design for our Sales Dashboard

KPI DASHBOARD

1
Preparation of the KPI Dashboard
2
Set Up a Sorting Procedure for KPI’s
3
Get The Data Sorted - Use of RANK, LARGE, CHOOSE, ROWS, INDEX & MATCH Formulas
4
Add Visualizations & In-Cell Charts
5
Final Touches

PIVOT / SLICER DASHBOARD

1
Create the Pivot Table

Learn how to create effective professional dashboards using Pivot Charts and Pivot Tables - Part:1 

2
Create the Line and Doughnut Chart

Learn how to create effective professional dashboards using Pivot Charts and Pivot Tables - Part:2 

3
3D Clustered Column Chart, Slicers and Timeline

Learn how to create effective professional dashboards using Pivot Charts and Pivot Tables - Part:3 

TRAFFIC LIGHTS DASHBOARD

1
Start designing our dashboard: Data Validation, OFFSET & MATCH Formulas

In this 4-part lecture you'll learn how to create a really impressive Sales Dashboard with Traffic Lights and Sparklines. These techniques can be used on any Dashboard.

2
Using Nested IF formulas & AVERAGE for our calculations
In this 4-part lecture you'll learn how to create a really impressive Sales Dashboard with Traffic Lights and Sparklines. These techniques can be used on any Dashboard.
3
Designing the traffic lights with the help of Excel's Camera Tool
In this 4-part lecture you'll learn how to create a really impressive Sales Dashboard with Traffic Lights and Sparklines. These techniques can be used on any Dashboard.
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
1009 Ratings

Detailed Rating

Stars 5
612
Stars 4
252
Stars 3
105
Stars 2
24
Stars 1
16
659b7d5b6bb151b63d63bfbd00d310a4

Includes

9 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion