Buying for a Team? Gift This Course
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 (6 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.
391 students enrolled
Created by Jigar Vora
Last updated 6/2014
$10 $20 50% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Creating Management KPI's
Create Excel Dashboards
View Curriculum
  • A Computer or mobile with Internet Access
  • Access to Microsoft Excel

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
Expand All 17 Lectures Collapse All 17 Lectures 04:29:06
1 Lecture 03:29
Navigation & Shortcuts Within Excel
6 Lectures 02:22:00
Navigation Shortcuts - p1

If Function

Search Functions ( Lookups, Match, Index)

Arrays ( Rows , Columns , Transpose, Frequency)

Forms and Controls
9 Lectures 01:57:11

Creating Dashboard KPI Part 1

Creating Dashboard KPI Part 2

Creating Dashboard KPI Part 3

Creating Dashboard KPI Example 2 Part 1

Creating Dashboard KPI Example 2 Part 2

Creating Dashboard KPI Example 2 Part 3

1 Lecture 06:26
About the Instructor
3.5 Average rating
311 Reviews
21,953 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.

Report Abuse