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 (10 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.
153 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 41
  • Length 2.5 hours
  • Skill Level Intermediate 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 11/2015 English

Course 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

What are the 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

What am I going to get from this course?

  • 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

What 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

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

Introduction to the course.

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

Download All Exercise Files at Once
Article
Section 2: Creating a Pannel Chart Dashboard
Download the Exercise Files
Article
07:48

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

Learn about Dynamic Labels for Creating Unique Names
Preview
04:49
07:21

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

Section 3: Incell Chart Dashboard
Article

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

Create an Incell Chart Dashboard
04:46
Section 4: Create KPI (Key Performing Indicators) Scroll Dashboard
Download the Exercise Files
Article
Create KPI Dashboard
Preview
12:26
Section 5: Choose the right type of chart - Resource
Download the Resource File used in the Lecture
Article
Choose the right type of Chart - Video Explanation
10:19
Section 6: Create a Funnel Chart Dashboard
Download the Exercise Files
Article
Create a Funnel Chart Dashboard in Excel
Preview
03:39
Section 7: Created Dynamic Chart with Timmed Content
Download the Exercise Files
Article
Create Dynamic Chart with Timmed Content
05:24
Section 8: Dynamic Text Highlight Dashboard using Conditional Formatting
Download the Exercise Files
Article
Dynamic Text HIghlight Dashboard
10:15
Section 9: Histogram with Patero and Cumulative Chart and table with Analysis tookpack
Download the Exercise Files
Article
Create a Histogram with Patero and Cumulative Data and Chart
12:07
Section 10: Histogram and Patero in Excel 2016 with advance options
Download the Exercise Files
Article
Histogram and Patero in Excel 2016 with advance options
05:48
Section 11: Waterfall Chart in Excel 2016
Download the Exercise Files
Article
Create a Waterfall Chart in Excel 2016
05:43
Section 12: Interactive Text Dashboard with Slicers
Download the Exercise Files
Article
Interactive Text Dashboard with Slicers
06:17
Section 13: Average Depicting Column Chart Dashboard
Download the Exercise Files
Article
Average Depicting Column Chart Dashboard
05:17
Section 14: Dashboard Analysis, Heat Map Analysis, Blur Test Analysis
Download the Exercise Files
Article
Dashboard Analysis, Heat Map Analysis, Blur Test Analysis
12:41
Section 15: Change Chart Type via a button
Download the Exercise Files
Article
Change Chart Type via a button
05:57
Section 16: Get Results from Data Presented in a chart
Download the Exercise Files
Article
Get Results from Data Presented in a chart
07:46
Section 17: Smoothed the data and depict in the chart
Download the Exercise Files
Article
Smoothed the data and depict in the chart
06:27
Section 18: Complete Trend Analysis Dashboard
Download the Exercise Files
Article
Complete Trend Analysis Dashboard
12:38
Section 19: Quick Tips to make your dashboard creation process Faster
Quick Tip #1 Delete Blank Rows
01:41
Section 20: Home Work File - Create Population Analysis Dashboard
Home Work File Population Analysis Download
Article
Home Work Guidance Video
01:40

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