Creating & Managing Interactive Dashboards Using Excel

categories: Business Management | Technology, Science & Productivity

Data

Software

MS Excel

SDG 9: Industry, Innovation and Infrastructure

By the end of this course, you will be able to

How to professionally handle all types of data, cleaning, arranging, and preparing them for data analysis work, and using Excel in converting it into statistics.
The Fundamentals of creating dashboards, understand the difference between a dynamic dashboard and static report, and all phases of dashboard creation.
How to transform data into an interactive dashboard with advanced technologies that provide you with all information you need to make decisions quickly and easily.

Course details

4 h 29 m/51 lessons
Last updated: 18/1/2021
1 learning resources
Course completion certificate

Course Content

Free lessons

Fundamentals of Creating Dashboards

4 Minutes

Dynamic Dashboard vs. Static Report

2 Minutes

Dashboards Start to Finish

4 Minutes

The Three Layers of Creating Dashboards

2 Minutes

Sorting Data I

5 Minutes

Sorting Data II

14 Minutes

1. Creating & Managing Interactive Dashboards Using Excel

Fundamentals of Creating Dashboards

4 Minutes

Dynamic Dashboard vs. Static Report

2 Minutes

Dashboards Start to Finish

4 Minutes

The Three Layers of Creating Dashboards

2 Minutes

Sorting Data I

5 Minutes

Sorting Data II

14 Minutes

Data Sources

6 Minutes

Grouping Data I

5 Minutes

Grouping Data II

6 Minutes

10.

Data Analysis

13 Minutes

11.

Pivot Table

5 Minutes

12.

Applications on Pivot Table

7 Minutes

13.

Pivot Chart

5 Minutes

14.

How to Use Pivot Tables

4 Minutes

15.

Filter vs. Slicer Tools

8 Minutes

16.

Timeline Tool

3 Minutes

17.

Advanced Data Analysis Tools

5 Minutes

18.

Drill Down Data: Dates

5 Minutes

19.

Drill Down Data: Locations

3 Minutes

20.

Drill Down Data: Ages

2 Minutes

21.

"Show Value As" Tool I

3 Minutes

22.

Pie Chart

3 Minutes

23.

"Show Value As" Tool II

3 Minutes

24.

Year to Date (YTD)

2 Minutes

25.

Adding a Calculation to the Pivot Table

3 Minutes

26.

Dashboard Demo I

4 Minutes

27.

Dashboard Demo II

8 Minutes

28.

Color Coding: Calculating Progress I

5 Minutes

29.

Color Coding: Calculating Progress II

5 Minutes

30.

Calculating Sales

4 Minutes

31.

Combo Chart

7 Minutes

32.

Bar Charts

5 Minutes

33.

Grouping Bar Charts

5 Minutes

34.

Choosing the Suitable Sales Chart

7 Minutes

35.

Contribution Percent

5 Minutes

36.

Inserting Textboxes

4 Minutes

37.

Connecting Textboxes and Pivot Tables

1 Minutes

38.

Slicer Tool

7 Minutes

39.

Sales Analysis: Product

4 Minutes

40.

Inserting Form Control

7 Minutes

41.

Dynamic Chart Demo

6 Minutes

42.

Inserting Form Control II

3 Minutes

43.

Infographic

3 Minutes

44.

Dynamic Photos

8 Minutes

45.

Filtering Data

5 Minutes

46.

Adding Filtering Buttons

6 Minutes

47.

Dashboard Final Touches

3 Minutes

48.

Multiple Dashboard Screens

4 Minutes

49.

Protecting Dashboards

3 Minutes

50.

Saving Dashboards

1 Minutes

51.

Wrap Up

1 Minutes

learning resources

About this course

In the current era, data is the new oil. To achieve real benefit from the data, it must be transformed into clear and understandable information. Not only this, but we must also review the information in the form of an interactive dashboard that reviews all information, comparisons, and performance in a way that facilitates reading and making decisions faster. The course starts with the best practices of handling data, cleaning and improving it, ad analyzing data using specialized analysis tools inside Microsoft Excel.