Create an Interactive Excel Dashboard A to Z for Analytics
2.8 (9 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.
43 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Create an Interactive Excel Dashboard A to Z for Analytics to your Wishlist.

Add to Wishlist

Create an Interactive Excel Dashboard A to Z for Analytics

Master the techniques to create presentable Excel dashboards.
2.8 (9 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.
43 students enrolled
Last updated 5/2017
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 2 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master technique to create dashboards from raw data
  • Use features like advanced graphs and sparklines
  • Design tips and tricks for professional excel dashboards
  • Application of Form controls to make dynamic charts
View Curriculum
  • Microsoft Excel 2010+ (Some tricks requires 2013+)
  • Learn / Revise the basics and intermediate concepts in Excel

Before you read what I have to say, see what my students are saying about my courses on Excel:

"I would like to tell you that I am very impressed with your courses so far - I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one's attention span). The other gem in your training are the shortcuts, I found no other course with the same insights." by Peter Klugsberger, Australia, ex-McKinsey & Co., served various senior roles (CEO, COO) in various companies


Excel Dashboards are a powerful tool to communicate and summarize complex Excel data. As a professional, you may have access to tons of data. But, the important aspect of decision making is drawing actionable and relevant conclusions.

If you give your boss an Excel file with customer call data 10,000 rows and 300 columns, your boss won't be able to take a decision from this raw data.You will still need to summarize this with key variables as levers so the dashboard operator can quickly draw patterns and derive conclusions.

I don’t want to make you shine for your Boss. I want you to become a BOSS. These tutorials will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.

This course will help you create Excel Dashboard from raw data. A lot of professionals work with large data but unable to draw conclusive outcome as to what is the takeaway for the management and how do you track your goals without getting lost in the data.

We start with dashboard basics where we discuss design tips, how to draw basic charts. We then go through LOOKUP functions and pivot table basics. Form controls are the essential part of any interactive dashboard. We will look at checkbox & list controlled charts and build charts using short macros

This is a project-based course where we create a intermediate-level dashboard project at the end of course with each element explained comprehensively throughout the course.


Important information before you join:

  • Once enrolled, you have unlimited, lifetime access to the course!
  • You will have instant and free access to any updates I'll add to the course.
  • I will give you my full support regarding any issues or suggestions related to the course.
  • Guided practice - over worksheets included for immediate practice
  • Access to all videos 24 x 7 - learn online from anywhere
  • 30-day money back guarantee (we want you to be 100% satisfied) 

If you have read this far, next action is JOINING this course. Invest 3 hrs. for a benefit of lifetime Ninja status on creating single sheet Excel Dashboard!

Who is the target audience?
  • MIS Analyst, Financial Analyst, Business Analyst
  • Intermediate Excel Users.
  • Any person who want to learn Excel Charts
  • This course is not meant for New or Beginner Excel users
Compare to Other Excel Dashboard Courses
Curriculum For This Course
42 Lectures
Introduction to Excel Dashboard
6 Lectures 22:42

If you like the course, PLEASE leave a review so other new students can hear about it.

If you are NOT at the 5 star level of happiness with our course, MESSAGE me with any feedback or questions!

I am HAPPY to create new lectures to help you better understand a topic and get you to that 5 STAR HAPPY LEVEL with this course!

Thanks again for joining YodaLearning!

Preview 04:08

Download Practice files

Building Up and Down Indicators on Charts

Formatting cells and tables in excel
Level 2
14 Lectures 52:33
Trend Sparkline with variations

Bar Sparkline an Win and Loss Sparkline

Pie chart and formatting tips

Two-axis charts

Thermometer chart

Stacked Chart

Spider chart

Bubble chart

Bullet chart

Showing forecasting with line chart

Waterfall - New Charts in 2016

Format Specific Period, Data Point, Marker, XY, Positive and Negative

Conditional Formatting in Graph

Histogram Chart
Level 3
6 Lectures 31:13


INDEX Function

Indirect Function

Pivot tables basics

Pivot charts basics
Level 4
5 Lectures 17:53
Form Control with example

Check box controlled graph

List controlled graph

Chart with interactive legend

Graphs using macro
Level 5
7 Lectures 35:26
Overview of Dashboard

Identifying of Unique items for a dashboard

How to make lists in a dashboard

Building dashboard basic layout and formatting tips

Linking values in dashboard

Using Dynamic functions

Calculating values based on criteria
Level 6
3 Lectures 20:37
Putting all the charts together - Dashboard conclusion -Quick Recap

Dashboard Tours

Graphs Tours
Level Up
1 Lecture 00:54
Level up your skill with advanced learning program
About the Instructor
Yoda Learning
4.4 Average rating
1,611 Reviews
37,219 Students
50 Courses
MS OFFICE & PMP | Join 40K+ Udemy Students Become 4X Faster

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).

Rishabh Pugalia
4.2 Average rating
567 Reviews
9,917 Students
31 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.