Build an interactive Human Resources Dashboard in Microsoft Excel - HR Dashboard
Download the practice files used in this video along with full access to this course from Udemy
Microsoft Excel Data Analysis - Create Excel Dashboards
https://www.udemy.com/course/learn-ex...
Microsoft Excel - Data Analysis with Excel Pivot Tables
https://www.udemy.com/course/learn-ex...
--------------------------------------------------------------------------------------------------------------------
Video Timeline
[00:04] - Introduction & Dashboard Preview
[01:06] - Understanding the Raw HR Data
[02:46] - Formatting Data as an Excel Table
Part 1: Employee Demographics (Donut & Treemap Charts)
[03:21] - Creating Pivot Table 1: Employees by Gender
[05:52] - Building the Gender Donut Chart
[07:19] - Adding Custom Icons (Male/Female) to the Chart
[14:39] - Creating Pivot Table 2: Employees by Department
[17:05] - Building the Department Treemap Chart
Part 2: Employment Status Analysis (Bar Charts)
[19:44] - Creating Pivot Table 3: Hire Type (Contract vs. Permanent)
[20:31] - Building the Hire Type Bar Chart
[24:51] - Creating Pivot Table 4: Employee Status (Active, Leave, Notice)
[25:26] - Building the Employee Status Bar Chart
[28:57] - Creating Pivot Table 5: Employee Designations
[29:50] - Building the Designation Bar Chart
Part 3: Financial Metrics (Expense Analysis)
[33:09] - Creating Pivot Table 6: Total Employee Expenses (Salary, Bonus, OT)
[34:01] - Building the Overall Expense Bar Chart
[38:30] - Creating Pivot Table 7: Expenses by Department
[40:02] - Calculating Total Expense Sums
[40:37] - Building the Departmental Expense Chart
Part 4: Performance & Health (Speedometer Charts)
[43:57] - Creating Pivot Table 8: Average Sick Leave
[46:40] - Setting up Helper Tables for the Speedometer Logic
[49:57] - Building the Speedometer Chart (Donut + Pie Combo)
[59:02] - Creating Pivot Table 9: Average Employee Rating
[01:01:48] - Building the Employee Rating Speedometer
Part 5: Interactivity & Final Polish
[01:08:08] - Adding Slicers (Filters) to the Dashboard
[01:11:21] - Connecting Slicers to All Charts (Report Connections)
[01:13:30] - Final Dashboard Testing & Conclusion
--------------------------------------------------------------------------------------------------------------------
Excel Data Analysis Masterclass with Excel Dashboards - Learn Data Analysis and Data Visualization with Excel Dashboard.
In this course we will cover topics like Excel Data Analysis and Data Visualization with Excel Pivot Tables, Excel Pivot Charts and 5 Interactive and Excel Dashboard.
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 Dashboards and Report template in Excel
You will learn how to design, style and format aspects of Excel 2019 are applied on Excel charts
You will use the dynamic graphical representation to display your complex data in an impressive way.
Impress management with reports and dashboards that make the decision-making process faster
Actionable Excel Tips which you can use now to Create Eye-Catching Microsoft Excel Dashboard
Learn the Secrets to Building Excel Dashboards
Use of Excel core functionality for responsive spreadsheets
Create impressive, non-standard Excel charts using smart techniques
Build Pivot Table-based interactive dashboards for dynamic usage
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 Dashboard using Charts, Design and Style Elements. You can use either Microsoft Excel 2010, Excel 2013, Excel 2016 or Excel 2019 for this learning.
Topics Covered
Build an interactive Sales Dashboard in Microsoft Excel
Build an interactive Human Resources Dashboard in Microsoft Excel
Build an interactive Website Analytics Dashboard in Microsoft Excel