Data Analytics Introduction and Excel Dashboarding
3.0 (1 rating)
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.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Data Analytics Introduction and Excel Dashboarding to your Wishlist.

Add to Wishlist

Data Analytics Introduction and Excel Dashboarding

Learn how to create dynamic dashboards in Excel.
3.0 (1 rating)
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.
8 students enrolled
Last updated 6/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
  • You need to have Excel 2007 or higher installed on their computer (Some features won't work on Excel 2007)
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
37 Lectures
03:01:11
+
Introduction to Business Analytics
5 Lectures 13:51
+
Formatting Conditional Formatting
14 Lectures 54:01
Objectives
02:15

Introduction to Formatting and Conditional Formatting
02:25

Custom Formatting Conditional Formatting
00:50

Custom Formatting Example
08:19

Conditional Formatting examples
10:50

Absolute Referencing ($ use)
03:35

Logical Functions (IF Formula)
08:33

Countifs Formula
01:39

Sumifs
01:49

Vlookup
06:17

Match Formula
03:09

Index Formula
01:41

Offset Formula
01:50

Lesson Summary
00:49
+
Advanced Charting
9 Lectures 27:12
Advanced Charting
00:39

Charting Overview
01:14

Create simple chart in excel
01:03

Chart Formats
02:13

Thermometer Chart
05:17

Waterfall Chart
01:53

Pareto Chart
06:41

Speedometer chart
07:02

Summary
01:10
+
Interactive Charts
8 Lectures 32:52
Interactive charts and Dashboard components
00:38

Interactive charts overview
01:25

Form Controls
00:53

Interactive Chart with combobox
06:46

Interactive chart with checkbox
08:28

Interactive chart with scrollbar
05:45

Dynamic Chart
08:03

Summary
00:54
+
Excel Dashboarding
1 Lecture 53:15
Learning Dashboards
53:15
About the Instructor
Online Training Skillup Training
3.0 Average rating
1 Review
8 Students
1 Course
E Learning Company engaged in developing interactive courses

With rapidly changing technology and business needs in today's competitive scenario, professionals and students need a simple learning solution that helps them to acquire new skills and stay updated in their respective fields.

We are a group of Learning Consultants, Engineers and Creative Media Specialists who have joined hands to transform the conventional learning life-cycle.

We provide end-to-end learning solutions on emerging technologies such as Big Data, Analytics, and Business Intelligence. Also, ensure that you experience a world class learning that can be accessed anytime, anywhere. In addition, a seamless delivery by Industry experts to provide the best quality training for job relevant courses.