Excel Dashboard - Interactive Excel Dashboard and Charts
4.6 (41 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.
785 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Dashboard - Interactive Excel Dashboard and Charts to your Wishlist.

Add to Wishlist

Excel Dashboard - Interactive Excel Dashboard and Charts

Learn how to create Interactive Charts and Dashboard Designing in Excel, Which is in lot of demand these days.
4.6 (41 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.
785 students enrolled
Last updated 9/2015
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
How to create Dynamic and Interactive Charts in Excel from basics
How to create Form Controls
Create Interactive Charts in Excel with Form Controls
Learn Excel techniques by creating dashboards
Create your own Sales Dashboard
Understand how to use Vlookup, Hlookup, Index, Match and Offset functions
Understand how to use SUMIFS function
Streamline your own reports and reports of others.
This course will help you create dynamic, interactive charts in microsoft excel using excel form controls. On each exercise you will learn how to create customize charts in excel and create awesome reports in excel.
View Curriculum
Requirements
  • Internet Connection
  • Intermediate level or Advanced Knowledge of Excel
Description

This course will help you to create dynamic, interactive charts in excel using excel form controls. In each exercise you will learn how to create customize charts in excel and create awesome reports in excel.

You will get one course workbook and sample dashboard to do pratice in this course. In my sample workbook, you will also get the step by step guide to create the Interactive and dynamic charts in excel.

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.

Topics which we will cover in our exercise are:

1) How to create Chart in Excel

2) Tips about Chart Formatting

3) Form controls

4) Interactive Charts in Excel

5) How to Design Dashboard

So go ahead and learn from the following in depth Interactive Charts in excel.





Who is the target audience?
  • MIS Analyst, Financial Analyst, Business Analyst.
  • Intermediate Excel Users.
  • Any person who want to learn Excel Charting.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 25 Lectures Collapse All 25 Lectures 02:12:44
+
Getting Started
2 Lectures 01:46

In this lecture you can download the sample excel workbook for each lecture.

Working File: Download This first
1 page
+
Custom Formatting
3 Lectures 18:16

This lecture will help you to understand custom formatting with examples of Date, Large Numbers and Colors.

Preview 06:40

This lecture will help you to understand the relative and absolute referencing.

Preview 02:17

Conditional Formatting helps you to change the appearance of a cell, when cell met certain criteria or rules.

Conditional Formatting
09:19

Cell Referencing
1 question
+
How to Create Chart in Excel
2 Lectures 09:13

This lecture will teach you step by step how to create chart in excel.

How to Create Chart in Excel
02:05

This lecture will help you to understand the chart formatting like how to format vertical and horizontal axis. How to Change chart color. How to adjust the vertical axis units.

Chart Formatting
07:08
+
Chart Formatting Excercises
3 Lectures 17:51

This lecture teaches you how to create thermometer chart in excel. A thermometer charts shows you how much of a goal has been achieved.

Thermometer Chart
07:37

Pareto Analysis is a statistical technique in decision-making used for the selection of a limited number of tasks that produce significant overall effect. It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the entire job.

This lecture will guide you step by step how to create Pareto Chart in Excel.

Pareto Analysis Chart
05:27

In this lecture, you will learn how to create population pyramid chart in excel. Topics we will cover in this exercise are, How to create 2D Bar Chart, how to format axis labels of vertical axis and how to format font in horizontal axis.

Population Pyramid Chart
04:47
+
Formulas
7 Lectures 15:06
Formulas Working File: Download This First
1 page

How to use Vlookup Formula
02:30

Hlookup Formula
02:42

Find relative position of an item from Match formula
02:26

How to use Excel Index function
02:09

Offset Formula
02:50

Sumifs Formula
02:29

Formulas Quiz
5 questions
+
Interactive chart with Form Controls
4 Lectures 34:28

In this lecture you will learn how to create combo box, how to write "HLookup Formula" and how to create Interactive chart with combo box.

Interactive Chart with Combobox
09:12

This lecture will teaches you how to create and link check boxes with chart in excel. You will also learn how to write "IF Formula" in Excel.

Interactive Chart with Checkboxes
10:12

In this lecture you will learn how to create Chart with Scroll bar and how to write "Index Formula" in excel.

Interactive Chart with Scroll Bar
07:14

Speedometer chart is the combination of Doughnut and Pie Chart. you will learn in this lecture how to create doughnut and Pie chart and how to combine them into single chart to create Speedometer Chart.

Speedometer Chart with Spin Button
07:50
+
Dashboard Designing
4 Lectures 34:04

In this lecture you will understand the data set and KPI's(Key Performance Indicator) which we will designs in dashboard sheet.

Dashboard Introduction
04:39

In this lecture you will learn how to create 2D stacked bar chart with combo box.

Dashboard Design - 2D Stacked Bar Chart with Combo boxes(Sketch 1)
19:43

This is the example of Column chart with secondary line chart axis.

Dashboard Design - Region wise Chart
04:05

In this lecture you will create Productwise chart and will give the final touch to the dashboard.

Dashboard Design - Product wise Chart
05:37
About the Instructor
Data Consultant Lokesh Paliwal
4.6 Average rating
49 Reviews
1,363 Students
2 Courses
Consultant, Blogger and Trainer

I am the founder of ExcelCrazy and has worked with prestigious companies like Cisco, Sapient in the past 8 years as Data Consultant. Now working as full time trainer(Excel, VBA, SAS and Tableau) and Data consultant.

  •  
  • – A dynamic professional with experience in Data Analytics for Network Solutions, Banking and Business Outsourcing industries. 8 plus Years of experience in Data Management/ MIS / Quality Control/ Dashboards/ Analytics.
  •  
  • – Hands on expertise in development of automation tools and dashboard based on Excel, VBA, MS Access, SQL for different domains include Supply Chain, Leasing, Business outsourcing.
  •  
  • – Hands on experience in different Analytics Techniques includes Cluster Analysis, Factor Analysis and Regression Analysis. Worked on Data Analytics, Supply Chain, Operational Analytics and Digital Analytics with focus on Finance, Supply Chain and Outsourcing clients in Asia, Australia and United States.
  •  
  • – Have used different statistical flat forms like SAS, SQL, Excel, VBA, Tableau, OBI(Oracle Business Intelligence).
  •  
  • – Trained and coached several client teams and various individuals on Data Analytics tools and techniques as part of part of capability building programs.