Excel Dashboard Secrets 2 - Create Stunning Excel Dashboards
3.8 (11 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.
166 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Dashboard Secrets 2 - Create Stunning Excel Dashboards to your Wishlist.

Add to Wishlist

Excel Dashboard Secrets 2 - Create Stunning Excel Dashboards

A-Z Guide Creating Awesome Excel Dashboards,Learn Dash-Boarding by creating 20 Live Excel Dashboards Master Excel
3.8 (11 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.
166 students enrolled
Created by Amey Dabholkar
Last updated 11/2015
English
Current price: $10 Original price: $40 Discount: 75% off
6 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 19 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Create Stunning Excel Dashboards confidently
Learn Various Principles of Dash-boarding which could be applied in day to day life
Learn to create different types of charts
Creating Interactive as well as static Excel Dashboards
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 May require Excel 2010, 2013,2016)
  • Learn and Revise the Basic as well as the intermediate concept of Excel
  • A Pen and a Paper to take Notes
  • Techniques work on PC or MAC Computers
Description

______________________________________________________________________

Another course from the Creator of the Best Selling Course on Excel Dashboards this course will add to your knowledge to learn more than 20 Excel Dashboards. Lets begin...

______________________________________________________________________

IMPORTANT: This Course Does not require a pre requisite completion of my old course Excel Dashboard Secrets. The Old course consist of 18 Dash boards and new course consist of 20 dashboards all dashboards are DISTINCT from each other.

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:

  1. Advance formulas and Functions
  2. Learn to analyse the data
  3. Learn to present the data in effective format
  4. Learn to do complex excel task in a simpler way
  5. Learn secrets of Charting
  6. Learn Interactive Elements (Combo boxes, List boxes , Check boxes …)
  7. Learn the effective utilization of Excel Features
  8. Learn the Principles of Dashboarding (Heat Analysis, Blur Test Analysis)

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

  1. If you need to analyse the data and find out the conclusion
  2. Your Job is to analyse the data and present it to clients
  3. Want to learn more in Excel
  4. For Managers who have to take quick and quality decisions by analyzing data
  5. For Managers who are managing the performance of the company
  6. Students who wants to learn more and advance in Excel
  7. For IT Professionals who want to develop carrier in Excel
  8. For anyone who wants to use Excel as a base to create projects and reports
  9. 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

Learning Road Map

  • Learn Creating a Panel Chart Dashboard
  • Creating a Incell Dashboard
  • Creating a KPI (Key Performance Indicator) Dashboard
  • Lesson- Selecting the right type of chart
  • Creating a Funnel Chart Dashboard
  • Creating a dynamic dashboard with timmed content
  • Create a dynamic text highlight dashboard with conditional formatting
  • Create a Histogram , Patero and cumulative chart
  • Create a Waterfall Chart
  • Create a Interactive Text Dashboard with slicer (Awesome technique, My Favourite)
  • Show Average in Chart
  • Dashboard Analysis, Heat Places Analysis, Blur Test Analysis
  • Trend Analysis Dashboard (My Best ever made dashboard)

Dashboards are ULTIMATE PRODUCTIVITY SUITES

Contents and Overview of Lectures

There are over 30 + Lectures and over 3 Hrs of content 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...

Introductory Price..... Take Action Now......

-Amey Dabholkar

Who is the target audience?
  • Any Advance or Intermediate Excel Users
  • NOT to be taken by a newbie or a beginner
  • 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
  • Data Analyst , Corporate Executive etc
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 41 Lectures Collapse All 41 Lectures 02:43:59
+
Introduction
2 Lectures 04:35

Introduction to the course.

How to continue with this course, How to ask questions and post discussion

Preview 04:24

Download All Exercise Files at Once
00:11
+
Creating a Pannel Chart Dashboard
4 Lectures 20:30
Download the Exercise Files
00:32

Panel Charts are easiest way to represent multiple charts data into one chart. Practically this is used most common in todays world due to vast availiblity of data. The important requirement is that the data should be in some years and months divided

Create awesome Pannel Chart
07:48


In this lesson you would learn to create a complete dashboard from the previous 2 lesson. Complete the previous lesson first before watching this lecture

Complete your dashboard by adding interactive Element
07:21
+
Incell Chart Dashboard
2 Lectures 05:14

Instructions regarding Using Exercise Files:

You have 2 options you could download Exercise files

1. Download all in a zip file which is available in section 1

2. Download individual lectures files.

File Format.

For Non Macro workbook is .xlsx which can be easily downloaded

For Macro Workbook .zip (it contains macro file) Udemy does not allow to upload macro file !

Exercise files are the completed Exercise files. IF you want to practice it then delete the procedure and recreate the file.

Use your own data and experiment it to create dashboard !

Make your Dashboard Creating Experience enjoyable. Post your created dashboard onto the forum i,e udemy question answer system and then get feedback from me.

Start learning !

Warm Greetings

Download the Exercise Files
00:28

Create an Incell Chart Dashboard
04:46
+
Create KPI (Key Performing Indicators) Scroll Dashboard
2 Lectures 12:54
Download the Exercise Files
00:28

+
Choose the right type of chart - Resource
2 Lectures 10:23
Download the Resource File used in the Lecture
00:04

Choose the right type of Chart - Video Explanation
10:19
+
Create a Funnel Chart Dashboard
2 Lectures 04:07
Download the Exercise Files
00:28

+
Created Dynamic Chart with Timmed Content
2 Lectures 05:52
Download the Exercise Files
00:28

Create Dynamic Chart with Timmed Content
05:24
+
Dynamic Text Highlight Dashboard using Conditional Formatting
2 Lectures 10:43
Download the Exercise Files
00:28

Dynamic Text HIghlight Dashboard
10:15
+
Histogram with Patero and Cumulative Chart and table with Analysis tookpack
2 Lectures 12:35
Download the Exercise Files
00:28

Create a Histogram with Patero and Cumulative Data and Chart
12:07
+
Histogram and Patero in Excel 2016 with advance options
2 Lectures 06:16
Download the Exercise Files
00:28

Histogram and Patero in Excel 2016 with advance options
05:48
10 More Sections
About the Instructor
Amey Dabholkar
4.2 Average rating
86 Reviews
1,897 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