Excel Dashboards : Build a Dashboard from Scratch! (Udemy.com)

Create Professional Looking Excel Dashboards and impress your employer !

Created by: Abdelrahman Abdou

Produced in 2018

icon
What you will 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 !

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Course Description

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 this course is for:
  • 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.

icon
Instructor Details

placeholder

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.5 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 !

icon
More courses by Abdelrahman Abdou

Excel Conditional Formatting Basics - The built in Features

$11.99

icon
Reviews

4.7

98 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

Thank you, Thank you, Thank you. You understand pivot tables. From the beginning you are actually talking about pivot tables rather than taking hours to get to the actual topic. You are very knowledgeable with pivot tables. I'm excited to see the finished dashboard. Great job, great explanation of the topics. Just an FYI, the linked files are completed files. All of the exercises are completed. Maybe make a notice somewhere that if we want to follow along, to take a copy of the file, delete some of the content, and then follow along with you. I'm very pleased with the topics at this time. I went through two "Dashboard classes last night from Udemy, I was extremely disappointed. I'm thankful that I did not strike out...with class #3.

Inspiring course and able teacher

Really great explanations, very professional and easy-to-follow. The only small adjustment I would recommend is to delete the answers in the downloadable materials, otherwise you have to delete them yourself before actually start working and in some cases it is a bit more complicated , like deleting and recreating ranges in Name Manager. Otherwise - really great course.

Very good instructions. plenty details and examples

Excellent course on Dashboards !

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.

Instructor is well versed and shows multiple possible applications and alternatives. Many neat tricks.

Was a great course. Very informative and easy to follow.

The instructor teaches very practical useful functions that really makes dashboarding less intimidating than it looks. Lessons are easy to understand and guided.

Good introductiory course. Somtimes too repetitive. Gives some very useful skills.

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

Very clear and understandable! His very articulate in his presentation and knowledgeable. I intend to purchase all of his courses.