Excel Dashboards tips to impress your Manager
3.3 (7 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.
394 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Dashboards tips to impress your Manager to your Wishlist.

Add to Wishlist

Excel Dashboards tips to impress your Manager

Learn Excel and best practices of creating Dashboard KPI's for Data Analysis.
3.3 (7 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.
394 students enrolled
Created by Jigar Vora
Last updated 6/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Creating Management KPI's
  • Create Excel Dashboards
View Curriculum
Requirements
  • A Computer or mobile with Internet Access
  • Access to Microsoft Excel
Description

An Excel Dashboard provides insight, analysis and alerts. They’re fully interactive and dynamic and can help with project management, customer service, retail management, financial forecasting and much more.

Key features:

  • Usually fits on one page
  • Displays key trends, comparisons and data graphically or in small tables
  • Provides the reader with conclusions to their objective
  • Is often interactive allowing the user to filter data and switch views themselves
  • Employs best practices that enable the report to be updated quickly and easily (often at the click of just one button)
Who is the target audience?
  • Any Staff member who is looking to extract information from Data.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
04:29:06
+
Introduction
1 Lecture 03:29
+
Navigation & Shortcuts Within Excel
6 Lectures 02:22:00
Navigation Shortcuts - p1
26:24

If Function
28:30

Search Functions ( Lookups, Match, Index)
23:21

Arrays ( Rows , Columns , Transpose, Frequency)
23:14


Forms and Controls
21:31
+
Dashboards
9 Lectures 01:57:11


Creating Dashboard KPI Part 1
14:34

Creating Dashboard KPI Part 2
14:09

Creating Dashboard KPI Part 3
05:34

Creating Dashboard KPI Example 2 Part 1
13:13

Creating Dashboard KPI Example 2 Part 2
14:46

Creating Dashboard KPI Example 2 Part 3
12:50

+
Conclusion
1 Lecture 06:26
Conclusion
06:26
About the Instructor
Jigar Vora
3.4 Average rating
395 Reviews
22,922 Students
8 Courses
Planning Manager at Panasonic

I have a degree of Masters in Computer science and currently work as a Planning manager in the field of Logistics for a $10+ billion dollar company.

I have number of years of experience working with Directors and Vice Presidents of companies presenting them alternate solutions to optimize their supply chain network.

I also own a consulting firm Aarya Global Services currently providing consulting services for supply chain network planning and Optimization to various companies.