Create an Interactive Excel Dashboard A to Z for Analytics
3.1 (8 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.
3.1 (8 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
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Microsoft Excel 2010+ (Some tricks requires 2013+)
  • Learn / Revise the basics and intermediate concepts in Excel
Description

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
42 Lectures
03:01:16
+
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
00:02



Building Up and Down Indicators on Charts
02:06

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

Bar Sparkline an Win and Loss Sparkline
06:09

Pie chart and formatting tips
04:04

Two-axis charts
03:55

Thermometer chart
02:39

Stacked Chart
04:39

Spider chart
02:48

Bubble chart
01:42

Bullet chart
03:41

Showing forecasting with line chart
03:27

Waterfall - New Charts in 2016
03:18

Format Specific Period, Data Point, Marker, XY, Positive and Negative
03:45

Conditional Formatting in Graph
02:14

Histogram Chart
04:32
+
Level 3
6 Lectures 31:13
VLOOKUP and HLOOKUP
08:59

MATCH and CHOOSE
03:06

INDEX Function
02:45

Indirect Function
03:09

Pivot tables basics
06:11

Pivot charts basics
07:03
+
Level 4
5 Lectures 17:53
Form Control with example
06:13

Check box controlled graph
02:58

List controlled graph
02:53

Chart with interactive legend
02:44

Graphs using macro
03:05
+
Level 5
7 Lectures 35:26
Overview of Dashboard
02:06

Identifying of Unique items for a dashboard
03:35

How to make lists in a dashboard
02:47

Building dashboard basic layout and formatting tips
04:13

Linking values in dashboard
05:34

Using Dynamic functions
04:08

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

Dashboard Tours
10:01

Graphs Tours
05:38
+
Level Up
1 Lecture 00:54
Level up your skill with advanced learning program
00:54
About the Instructor
Yoda Learning
4.3 Average rating
1,464 Reviews
35,349 Students
49 Courses
MS OFFICE & PMP | Join 32K+ 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
529 Reviews
9,291 Students
29 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.