Learn Excel Data Analysis with Interactive Excel Dashboards

Create 6 Excel Dashboards - Learn Excel Data Analysis & Data Visualization with Excel Functions

5.0

Course in English

30 days Money Back Guarantee
Certificate of Completion
More than 5 hours of content
Additional Material
Lifetime
access

Teacher: SkillsOnDemand

Details

Description

Excel Dashboard- Excel Data Analysis and Data Visualization with Excel Pivot Tables, Excel Pivot Charts and 6 Interactive and Dynamic Excel Dashboards. Microsoft Excel 2010, Excel 2013 and Excel 2016.

Excel Charts and Excel Graphs are one of most
powerful features of Microsoft Excel which allows the users to represent
numerical data in Graphical Data Visualization format so that end user gets a better view
of the Information discussed.

In this course

You will learn the Excel Pivot Table and Excel Pivot Chart
Function in detail and you will learn how to create Dynamic Excel Charts
and Excel Graphs.

You will Learn to create 6 Dynamic Sales Dashboard in Excel

You will learn how to design, style and format aspects of Excel 2016 are applied on Excel charts

You will use the dynamic graphical representation to display your complex data in an impressive way.

This Course is structured in 30 Plus chapters and you will learn all the aspects of Excel Dashboard in depth .

We will go through, steps in detail to create 6 Dynamic Excel Dashboards using Charts, Design and Style Elements.

So Let the Show begin!

View full description Hide full description

Objectives

You will learn about Pivot Tables and Pivot Chart
You will learn to create 6 Dynamic Excel Dashboard
You will learn how to Design, Format and Style Data Elements
Learn the Concepts of How to Create and Design an Interactive Excel Dashboard
Learn Data Analysis using Excel

Instructional level

Advanced

Requirements

Basic Excel Knowledge
This Course is created on Excel 2016, You can also use Excel 2010 and above
Interest to Learn and Upgrade Your Skillset
A Windows PC where Microsoft Excel is Installed

Who should take this online course

If you want to learn data analysis

If you are looking to improve your Microsoft Excel Skills

If you want to learn how to create Excel Charts, Formulas and Functions and Excel Shortcuts

If you want to learn foundation of how to create Excel Dynamic Dashboards

If you create Management Reports or MIS

Anyone who works with Excel on a regular basis

Chapter 1: We Welcome You - A Fast Paced Course to Learn and Apply New Skills in Less Time
- 1 Introduction - Microsoft Excel Data Analysis with Dynamic Excel Dashboard course 03:49 min
  
  DescriptionYou made the right decision by joining this course to learn how to create Dynamic Dashboards for your Data Analysis and Data Visualization. This is a Fast Paced Series of Course to Learn new Skillset.
- 2 Quickly Dowload Course Files and Let's get Started. 00:03 min
  1
