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
Fundamentals of Creating Dashboards
Dynamic Dashboard vs. Static Report
Dashboards Start to Finish
The Three Layers of Creating Dashboards
Sorting Data I
Sorting Data II
Fundamentals of Creating Dashboards
Dynamic Dashboard vs. Static Report
Dashboards Start to Finish
The Three Layers of Creating Dashboards
Sorting Data I
Sorting Data II
Data Sources
Grouping Data I
Grouping Data II
Data Analysis
Pivot Table
Applications on Pivot Table
Pivot Chart
How to Use Pivot Tables
Filter vs. Slicer Tools
Timeline Tool
Advanced Data Analysis Tools
Drill Down Data: Dates
Drill Down Data: Locations
Drill Down Data: Ages
"Show Value As" Tool I
Pie Chart
"Show Value As" Tool II
Year to Date (YTD)
Adding a Calculation to the Pivot Table
Dashboard Demo I
Dashboard Demo II
Color Coding: Calculating Progress I
Color Coding: Calculating Progress II
Calculating Sales
Combo Chart
Bar Charts
Grouping Bar Charts
Choosing the Suitable Sales Chart
Contribution Percent
Inserting Textboxes
Connecting Textboxes and Pivot Tables
Slicer Tool
Sales Analysis: Product
Inserting Form Control
Dynamic Chart Demo
Inserting Form Control II
Infographic
Dynamic Photos
Filtering Data
Adding Filtering Buttons
Dashboard Final Touches
Multiple Dashboard Screens
Protecting Dashboards
Saving Dashboards
Wrap Up
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.
Course requirements and prerequisites
You must have Microsoft Excel installed on your device
Mentor
Mina Mourad
Microsoft Certified Learning Consultant and Certified Trainer
3,254 Learners
1 Course