Excel Dashboards : Build a Dashboard from Scratch!
4.1 (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.
2,556 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Dashboards : Build a Dashboard from Scratch! to your Wishlist.

Add to Wishlist

Excel Dashboards : Build a Dashboard from Scratch!

Create Professional Looking Excel Dashboards and impress your employer !
4.1 (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.
2,556 students enrolled
Created by Abdelrahman Abdou
Last updated 5/2017
English
Learn Fest Sale
Current price: $10 Original price: $195 Discount: 95% off
15 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 8 hours on-demand video
  • 1 Article
  • 35 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn how to build Professional Looking, Interactive Charts & Dashboards using Microsoft Excel.
  • Lifetime Access to all the lectures on the course.
  • Regular Video updates!
  • Fast and responsive support for any feedback or questions !
  • If you're not Satisfied, there's a 30 day money back guarantee !
View Curriculum
Requirements
  • You need to have Excel 2007 or higher installed on their computer (Some features won't work on Excel 2007)
  • You need to know Excel basics like writing SUM, COUNT, and IF Functions, Conditional Formatting, use pivot tables and Insert Charts.
  • No VBA Programming knowledge needed !
Description

*******************************************************

Course updated 25th of March 2017 - STUDENT SATISFACTION IS MY NUMBER ONE PRIORITY!

*******************************************************

Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others

2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.

3-Learning Dashboarding techniques.

4- Building a Complete Excel Dashboard.

What you need before taking this course

  • The will to learn !
  • You need to be using Excel already, written a few formulas such as SUM and COUNT, know how to build a basic pivot table and insert a chart.

A Powerful Skill at Your Fingertips

Excel is a great tool for creating Interactive Dashboards. It is relatively cheap with high availability compared to other more expensive tools, so learning how to build dashboards will be a great addition to your skills, and you can showcase these skills almost anywhere because Excel is installed on millions of computers around the globe!

If you're already an Excel user and want to learn how to create Interactive dashboards using Excel, impress your employer and potentially earn a raise, then this course is for you!


What other students are saying about the course:


Andrew Adolph:

I feel so lucky to have come across udemy and then a course on excel dashboards. I have always loved car dashboards, just displaying the most important info.

Today's dashboard in the business sense is the presentation of key performance indicators (kpi) for decision makers.

I am hooked on this course, and practicing making better dashboards. Adbelrahman is there to answer questions. To beautiful dashboards...

Luke Best:

Thanks Abdelrahman for an excellent course!

I use Excel most days so thought I had a decent grasp on how it all works. How wrong was I! This course has been a real eye-opener into what is actually possible in Excel and techniques covering how to present data.

I found the course material and presentation (videos) very comprehensive with plenty of examples to work through and use as reference for the future when I apply it all to my work.

An Excellent course and would highly recommend.

Michael Diamond:

I was impressed with some of the information presented. I have taken various dashboard courses to find little gold nuggets and i found a bunch in this course. The instructor provided some new twists for creating dynamic ranges, for example. He didn't present the normal formulas that I have seen from different sites but came up with some new approaches which caused my eyes to grow wider. I felt I was gaining a deeper understanding how excel thinks and works. His presentation showed me that he put some thought and effort into the presentation and made an effort to bring me from a Joe to a Pro!

Who is the target audience?
  • Excel users who want to up their skills by learning how to create Interactive dashboards using Microsoft Excel.
  • Accountants, Business, Financial, or Reporting Analysts, Stock or Forex Traders, Business Owners who want to build dashboards using Excel to monitor their business metrics or KPIs.
  • This is NOT for Excel beginners, so you need to have used Excel before, written a few formulas (Such as SUM, COUNT and IF Functions) and know how to create pivot table,Insert charts and use Conditional Formatting.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 75 Lectures Collapse All 75 Lectures 07:56:09
+
Introduction
5 Lectures 22:21

An Introduction lecture to the course.

Preview 05:34

Leaving a Review and Providing me with Feedback
05:01

In this lecture we explain the different types of data sets and the recommended dashboard layout

Data Preparation
03:27

This Lecture is the first of two lectures showing how to Unpivot data using Power query in Excel.

This first lecture is an introduction and it shows how to Setup Powerquery.

UnPivoting Data Part 1 - Introduction and setting up Power Query
06:08

This lecture is the 2nd lecture on how to Unpivot data using Powerquery.

This lecture shows how to do the unpivoting using Powerquery.

Example workbook is attached to this lecture.

Unpivoting Data Part 2 - Unpivoting the data
02:11
+
Must Know functions
24 Lectures 02:46:05

This Lecture will show students how to use the VLOOKUP function.

Downloadable resources are attached to this lecture and they include the ones for the HLOOKUP Video that will follow this video

Preview 08:56

This Lecture will show students how to use the HLOOKUP function

Resources are on the VLOOKUP video.

Preview 04:25

Exercises on how to use VLOOKUP and HLOOKUP.
Please check the workbook attached to the VLOOKUP video that contains both examples and Exercises for VLOOKUP and HLOOKUP.

VLOOKUP and HLOOKUP Exercise
00:41

This lecture explains the MATCH Function.

Example and Exercise workbook is attached to this lecture.

THE MATCH Function
03:57

Exercise to Practice using the Match Function.

Workbook containing the Match Example and Exercise is attached to the Match Function Video.

Match Function Exercise
00:55

ROW(),ROWS(),COLUMN(),COLUMNS() Functions
15:08

This lecture explains the basics of the Offset function.

Example workbook is attached to this lecture.

OFFSET Function- Basics
06:57

This lecture explains how to use the OFFSET function in combination with data validation lists.

Example workbook is attached to the OFFSET function basics lecture.

Dynamic Ranges with OFFSET Part 1 - Data Validation
14:05

This lecture explains how to use the offset function to create dynamic charts.

Example workbook is attached to the OFFSET function basics lecture.

Dynamic Ranges with OFFSET (Part 2) - Dynamic Charts
14:31

An Exercise on how to create Dynamic Ranges using the OFFSET Function.

Examples and Exercise Workbook is attached to the OFFSET Function Basics Lesson.

Offset Function Exercise
01:17

This lecture explains how to use the OFFSET function to create dynamically expanding/contracting ranges.

Example workbook is attached to the OFFSET function basics lecture.

Dynamic Ranges with OFFSET Part 3 - Dynamically Expanding Ranges
09:55

This lecture explains how to use the INDEX function for performing lookups.

Example and exercise workbook is attached to this lecture.

INDEX Function Part 1 - Using it For Lookups
06:20

This lecture explains how to use the INDEX function for creating dynamic ranges.

Example and Exercise workbook is attached to the previous lecture.

INDEX Function Part 2 - Creating Dynamic Ranges with INDEX
09:43

Exercise on how to use the Index Function.

Workbook containing Examples and Exercise is attached to Part 1 of the Index Function

Index Exercise
01:06


A Cool Application for the CHOOSE Function through using it to divide dates into Quarters !

Example workbook is attached to the previous video that explains the CHOOSE Function.

Cool Application for the CHOOSE Function - Dividing your Dates into Quarters !
06:00

Choose Function Application Exercise
00:20

This Lecture Explains how to use the SUMIF & SUMIFS Functions covering using them with dates as well.

Sheet containing Example and Exercise is attached to this lecture.

SUMIF & SUMIFS
15:19

Exercise for using SUMIF & SUMIFS functions.

Spreadsheet containing Example and Exercise is attached to the previous Lecture,

SUMIF & SUMIFS - Exercise
00:28

COUNTIF,COUNTIFS Functions
10:16

Exercise for using COUNTIF & COUNTIFS functions.

Workbook containing the exercise is attached to the previous lecture.

COUNTIF,COUNTIFS -Exercise
00:35

This Lecture Explains how to use the GETPIVOTDATA Function,

Example and Exercise are attached to this lecture.

GETPIVOTDATA Function
19:40

Exercise for using the GETPIVOTDATA Function.

Workbook having the Exercise is attached to the previous lecture.

GETPIVOTDATA Function - Exercise
00:35

Ranking Functions in Excel !
09:45
+
Let's Talk Charts ! (5th of February 2016)
14 Lectures 01:13:08
Performance against a Target Range
04:57

Exercise for presenting performance against a Target range.

Sheet is attached to the previous video that was explaining how to present performance against a target range.

Performance Against Target Range - Exercise (5th of February 2016)
01:07

Lecture Explaining how to create Vertical Bullet Charts

Sheet containing Examples and Exercise is attached to this lecture

Vertical Bullet Charts (5th of February 2016)
09:20

Exercise for drawing a Vertical Bullet Chart.

Exercise sheet is attached to the previous video explaining how to draw a Vertical Bullet Chart

Vertical Bullet Charts - Exercise (5th of February 2016)
00:52

Waterfall Chart
13:17

Exercise for drawing Waterfall Charts

Exercise Sheet is attached to the previous Lecture

Waterfall Chart -Exercise - (26th of March 2016)
00:21

This Lecture Explains how to draw a Pareto Chart

Example and Exercise Sheet is attached to this lecture.

Pareto Chart - (26th of March 2016)
05:43

Exercise for drawing Pareto Charts.

Exercise sheet is attached to the previous Lecture.

Pareto Chart - Exercise - (26th of March 2016)
00:24

This Lesson will teach students how to draw a basic Gantt chart in Microsoft Excel.

Sample file containing Example and Exercise is attached to this lesson.

Gantt Chart
09:26

An Exercise for Creating Gantt Charts - File is attached to the previous lesson

Gantt Chart- Exercise
00:31

This Video will Explain how to create a Speedometer Chart in Microsoft Excel.

Example file is attached to this video.

Speedometer Chart
10:15

This is an Exercise on creating Speedometer Charts in Excel.

File containing exercise and examples is attached to the previous lecture.

Speedometer Chart - Exercise
00:42

Creating Map Charts!
15:15

Map Charts-Exercise
00:58
+
Going Interactive!
14 Lectures 01:22:34

This lecture explains the button form control.

Example workbook is the attached to the Form controls introduction lecture.

Form Controls-Buttons
06:55

The Checkbox
04:16

This lecture explains the Listbox form control.

Example workbook is the attached to the Form controls introduction lecture.

Link to my Custom number formats Masterclass video is in the resources section for this video

The Listbox
08:21

This lecture explains the Scrollbar Control.

Example workbook is the attached to the Form controls introduction lecture.

The Scrollbar
05:59

The ComboBox
01:55

Scrollbar Application - Scrolling List
10:19

Scrollbar Control Application -Scrolling Charts
06:21

This Lecture explains how to use the Spin button form control.

Example workbook is attached to the first lecture in the chapter called "Form Controls- Introduction"

The Spin Button
09:24

Option Buttons (Part 1) - How to Insert
06:48

Option Buttons (Part 2) - Formatting
04:43

Option Buttons (Part 3) - Group Boxes
03:09

Slicers - User friendly Filters !
07:01

Pivot Charts
05:37
+
Dashboarding Techniques
11 Lectures 01:26:13
Dynamic Date filters (Part 1) - using slicers and Timelines
12:31

Dynamic Date Filters Part 2 - Using Combo boxes and data validation lists
16:08

Controlling Pivot Charts with Comboboxes
06:52

This Lecture will teach students how to get the Slicer Selection to be incorporated in formulas

Capturing Slicer Selection in Formulas
02:47

Ranking Techniques Part 1 -Automatic Ranking of Values
09:27

Second part of a 3 part video on ranking techniques. Example and Exercise Workbook is attached to the First video

25 Jan 2016 - Ranking Techniques (Part 2) - Dealing with Rank Ties
09:39

Third part of a 3 part video on ranking techniques. Example and Exercise Workbook is attached to the First video

25 Jan 2016 -Ranking Techniques (Part 3) - Using Rank with Dynamic Ranges
05:46

Ranking Techniques Exercise
01:07

Rollover Technique (Part 1) -HYPERLINK Function
04:50

Rollover Technique (Part 2) - The Rollover Technique
05:12

This Lecture explains how to create a system that allows the user to choose different aggregation methods using CHOOSE function, Tables, Pivot tables and Slicers

Choosing different aggregation methods technique-5th of June 2016
11:54
+
The Adventure Works Sales Dashboard
3 Lectures 19:21

AdventureWorks Dashboard (Part 2)- (Analysis)
07:59

AdventureWorks Dashboard (Part 3) - Events
06:16
+
Practice Practice Practice !
1 Lecture 03:27

Assignment Dashboard to Practice the techniques learned on the course.

Raw data file is on the resources section.

Preview 03:27
+
Bonus Lectures
3 Lectures 23:02

The First Part of A bonus lecture to show students how to use Excel Tables.

The Example sheet is attached to this lecture

Excel Tables (Part 1)
12:01

The Seconed Part of A bonus lecture to show students how to use Excel Tables.

The Example sheet is attached to the first part.

Excel Tables (Part 2)
04:13

This Lecture explains how to make your pivot tables refresh automatically when you open or close your workbook.

Example workbook is attached to the lecture.

Auto Refreshing Pivot Tables - Nice Trick!
06:48
About the Instructor
Abdelrahman Abdou
4.3 Average rating
247 Reviews
13,941 Students
3 Courses
Teaching 13000+ Students across 146 Countries !

Hi, I'm Abdelrahman and I'm an Excel Lover :)

I have a Bachelor's Degree in Chemical Engineering.

I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3 years.

I have more than 5 Years of Experience in Excel including building Dashboards and VBA.

I have created numerous dashboards in my company and automated tens of reports.

I love learning new things and my main learning method is through self-learning by watching video tutorials.

I love Excel and I'm trying to share the love with everyone else !