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.2 (31 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.
740 students enrolled
$30
Take This Course
  • Lectures 25
  • Contents Video: 2 hours
    Other: 2 mins
  • 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 3/2015 English

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





What are the requirements?

  • Internet Connection
  • Intermediate level or Advanced Knowledge of Excel

What am I going to get from this course?

  • 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.

What is the target audience?

  • MIS Analyst, Financial Analyst, Business Analyst.
  • Intermediate Excel Users.
  • Any person who want to learn Excel Charting.

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: Getting Started
Introduction
Preview
01:46
1 page

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

Section 2: Custom Formatting
06:40

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

02:17

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

09:19

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

1 question

Section 3: How to Create Chart in Excel
02:05

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

07:08

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.

Section 4: Chart Formatting Excercises
07:37

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

05:27

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.

04:47

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.

Section 5: Formulas
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
Section 6: Interactive chart with Form Controls
09:12

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.

10: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.

07:14

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

07:50

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.

Section 7: Dashboard Designing
04:39

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

19:43

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

04:05

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

05:37

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Data Consultant Lokesh Paliwal, 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.


    Ready to start learning?
    Take This Course