Chapter 2: Learn to Create a Dynamic Microsoft Excel Sales Dashboard - Project 1 of 6
- 1 Create Pivot Tables to Categorize Data for creating Pivot Charts & Dashboards 09:02 min
- 2 Create Pivot Charts to represent your data in a Dynamic Dashboard 13:35 min
- 3 Add Design & Style , Slicers, Time Line, Gender Charts etc in Sales Dashboard 15:57 min
Chapter 3: Learn to Create a Dynamic Microsoft Excel Sales Dashboard - Project 2 of 6
- 1 Create Pivot Tables , to categorize & Structure your data to create Pivot Charts 14:30 min
- 2 Create Pivot Charts and Slicers & add Design & Style Elements to Your Dashboard. 16:34 min
Chapter 4: Learn to Create a Dynamic Microsoft Excel Sales Dashboard - Project 3 of 6
- 1 Create an Excel Dashboard that shows product Sales of two Brands over the years 10:48 min
- 2 Excel Charts for Interactive Excel Dashboard 1 10:14 min
- 3 Excel Charts for Excel Dashboards 07:20 min
- 4 Excel Slicers for Interactive Excel Dashboard 14:41 min
Chapter 5: Create a Dynamic HR Dashboard - Project 4 of 6
- 1 Excel Pivot Table and Excel Pivot Chart that display Employees by Gender details 14:31 min
- 2 Excel Pivot Table & Excel Pivot Chart to display Employees by Department details 05:05 min
- 3 Excel Pivot Table & Excel Pivot Chart to display Employee Hire types details 05:08 min
- 4 Excel Pivot Table & Pivot Chart to display Employee Status (Active/Inactive) 04:05 min
- 5 Excel Pivot Table & Excel Pivot Chart to display Employee Designation Types 04:11 min
- 6 Excel Pivot Table & Pivot Chart to display Employee Expense by all departments 05:20 min
- 7 Excel Pivot Table & Pivot Chart to display Employee Expense by all departments 05:26 min
- 8 Pivot Table & Pivot Chart to display Average Sick Leaves (Various Departments) 15:08 min
- 9 Pivot Table & Pivot Chart to display Average Employee Rating -Various Department 09:06 min
- 10 Make Your Chart dynamic and interactive using Excel Slicers, Design & Style 06:46 min
Chapter 6: Create a Dynamic Web Analytics Dashboard - Project 5 of 6
- 1 Introduction to Excel Dashboard tutorial 02:13 min
- 2 Data used in this Dashboard 02:04 min
- 3 Create your first Excel Pivot Table and Pivot Chart for Dynamic Dashboard 04:33 min
- 4 Create your second Excel Pivot Table and Pivot Chart for Dynamic Dashboard 04:27 min
- 5 Create your third Excel Pivot Table and Pivot Chart for Dynamic Dashboard 03:26 min
- 6 Create your fourth Excel Pivot Table and Pivot Chart for Dynamic Dashboard 02:47 min
- 7 Create your fifth Excel Pivot Table and Pivot Chart for Dynamic Dashboard 04:16 min
- 8 Create your sixth Excel Pivot Table and Pivot Chart for Dynamic Dashboard 04:48 min
- 9 Create your seventh Excel Pivot Table and Pivot Chart for Dynamic Dashboard 02:13 min
- 10 Create your eighth Excel Pivot Table and Pivot Chart for Dynamic Dashboard 02:20 min
- 11 Create your ninth Excel Pivot Table and Pivot Chart for Dynamic Dashboard 02:28 min
- 12 Create your tenth Excel Pivot Table and Pivot Chart for Dynamic Dashboard 02:24 min
- 13 Make Excel Dashboards, dynamic using dynamic excel dynamic shapes 09:25 min
- 14 Make Excel Dashboards, dynamic using dynamic excel slicers 04:55 min
Chapter 7: Create a Dynamic HR Dashboard - Project 6 of 6
- 1 Let's Learn how to create an interactive and dynamic Excel HR Dashboard 04:17 min
- 2 Create your first Pivot Table and Pivot Chart for your Interactive Dashboard 08:52 min
- 3 Create your second Pivot Table and Pivot Chart for your Interactive Dashboard 06:09 min
- 4 Create your third Pivot Table and Pivot Chart for your Interactive Dashboard 03:57 min
- 5 Create your fourth Pivot Table and Pivot Chart for your Interactive Dashboard 06:27 min
- 6 Create your fifth Pivot Table and Pivot Chart for your Interactive Dashboard 08:28 min
- 7 Create your sixth Pivot Table and Pivot Chart for your Interactive Dashboard 04:54 min
- 8 Create your seventh Pivot Table and Pivot Chart for your Interactive Dashboard 07:29 min
- 9 Create your Eighth Pivot Table and Pivot Chart for your Interactive Dashboard 06:16 min
- 10 Create your ninth Pivot Table and Pivot Chart for your Interactive Dashboard 06:13 min
- 11 Make Your Chart dynamic and interactive using Excel Slicers, Design & Style 08:32 min
Chapter 8: Thank You Note!
- 1 You have mastered the skills to create 6 Interactive Excel Dashboards 00:25 min

The Teachlr

SkillsOnDemand

Online Content Creator

Skills on Demand� is an Online Training Startup focused to provide�technical training in subject like Programming, Office Productivity and Visual Creativity. Whether you are trying to learn a new skill�from scratch or want to refresh your memory on something you have learned in the past, you have come to the right place. Join our classes to upgrade your skill set at the right pace and time convenient for you as we offer stress free E-Learning. Our courses can be watched 24/7 wherever you are

Reviews

Kevin Peter

Simple to understand, instructor has good knowledge on the subject. I will learn to create and dashboards in a simple way with this course.
Andreu Sendra Pardo

Fantastic material!