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.
388 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 17
  • Length 4.5 hours
  • Skill Level All Levels
  • 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 6/2014 English

Course 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)

What are the requirements?

  • A Computer or mobile with Internet Access
  • Access to Microsoft Excel

What am I going to get from this course?

  • Creating Management KPI's
  • Create Excel Dashboards

What is the target audience?

  • Any Staff member who is looking to extract information from Data.

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
Course Overview
Preview
03:29
Section 2: Navigation & Shortcuts Within Excel
Navigation Shortcuts - p1
26:24
If Function
28:30
Search Functions ( Lookups, Match, Index)
23:21
Arrays ( Rows , Columns , Transpose, Frequency)
23:14
Pivot Table & Slicer
Preview
19:00
Forms and Controls
21:31
Section 3: Dashboards
Introduction to Dashboard
Preview
14:53
Process of Creating a Dashboard
Preview
12:48
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
Sample of some Good Dashboards
Preview
14:24
Section 4: Conclusion
Conclusion
06:26

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jigar Vora, 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.

Ready to start learning?
Take This Course