Excel Dashboard Secrets - Create Awesome Excel Dashboard

Learn Dash-Boarding by creating 17 Live Excel Dashboards! Master advance Excel techniques by creating Dashboards
4.4 (53 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,353 students enrolled
$40
Take This Course
  • Lectures 41
  • Contents Video: 3 hours
    Other: 7 mins
  • 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

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

Other:

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.

Learn:

  • 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

Dashboards are ULTIMATE PRODUCTIVITY SUITES

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

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

Curriculum

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

Download the Exercise Files

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

all the lectures comprehensive quiz

Excel Dashboard Home Work
Article
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
00:40
Section 20: Last Step
Last Step
Article

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