Visually Stunning Microsoft Excel Dynamic Dashboard Course

Focused View

The Dronaachaarya

6:46:14

160 View

1. Introduction

1. Introduction to the Course.mp4

03:34

2. Tips to Know Before You Begin.mp4

11:20

2. Basic Level Dashboards

1.1 Dynamic-Dashboard-Basic - New.xlsx

1. Repeat Dashboard.mp4

10:29

2. Double Doughnut Dashboard.mp4

07:16

3. Pie in Pie.mp4

06:42

4. Tornado Chart.mp4

13:55

5. Heatmap Chart.mp4

04:26

6. Bullet Charts.mp4

11:59

7. WFM Chart.mp4

12:36

8. Within Cell Dashboard.mp4

09:28

9. Funnel Pyramid Chart.mp4

09:28

10. Sparkline Dashboard.mp4

12:46

11. Sunburst and Treemap Charts (Excel 2016).mp4

09:57

3. Intermediate Level Dashboards

1.1 Dropdown Chart - Raw Data.xlsx

1.2 Dropdown Chart.xlsx

1. Dropdown Dashboard.mp4

10:08

2.1 Target Achievement Dashboard - Raw Data.xlsx

2.2 Target Achievement Dashboard.xlsx

2. Target Achievement Comparison Chart.mp4

14:41

3.1 All in One Dashboard - Completed.xlsx

3.2 All in One Dashboard - Raw Data.xlsx

3. All in One Chart.mp4

33:55

4. Advanced Level Dashboards

1.1 Sales Comparison Dashboard New - Raw Data.xlsx

1.2 Sales Comparison Dashboard New.xlsx

1. Productwise Comparison Sales Dashboard - Part 1.mp4

22:03

2. Productwise Comparison Sales Dashboard - Part 2.mp4

11:58

3. Productwise Comparison Sales Dashboard - Part 3.mp4

24:15

4. Productwise Comparison Sales Dashboard - Part 4.mp4

12:49

5. Introduction to Multiple KPI Dashboard.mp4

03:38

6.1 All in One KPI Dashboard - Raw Data.xlsx

6.2 All in One KPI Dashboard.xlsx

6. Multiple KPI Dashboard 1.mp4

14:30

7. Multiple KPI Dashboard 2.mp4

22:44

8. Multiple KPI Dashboard 3.mp4

14:45

9. Introduction to the Call Center Dashboard.mp4

04:32

10.1 Callcenter new - Raw Data.xlsx

10.2 Callcenter new.xlsx

10. Call Center Dashboard 1.mp4

22:42

11. Call Center Dashboard 2.mp4

15:39

12. Call Center Dashboard 3.mp4

23:50

13. Call Center Dashboard 4.mp4

14:36

14.1 Callcenter new - Raw Data.xlsx

14.2 Callcenter new - Version 2.xlsx

14. Call Center Dashboard - Version 2.mp4

15:33

15. Congratulations - You are Now a Excel Dashboard Ninja..html

Description

Become an Excel Dashboard Expert : 11 Basic, 3 Intermediate and 4 Advanced Level Dynamic Dashboards without any VBA code

What You'll Learn?

The Art of creating Visually Stunning Excel Dashboards.
You will start with 11 Basic Level Dashboards and gradually move to 3 Intermediate and 4 Advanced Level Charts.
Practicing the charts along with the course will make you a Master of MS Excel Dashboards.

Who is this for?

This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis.

Anyone who would like to take his Excel Skills to the next level.

Anyone who is into MIS, Data Analytics and Database Management System

What You Need to Know?

Basic Working Knowledge of Microsoft Excel.

Knowing basic funtions in Excel.

More details

Description
ThisÂ course teaches you to create well-designed dynamicÂ Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.
By participating in this Microsoft ExcelÂ Dashboard course you'llÂ gain the widely sought after skills necessary to effectively analyze large sets of data.Â
In this topic, weâ€™ll discuss how to use multiple PivotTables, PivotCharts and PivotTable tools to create a dynamic excel dashboards. Then we'll give users the ability to quickly filter the data the way they want with Slicers and a Timeline, which allow your PivotTables and charts to automatically expand and contract to display only the information that users want to see. In addition, you can quickly refresh your dashboard when you add or update data. This makes it very handy because you only need to create the excel dashboard report once.
You will start with 11 Basic Level Excel Dashboards and gradually move to 3 Intermediate and 4 Advanced Level dashboard. Practicing the dashboard along with the course will make you a Master of Microsoft Excel Dashboards.
Who this course is for:
This course is meant for students who wish to create beautiful Dynamic Dashboard using MS Excel for Data Visualization and Analysis.
Anyone who would like to take his Excel Skills to the next level.
Anyone who is into MIS, Data Analytics and Database Management System

User Reviews

Rating

average 0

Total votes0

Focused display

Dronaachaarya is a group of passionate teachers who are dedicated to Quality Online Education. We know that learning is easier when you have an excellent teacher. That's why most of our educators have achieved an advanced degree in their field. Our faculty are passionate about the subjects they teach and bring this enthusiasm into their Online Courses. The Major Focus of Dronaachaarya Teachers is to embrace the pursuit of excellence both inside and outside the classroom. We encourage critical thinking and emphasize the learning process over rote memorization.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.