Excel Dashboard Secrets - Create Awesome Excel Dashboard

Learn Dash-Boarding by creating 17 Live Excel Dashboards! Master advance Excel techniques by creating Dashboards
4.2 (66 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.
1,389 students enrolled
Sale Ends Today!
62% off
Take This Course
  • Lectures 41
  • Length 3 hours
  • Skill Level Expert Level
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2014 English

Course Description

Latest: Course Updated on 25th March 2015.

Added 2 New Excel Dashboards. !!

1. Excel In Cell Chart Dashboard

2. Excel Gantt Chart Dashboard


Excel Dashboard Homework, Improved Quiz, Private Function Vs Public Function Excel Article

Over 2.5 Hours + of Dashboard content fully loaded with Advance Excel Techniques

Exercise Files which will help you to revise the content later

Over 800+ students having great content engagement !!!

Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. This complex data can be presented by creating Dashboard. Dashboard will help to quickly analyse the data, Find the draw backs, Expect the future outcomes and lots more

Master the creation of Interactive dashboard and learn to present it in a presentable format. Learn new techniques which will help to create complex Excel Dashboard.


  • Advance formulas and Functions
  • Learn to analyse the data
  • Learn to present the data in effective format
  • Learn to do complex excel task in a simpler way
  • Learn secrets of Charting
  • Learn Interactive Elements (Combo boxes, List boxes , Check boxes …)
  • Learn the effective utilization of Excel Features

Learn it by Your way!!

Udemy Provides access to the course for Lifetime. Hence repeat the course as many times you want and make your concepts clear. Learn anywhere and anytime.

Get the answers ready from the discussion corner.

Is this course for me?

This course is designed for a particular type of people who are aware with the basics and looking forward to master the intermediate techniques. Check out if this course is for you:-

  • If you need to analyse the data and find out the conclusion
  • Your Job is to analyse the data and present it to clients
  • Want to learn more in Excel
  • For Managers who have to take quick and quality decisions by analyzing data
  • For Managers who are managing the performance of the company
  • Students who want to learn more and advance in Excel
  • For IT Professionals who want to develop carrier in Excel
  • For anyone who wants to use Excel as a base to create projects and reports
  • For Excel lovers who wants to learn more..

Practically this course is suited for anyone who knows excel. This course is generally carried in fast pace and hence one needs to familiar with the basic and advance concepts in Excel


Contents and Overview of Lectures

There are over 30 + Lectures containing video and Downloadable Materials. The downloadable material are crucial part of learning Excel Dashboards. When one wants to revise the technique learned before he can achieve this by using Exercise Files provided in the course materials

Upon the completion of the course students have a variety of techniques which can be applied to the live data and create the reports. Students will be focused on how to create a dashboard without wasting lot of time.

Click the "take this course" button, top right, now ...every hour you delay is costing you money...

-Amey Dabholkar

What are the requirements?

  • Just a time of 20 Minutes a day to Learn
  • Microsoft Excel 2007+ (Some tricks requires 2010+)
  • Learn / Revise the basics and intermediate concepts in Excel
  • A Pen and Paper to note some important points

What am I going to get from this course?

  • Present data in an Effective format
  • Create awesome Static Dashboards
  • Create Interactive dynamic Dashboard
  • Learn some Excel techniques by creating Dashboard
  • Show off their dash boarding skills to colleagues and Boss

Who is the target audience?

  • Any Advance or Intermediate Excel User
  • This course should NOT be taken by New or Beginner Excel Users
  • Manager working in any stream who requires to present / Project / Analyse the data
  • Employee whose work is to create reports and present it in Effective Format
  • Any Excel lover who wants to learn more skills in Excel
  • An Excel user who is knowing basics/Advance and want to learn Excel at an Intermediate Level

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.


Section 1: Introduction
Introduction to the course - Watch this before you start learning
Brief Introduction on what you will learn
All Exercise FIles (.Zip File)
Section 2: Create Scrolling Table
Exercise Files --- Download This First
Create a Scrolling Table -- Show data in Effective Format to the Viewers
Section 3: Scrolling Chart and Dynamic Labels
Exercise Files -- Download This First
Create Scrolling Chart and use Dynamic Label -- Show chart in Effective manner
Section 4: Highlight Selected Row or Column

Download the Exercise Files

Highlight Selected row or column -- Make data easily view able
Section 5: Create Awesome Excel Graphics
Exercise Files -- Download This first
Create Awesome Excel Graphics -- Make Dashboard Look Perfectly Designed
Section 6: Dynamic Sales Dashboard Efficient use of check boxes
Exercise FIles -- Download This First
Dynamic Sales Dashboard -- Making things arranged properly
Dynamic Sales Dashboard -- Completing your dashboard
Section 7: Comparative Dynamic Sales Dashboard -- Show off your Sales
Exercise Files -- Download This First
Comparative Dynamic Sales Dashboard and Combo box Tutorial
Section 8: Income Expense Chart -- Express Incomes and Expenses in a Different way
Exercise Files -- Download This First
Income Expense Chart -- Express The Income and Expenses in the New Way
Section 9: A Simple Dynamic Dashboard
Exercise Files -- Download This First
Simple Dynamic Dashboard
Section 10: Roll Over Method -- A New Application of Hyperlink Function
Exercise Files -- Download This First
Roll Over Method Demonstration and a small Dashboard with Roll Over method
Section 11: Spark lines -- In Cell Charts. A New way to show off Dashboard Skills
Exercise Files -- Download This First
Sparklines Explanation and a Small Dashboard using Sparklines
Section 12: Interactive Dougnut Chart -- A Chart with some Formatting
Exercise Files -- Download this First
Interactive Doug nut Chart
Section 13: Thermometer Dashboard with Check Boxes
Exercise Files -- Download this First
Thermometer Dashboard and Check boxes Explanation
Section 14: 100 Block Chart or a Percentage Chart
Exercise Files -- Download these First
Block Percentage Chart
Section 15: Create awesome Static Excel Dashboard.
Exercise Files -- Download these First
Create Static Excel Dashboard
Section 16: Incell Chart - For All Versions of Excel
Download the Exercise File
Incell Chart - For All Versions of Excel without using sparklines
Section 17: Gantt Chart (Project Management)
Exercise Files -- Download these First
Gantt Chart - Show up the Schedule
Section 18: Give a test to know how much you have learned
6 questions

all the lectures comprehensive quiz

Excel Dashboard Home Work
Section 19: Excel Articles
Private Function and Public function in Excel VBA
2 pages
25 Excel Dashboard Design Principles
3 pages
Learn More about Dashboard
Section 20: Last Step
Last Step

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Amey Dabholkar, Excel Educator and Professional

Amey Dabholkar, is recognized in his teaching Microsoft Excel. He owns and runs his website which delivers high quality Excel content and articles. The website features tutorials which are in form of video and comprehensive article. He is also renowned Udemy Premium Instructor delivering high quality content. His Dashboard Course (Part One) which was one of the best launch in year 2014 received over 1000+ Students and high quality interaction.

Comments, Feedback includes that the person/student could apply the technique very next day. He teaches by giving real life Example with current industry standards hence users are satisfied with it. Ask questions till convinced because he provides lifetime updates and support for his course.

Business world/ corporate world now requires the deep knowledge of dashboarding, data mining, analysis etc. Excel is a very good application which can perform these thing

Ready to start learning?
Take This Course