Excel Dashboard Secrets - Create Awesome Excel Dashboard
4.3 (73 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,433 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Dashboard Secrets - Create Awesome Excel Dashboard to your Wishlist.

Add to Wishlist

Excel Dashboard Secrets - Create Awesome Excel Dashboard

Learn Dash-Boarding by creating 17 Live Excel Dashboards! Master advance Excel techniques by creating Dashboards
4.3 (73 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,433 students enrolled
Created by Amey Dabholkar
Last updated 8/2015
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 19 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
41 Lectures
03:08:50
+
Create Scrolling Table
2 Lectures 14:55
Exercise Files --- Download This First
00:02

Create a Scrolling Table -- Show data in Effective Format to the Viewers
14:53
+
Scrolling Chart and Dynamic Labels
2 Lectures 15:57
Exercise Files -- Download This First
00:01

Create Scrolling Chart and use Dynamic Label -- Show chart in Effective manner
15:56
+
Highlight Selected Row or Column
2 Lectures 12:05

Download the Exercise Files

Exercise Files -- Download this First
00:01

Highlight Selected row or column -- Make data easily view able
12:04
+
Create Awesome Excel Graphics
2 Lectures 09:15
Exercise Files -- Download This first
00:01

Create Awesome Excel Graphics -- Make Dashboard Look Perfectly Designed
09:14
+
Dynamic Sales Dashboard Efficient use of check boxes
3 Lectures 27:26
Exercise FIles -- Download This First
00:01

Dynamic Sales Dashboard -- Making things arranged properly
15:11

Dynamic Sales Dashboard -- Completing your dashboard
12:14
+
Comparative Dynamic Sales Dashboard -- Show off your Sales
2 Lectures 08:13
Exercise Files -- Download This First
00:01

Comparative Dynamic Sales Dashboard and Combo box Tutorial
08:12
+
Income Expense Chart -- Express Incomes and Expenses in a Different way
2 Lectures 05:07
Exercise Files -- Download This First
00:01

Income Expense Chart -- Express The Income and Expenses in the New Way
05:06
+
A Simple Dynamic Dashboard
2 Lectures 07:09
Exercise Files -- Download This First
00:01

+
Roll Over Method -- A New Application of Hyperlink Function
2 Lectures 07:28
Exercise Files -- Download This First
00:01

Roll Over Method Demonstration and a small Dashboard with Roll Over method
07:27
10 More Sections
About the Instructor
Amey Dabholkar
4.2 Average rating
92 Reviews
1,939 Students
3 Courses
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